Oracle Database SQL — Question 222

Which three are true about the CREATE TABLE command? (Choose three.)

Answer options

• A. It can include the CREATE..INDEX statement for creating an index to enforce the primary key constraint.
• B. The owner of the table should have space quota available on the tablespace where the table is defined.
• C. It implicitly executes a commit.
• D. It implicitly rolls back any pending transactions.
• E. A user must have the CREATE ANY TABLE privilege to create tables.
• F. The owner of the table must have the UNLIMITED TABLESPACE system privilege.

Correct answer: B, C, E

Explanation

Option B is correct because the owner of the table needs to have enough space quota in the tablespace for the table to be created. Option C is correct as the CREATE TABLE command indeed performs an implicit commit after the execution. Option E is accurate since a user must have the CREATE ANY TABLE privilege to create tables, while options A, D, and F are incorrect as they do not align with the standard behavior of the CREATE TABLE command.