1Z0-071 practice question 23 of 35
Which two are true about creating tables in an Oracle database?
Full set: 326 questionsIn Oracle, a schema acts as a namespace for database objects. Therefore, while a table name must be unique within its own schema, different schemas can contain tables with the same name (e.g., HR.EMPLOYEES and SCOTT.EMPLOYEES). To create a table, a user must possess the appropriate system privilege. The CREATE TABLE system privilege is required to create a table in one's own schema, and the CREATE ANY TABLE system privilege is needed to create a table in another user's schema.
A: The CREATE TABLE statement syntax does not include an option to define a maximum number of rows for the table. D: The CREATE EXTERNAL TABLE statement defines metadata for a pre-existing external file; it does not create the physical file itself. E: A primary key constraint is a best practice for ensuring data integrity but is not a mandatory requirement for creating a table.
1. Oracle Database SQL Language Reference, 23c, "CREATE TABLE". Under "Prerequisites", it states: "To create a table in your own schema, you must have the CREATE TABLE system privilege. To create a table in another user's schema, you must have the CREATE ANY TABLE system privilege."
2. Oracle Database Concepts, 23c, "Schema Object Naming". This section explains that schema objects of the same type (e.g., tables) must have unique names within a schema, implying they can be non-unique across different schemas.
3. Oracle Database Utilities, 23c, "Creating External Tables". The documentation states, "You use the CREATE TABLE...ORGANIZATION EXTERNAL statement to create an external table." It describes how to map the table to an existing data source file.
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
