Oracle
1Z0-074 · Question #17
1Z0-074 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
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.)
Options
- ADependent objects of HR.EMP are automatically created for HR.EMPLOYEES.
- BHR.EMP is moved to the USERS tablespace.
- CThe column names HR.EMP and HR.EMPLOYEES are identical.
- DThe HR.EMPLOYEES table has 108 records.
- EHR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES
- FThe column order HR.EMP and HR.EMPLOYEES are identical
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.