Oracle Database SQL — Question 171

Which two are true about creating tables in an Oracle database? (Choose two.)

Answer options

• A. Creating an external table will automatically create a file using the specified directory and file name.
• B. A system privilege is required.
• C. The same table name can be used for tables in different schemas.
• D. A primary key constraint is mandatory.
• E. A CREATE TABLE statement can specify the maximum number of rows the table will contain.

Correct answer: B, C

Explanation

Option B is correct because creating tables in Oracle requires the appropriate system privileges. Option C is also correct as the same table name can be utilized in different schemas without conflict. Options A, D, and E are incorrect; external tables do not automatically create files, primary keys are not mandatory for all tables, and the CREATE TABLE statement does not allow for specifying a maximum row count.