Chapter 1

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. Cloud database b. Big Data database c. In-memory database d. Very large database

a. Cloud database

What are the components of database systems? a. Hardware, software, people, procedures, data b. Hardware, system, people, programs, data c. Software, personnel, procedures, data d. System, personnel, programs, data

a. Hardware, software, people, procedures, data

Which of the answers below is one of the advantages provided by the Database management system (DBMS)? a. Improved data sharing b. Decreased end-user productivity c. Maximized data inconsistency d. Less data integration

a. Improved data sharing

What is the result of revealing the meaning of raw facts? a. Information b. An encoded sample c. End-user data d. An encrypted bit

a. Information

April is a database administrator, she wants to provide a description of the data characteristics and the set of relationships that link the data found within the database. What should she use? a. Metadata b. End-user data c. Schemas d. Queries

a. Metadata

Which of the following is not a valid statement? a. Raw data is the collection of processed knowledge. b. Database design refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data. c. Data redundancy exists when the same data is stored unnecessarily at different places. d. A database is a shared, integrated computer structure that stores a collection of user data and metadata.

a. Raw data is the collection of processed knowledge.

A database contains how many types of data? a. Two b. Three c. One d. Four

a. Two

End-user data is _____. a. raw facts of interest to the end user b. knowledge about the end users c. accurate, relevant and timely information d. information about a specific subject

a. raw facts of interest to the end user

Most data that can be encountered are best classified as _____. a. semistructured b. unstructured c. structured d. historical

a. semistructured

Which of the following is not an advantage of a DBMS? a. Data consistency b. Complexity c. Data security d. Data retrieval

b. Complexity

One of the reasons we need database is because they are the best ways to store and manage _____. a. Information b. Data c. knowledge d. Tracking

b. Data

Which of the following is not a disadvantage of DBMS? a. Management complexity b. Data integration c. Increased costs d. Vendor dependency

b. Data integration

In explaining data, you could say that the word data covers the collection of ___ stored in the database. a. Strings b. Facts c. Texts d. Characters

b. Facts

Which of the answers below is not consider as one of the five (5) major parts of the database system? a. Procedure b. Internet c. Data d. Software

b. Internet

Unstructured data is data that exists in its __? a. Original (altered) state b. Original (raw) state c. Original (refined) state d. Original (filtered) state

b. Original (raw) state

Which of the following is not a valid statement? a. A database that is designed primarily to support a company's day-to-day operations is classified as an operational database. b. Production databases focus primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making. c. The data warehouse is a specialized database that stores data in a format optimized for decision support. d. Online analytical processing is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.

b. Production databases focus primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making.

Which of the following is not a function of a DBMS? a. Data presentation management b. User management c. Security management d. Data storage management

b. User management

Which of the answers below is one of the challenges of managing a database system? a. Reduced costs b. Vendor dependence c. Management Simplicity d. Infrequent upgrade

b. Vendor dependence

Jude is a database administrator. Jude wants to store and manage an XML database. What type of XML data should Jude plan to use? a. fully structured b. semistructured c. multistructured d. structured

b. semistructured

Which of the following statements is true? a. A DBMS is a collection of programs that manage metadata data. b. A DBMS allows the user access to the database's internal complexity. c. A DBMS is a set of processes that manage and control access to data stored in the database. d. A DBMS is knowledge database management software.

c. A DBMS is a set of processes that manage and control access to data stored in the database.

Which of the following statements best defines a record? a. A record is sets of data in related files. b. A record is a collection of fields. c. A record is a set of logically connected fields d. A record is a collection of data in files.

c. A record is a set of logically connected fields

A database management system (DBMS) can be likened to__? a. A book cabinet b. A computer file c. A very well-organized electronic filing cabinet d. A kitchen pantry

c. A very well-organized electronic filing cabinet

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. Queries b. Filters c. Data d. Information

c. Data

The options below are examples of a cloud database except? a. Google cloud b. Microsoft Azure c. Desktop database d. Amazon AWS

c. Desktop database

As a database, _____ relates to activities that make them operate more efficiently in terms of storage and access speed. a. Query Language b. An encrypted bit c. Performance tuning d. Data dictionary

c. Performance tuning

As a database administrator, which of the answers below would you consider as end-users? a. System analysts and programmers b. Database Administrators c. Sales Managers d. System Administrators

c. Sales Managers

A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. a. query b. operating system c. application d. database management system

c. application

As a database developer, how would you explain how a database structure in a DBMS is stored? a. set of key/value pairs b. collection of queries c. collection of files d. single file

c. collection of files

A workgroup database is a _____ database. a. desktop b. distributed c. multiuser d. single-user

c. multiuser

A data warehouse contains historical data obtained from the _____. a. desktop database b. enterprise databases c. operational databases d. workgroup databases

c. operational databases

The database structure itself is stored as a __? a. Unlinked files b. A single file c. Collection of metadata d. Collection of files

d. Collection of files

You need an intermediary between the user and the client's database; which of the options below would you use? a. Metadata b. End-user data c. Programming languages d. DBMS(s)

d. DBMS(s)

What is the result of redundant data in the database? a. Enforced data integrity that lead to data anomalies b. Lack of data sharing among database users c. Increased data security that leads to data access d. Data anomalies that lead to data inconsistencies

d. Data anomalies that lead to data inconsistencies

Which of the answers listed below is an example of structured data? a. Pictures stored in a computer b. PDF documents stored in a computer c. Invoices stored in a computer d. Data in an excel spreadsheet

d. Data in an excel spreadsheet

Which of the following refers to the situation where different versions of the same data are stored at different places because they were not updated consistently? a. Data integrity b. Data query c. Data dictionary d. Data redundancy

d. Data redundancy

Which of the following lists problems with file system data processing? a. Administration simplicity, answers simplicity, and lack of security b. Development complexity, administration complexity, and answers complexity c. Administration simplicity, security complexity, and answers simplicity d. Development complexity, administration complexity, and lack of security

d. Development complexity, administration complexity, and lack of security