Exercise: Database Systems

Questions for: Database Systems

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
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: E
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz