1.
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
2.
One reason to add an index is to:
3.
You have a table that contains the following data. You break the table into the following two tables. This process is referred to as:
4.
Which key uniquely identifies a row in a table?
5.
In which situation do you need to perform a restore on a database?
6.
Which command should you use to give a user permission to read the data in a table?
7.
You need to enable a new employee to authenticate to your database. Which command should you use?
8.
You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
9.
You have the following table definition:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?
10.
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?