Computer Science - Database Systems

Exercise : 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.
One-to-one relationship
One-to-many relationship
Many-to-one relationship
Many-to many relationship
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

12.
Which command(s) is(are) used to redefine a column of the table in SQL ?
ALTER TABLE
DEFINE TABLE
MODIFY TABLE
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

13.
Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
DEFINE TABLE
MODIFY TABLE
ALTER TABLE
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

14.
In SQL, the ALTER TABLESPACE command is used
to add/rename data files
to change storage characteristics
to take a tablespace online/offline
to begin/end a backup
All of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

15.
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
query language
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.