Database Systems – Section 2

11. A _____ means that one record in a particular record type may be related to more than one record of another record type.

A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to many relationship
E. None of the above

Correct Answer: B. One-to-many relationship

12. Which command(s) is(are) used to redefine a column of the table in SQL ?

A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. All of the above
E. None of the above

Correct Answer: A. ALTER TABLE

13. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

A. DEFINE TABLE
B. MODIFY TABLE
C. ALTER TABLE
D. All of the above
E. None of the above

Correct Answer: C. ALTER TABLE

14. In SQL, the ALTER TABLESPACE command is used

A. to add/rename data files
B. to change storage characteristics
C. to take a tablespace online/offline
D. to begin/end a backup
E. All of the above

Correct Answer: E. All of the above

15. The language used in application programs to request data from the DBMS is referred to as the

A. DML
B. DDL
C. query language
D. All of the above
E. None of the above

Correct Answer: A. DML

Leave A Comment?

five × five =