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

The correct answer is B. It implicitly executes a commit C. 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. Explanation/Reference: https://docs.oracle.com/html/E25494_01/tables003.htm

Administering a Multitenant Container Database

Question

Options

AIt can include the CREATE..INDEX statement for creating an index to enforce the primary key
BIt implicitly executes a commit
CA user must have the CREATE ANY TABLE privilege to create tables
DIt implicitly rolls back any pending transactions
EThe owner of the table should have space quota available on the tablespace where the table is defined
FThe owner of the table must have the UNLIMITED TABLESPACE system privilege

How the community answered

(39 responses)

A
3% (1)
B
74% (29)
D
8% (3)
E
15% (6)

Explanation

Explanation/Reference: https://docs.oracle.com/html/E25494_01/tables003.htm

Topics

#CREATE TABLE#DDL implicit commit#table privileges#tablespace quota

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice