Oracle
1Z0-074 · Question #90
1Z0-074 Question #90: Real Exam Question with Answer & Explanation
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
Question
Which three are true about the CREATE TABLE command? (Choose three.)
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
Explanation
Explanation/Reference: https://docs.oracle.com/html/E25494_01/tables003.htm
Community Discussion
No community discussion yet for this question.