QUESTION 1
Denormalization is never a good practice.
True
False
QUESTION 2
The purpose of concurrency control is:
a. preventing users from working on a database concurrently.
b. ensuring that one user’s work does not influence another user’s work inappropriately.
c. providing an opportunity for users to work on databases concurrently.
d. stopping all concurrent transactions.
QUESTION 3
Locks placed automatically by the DBMS are called:
a. implicit locks.
b. explicit locks.
c. automated locks.
d. DBMS locks.
QUESTION 4
Locks placed by the user for exclusive rights to the data are called:
a. implicit locks.
b. explicit locks.
c. user-defined locks.
d. exclusive locks.
QUESTION 5
A pointer into a set of rows that are the result set from an SQL SELECT statement is called a:
a. SQL pointer.
b. selector.
c. row pointer.
d. cursor.
QUESTION 6
Reprocessing is not typically the best method of recovery from a failure in a multiuser system.
True
False
QUESTION 7
“User-defined function” and “stored procedure” are synonyms.
True
False
QUESTION 8
The standard developed in the early 90’s to provide a DBMS-independent means for processing relational database data is:
a. ADO
b. AMP
c. ODBC
d. API
QUESTION 9
A database system that has data, programs, and personnel specializing in the preparation of data for BI processing is called:
a. a data mart.
b. an ETL system.
c. OLAP
QUESTION 10
Dimensional database use which type of design:
A. Normalized database design
B. Star schema
C. Operational database design
D. Dimensional schema
QUESTION 11
Describe the lost update problem.
QUESTION 12
What is the difference between authentication and authorization?
QUESTION 13
What is an SQL injection attack?
QUESTION 14
What are six problems with using operational data for BI processing?
QUESTION 15
What is a data mart?
QUESTION 16
What is the difference between a database and a DBMS?
QUESTION 17
What is a surrogate key?
QUESTION 18
Discuss three reasons to learn SQL even though Microsoft Access provides us with a Query Wizard?
QUESTION 19
List and describe the three types of binary relationships.
