(d) MELD
7. The SQL clause to perform a set difference operation is (b)
(a) OMIT
(b) EXCEPT
(c) REJECT
(d) DIFFER
8. DDL is used to (c)
(a) add contents to tables.
(b) define the structure of database applications.
(c) specify the structure of a database.
(d) access the contents of tables.
9. A deletion operation will _____ if the deletion leads to the violation of a referential integrity
constraint. (a)
(a) fail
(b) crash the system
(c) succeed with warning
(d) succeed without warning
10. The term query by example refers to (b)
(a) a query for SQL examples
(b) a visual query language developed by IBM
(c) example SQL queries provided by other users that can be modified to suit current needs
(d) example SQL queries provided by the DBMS that users can modify to suit their current needs
11. What information is necessary when specifying the structure of a table? (d)
(a) the name of the table and the amount of storage space to be allocated to the table
(b) the name of the table and the names of the table's attributes
(c) the name of the table, the names of the table's attributes, the data types of the table's attributes,
the formats of the table's attributes, and the maximum number of rows that the table can have
(d) the name of the table, the names of the table's attributes, the data types of attributes, and the
formats of attributes
12. What can be specified in the selection condition of a SELECT statement? (a)
(a) a Boolean operation
(b) the conditions under which the statement should be executed
(c) the time at which the selection should be performed
(d) an arithmetic operation
13. Which of the following SQL statements can be used to modify just one row (out of many
rows) in a table? (c)
(a) ALTER