Which keyword can be used in a create table statement? A. ORDER BY B. DISTINCT C. GROUP BY D. UNIQUE

Which command should you use to give a user permission to read the data in a table? A. ALLOW SELECT B. LET READ C. PERMIT READ D. GRANT SELECT

In which situation do you need to perform a restore on a database? A. when data becomes corrupted in the database B. when you need to roll back a transaction C. when you encounter an error in your application D.…

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a…

Which statement creates a composite key? A. Option A B. Option B C. Option C D. Option D

Which key uniquely identifies a row in a table? A. foreiqn B. primary C. local D. superkey

You have a table that contains the following data. You break the table into the following two tables. This process is referred to as: A. defragmentation B. normalization C. fragmentation D. denormalization

You have a table that contains the following data. Which database term is used to describe the relationship between ProductID and ProductCategory? A. Cohort B. Relationally dependent C. Deterministic D. Functionally dependent E. Compositional

The terms “bitmap,” “b-tree,” and “hash” refer to which type of database structure? A. View B. Function C. Index D. Stored procedure E. Trigger

One reason to add an index is to: A. Decrease storage space. B. Increase database security. C. Improve performance of select statements. D. Improve performance of insert statements.