Computer Science - Database Systems

Exercise : Database Systems - Section 4
11.
In SQL, which command(s) is(are) used to change a table's storage characteristics?
ALTER TABLE
MODIFY TABLE
CHANGE TABLE
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

12.
In SQL, which of the following is not a data definition language commands?
RENAME
REVOKE
GRANT
UPDATE
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

13.
Subschema can be used to
create very different, personalized views of the same data
present information in different formats
hide sensitive information by omitting fields from the sub¬schema's description
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

14.
Database management systems are intended to:
eliminate data redundancy
establish relationships among records in different files
manage file access
maintain data integrity
All of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

15.
In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
CREATE PACKAGE
CREATE SCHEMA
CREATE CLUSTER
All of the above
None of the above ;
Answer: Option
Explanation:
No answer description is available. Let's discuss.