Exercise: Database Systems

Questions for: Database Systems

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
A:
CREATE PACKAGE
B:
CREATE SCHEMA
C:
CREATE CLUSTER
D:
All of the above
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Database management systems are intended to:
A:
eliminate data redundancy
B:
establish relationships among records in different files
C:
manage file access
D:
maintain data integrity
Answer: E
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Subschema can be used to
A:
create very different, personalized views of the same data
B:
present information in different formats
C:
hide sensitive information by omitting fields from the sub¬schema's description
D:
All of the above
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
In SQL, which of the following is not a data definition language commands?
A:
RENAME
B:
REVOKE
C:
GRANT
D:
UPDATE
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
In SQL, which command(s) is(are) used to change a table's storage characteristics?
A:
ALTER TABLE
B:
MODIFY TABLE
C:
CHANGE TABLE
D:
All of the above
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz