Database Flashcards

1
Q

Set of values of qualitative or quantitative variables.

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Values stored on a passive medium like a computer disk.

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Main foundation of information, knowledge, and ultimately the wisdom for correct decisions and actions.

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Factual information such as measurements or statistics about objects and concepts.

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A unit of data.

A

Datum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data that is understood by a person.

A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

An administrative process by which the required data is acquired, validated, stored, protected, and processed, and by which its accessibility, reliability, and timeliness is ensured to satisfy the needs of the data users.

A

Data Management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Make it possible to store, organize, and retrieve information in ways that otherwise would not be possible.

A

Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A shared collection of related data used to support the activities of a particular organization.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

An organized collection of related data, typically stored on disk and accessible by possibly many concurrent users.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Manages data.

A

DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A collection of programs that enables users to create and maintain databases and control all access to them.

A

Database Management System (DBMS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A software tool to organize (create, retrieve, update, and manage) data in a database.

A

DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Primary Goal of DBMS

A

Provide an environment that is both convenient and efficient for users to retrieve and store information.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Database Models

A

Hierarchical database model
Relational model
Network model
Object-oriented database model
Entity-relationship model
Document model
Entity-attribute-value model
Star schema
The object-relational model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Components of DBMS

A

Users
Database application
DBMS
Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Why Use DBMS?

A

Faster software development
Data independence and efficiency
Uniform data management
Data integrity and security
Concurrent access and crash recovery
User-friendly query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Where is DBMS Being Used?

A

Airlines
Telecom
Universities
Sales
Banking
A website capturing user registrations
A client-tracking app for social services
A medical record system for healthcare
A personal address book in an email client
A collection of word-processed documents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Advantages of DBMS

A

Data independence
Efficient data access
Data integrity and security
Data administration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Where Can Data Be Stored?

A

Filing cabinets
Spreadsheets
Folders
Ledgers
Lists
Piles of papers on your desk

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Implicit Properties of Database

A

Represents an aspect of the real-world (miniworld or universe of discourse).

A logically coherent collection of meaningful data.

Designed, built, and populated for a specific purpose.

22
Q

Software for Database Management

A

dBase IV or dBase V

MS Access

MS Excel

23
Q

Contains one or more tables of information.

A

Relational Database

24
Q

A database with only one table.

A

Flat Database

25
Q

Contains two or more related tables.

A

Relational Database

26
Q

The most common data model.

A

Relational Database

27
Q

Tables in a relational model.

A

Relations

28
Q

The attributes in a relation.

A

Domain

29
Q

Another name for each row in a table.

A

Tuple

30
Q

Includes data about a specific instance of the entity in question.

A

Tuple

31
Q

Rows in a table.

A

Records

32
Q

Columns in a table.

A

Fields/Attributes

33
Q

A single fact.

A

Data Element

34
Q

It is an organized collection of structured information, or data, typically stored electronically in a computer system.

A

Database

35
Q

It is a programming language used by nearly all relational databases to query, manipulate, and define data, and to provide access control

A

Structured Query Language (SQL)

36
Q

Items in this database are organized as a set of tables with columns and rows.

A

Relational Database

37
Q

Information in this database is represented in the form of objects, as in object-oriented programming.

A

Object-oriented Database

38
Q

This database consists of two or more files located in different sites.

A

Distributed Databases

39
Q

A central repository for data and a type of database specifically designed for fast query and analysis.

A

Data Warehouse

40
Q

It allows unstructured and semistructured data to be stored and manipulated.

A

NoSQL or Nonrelational Database

41
Q

It stores data in terms of entities and the relationships between entities.

A

Graph Database

42
Q

It is a speedy, analytic database designed for large numbers of transactions performed by multiple users.

A

OLTP Database

43
Q

A database whose source code is open source.

A

Open Source Database

44
Q

It is a collection of data, either structured or unstructured, that resides on a private, public, or hybrid cloud computing platform.

A

Cloud Database

45
Q

It combines different types of database models into a single, integrated back end.

A

Multimodel Database

46
Q

Designed for storing, retrieving, and managing document-oriented information, and is a modern way to store data in JSON format rather than rows and columns.

A

Document/JSON Database

47
Q

It is cloud-based and use machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by database administrators.

A

Self-driving Database

48
Q

It is used to create, edit, and maintain database files and records, enabling easier file and record creation, data entry, data editing, updating, and reporting.

A

Database Software

49
Q

It is an open source relational database management system based on SQL.

A

MySQL

50
Q

Database Challenge

A

Absorbing increases in data volume

Ensuring data security

Keeping up with demand

Managing and maintaining the database and infrastructure

Removing limits on scalability

Ensuring data residency, data sovereignty, or latency requirements