题目内容

The default tablespace clause in the create user command sets the location for:

A. Database Objects created by the user
B. Temporary Objects Created By the User
C. System Objects Created by the user
D. None of the above

查看答案
更多问题

What is the difference between a unique constraint and a primary key constraint?

A unique key constraint requires a unique index to enforce the constraint, whereas the primary key constraint can enforce uniqueness using a unique key or nonunique index.
B. A primary key column can be NULL, but a unique key column cannot be NULL.
C. A primary key constraint can use an existing index, but a unique constraint always creates an index.
D. A unique constraint column can be NULL, but primary key columns cannot be NULL.

Which command is used to drop a constraint?

ALTER TABLE MODIFY CONSTRAINT
B. DROP CONSTRAINT
C. ALTER TABLE DROP CONSTRAINT
D. ALTER CONSTRAINT DROP

Which component is not part of the ROWID?

A. TABLESPACE
B. Data file number
C. Object ID
D. Block ID

What is a Schema?

A. Physical Organization of Objects in the Database
B. A Logical Organization of Objects in the Database
C. A Scheme Of Indexing
D. None of the above

答案查题题库