HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and HR executes this command:

SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp; Table created. Which two statements are true? (Choose two.)

Question

HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and HR executes this command:

SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp; Table created. Which two statements are true? (Choose two.)

Accepted Answer

C. The column names HR.EMP and HR.EMPLOYEES are identical. F. The column order HR.EMP and HR.EMPLOYEES are identical

Answer

A. Dependent objects of HR.EMP are automatically created for HR.EMPLOYEES.

Answer

B. HR.EMP is moved to the USERS tablespace.

Answer

D. The HR.EMPLOYEES table has 108 records.

Answer

E. HR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES

HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and HR executes this command: SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE…