Which command should you use to give a user permission to read the data in a table?
A named group of SQL statements that can be executed in a database is called a:
A view can be used to:
save an extra copy of data stored in a separate table.
limit access to specific rows or columns of data in a table.
ensure referential integrity.
save historical data before deleting it from the base table.
In SQL, an insert statement is used to add a:
user to a database.
row of data to a table.
table to a database.
column to a table definition.
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
Which two keys establish a relationship between two tables? (Choose two.)
First normal form requires that a database excludes:
One reason to add an index is to:
decrease storage space.
increase database security.
improve performance of select statements.
improve performance of insert statements.