Quiz1 Flashcards
What would you define as the condition in which all of the data in the database are consistent with the real-world events and conditions?
a. Data integrity
b. Data anomaly
c. Data ubiquity
d. Data quality
a. Data integrity
Which of the following is not a function of a DBMS?
a. Data presentation management
b. Security management
c. User management
d. Data storage management
c. User management
Information is produced by processing _____.
a. Data
b. Information
c. Scripts
d. Context
a. Data
Metadata is ___?
a. Data about data
b. Raw data
c. Refined data
d. Filtered data
a. Data about data
One of the advantages of database systems is that ___
a. Database systems do not integrate many different users’ data into a single all-encompassing data repository.
b. Database systems enable the data in the database to be shared among multiple applications or users.
c. Database systems maximizes data inconsistency
d. Database systems decreases end user productivity
b. Database systems enable the data in the database to be shared among multiple applications or users.
The DBMS may be referred to as the database system’s ___?
a. Brain
b. Memory
c. Spine
d. Heart
d. Heart
The database structure itself is stored as a __?
a. Collection of metadata
b. A single file
c. Unlinked files
d. Collection of files
d. Collection of files
The options below are examples of databases except?
a. Recycle database
b. Workgroup database
c. Distribution database
d. Centralized database
a. Recycle database
The term database system refers to an organization of components that define and regulate the collection, storage, management, and use of ___ within a database environment.
a. Data
b. Information
c. Filters
d. Queries
a. Data
When a database offers all the advantages of a local DBMS and resides on the internet, it is referred to as a(n) _____ database.
a. In-memory database
b. Big Data database
c. Cloud database
d. Very large database
c. Cloud database
When a database stores the majority of data in RAM rather than in hard disks, it is referred to as a(n) _____ database.
a. In-memory database
b. Big Data database
c. Cloud database
d. Very large database
a. In-memory database
Which of the answers below is an example of a single-user database?
a. Desktop database
b. Workgroup database
c. Office database
d. Enterprise database
a. Desktop database
Which of the answers below is not consider as one of the five (5) major parts of the database system?
a. Procedure
b. Software
c. Internet
d. Data
c. Internet
Which of the answers below is not one of the reasons a spreadsheet is not considered a database?
a. A spreadsheet allows for the manipulation of data in a tabular format
b. A spreadsheet does not support self-documentation through metadata
c. A Spreadsheet does not support enforcement of data types or domains
d. A Spreadsheet does not support defined relationships among tables
a. A spreadsheet allows for the manipulation of data in a tabular format
Which of the answers below is one of the advantages provided by the Database management system (DBMS)?
a. Decreased end-user productivity
b. Maximized data inconsistency
c. Improved data sharing
d. Less data integration
c. Improved data sharing