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