Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074 Exam Practice Test
HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and resides in the EXAMPLE tablespace.
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.)
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.)
Correct Answer: A,D
Vote an answer
Which two operations is the opc user authorized to perform in an Oracle Database Cloud environment?
(Choose two.)
(Choose two.)
Correct Answer: B,E
Vote an answer
Examine these parameters in a PFILE used to start database instance.
Which two statements are true after an instance restart is attempted and why? (Choose two.)
Which two statements are true after an instance restart is attempted and why? (Choose two.)
Correct Answer: D,E
Vote an answer
In which situation can the optimizer choose a hash join?
Correct Answer: C
Vote an answer
Examine these commands executed in the cdb1 container database:
Which statement is true about the c##USER1 account?
Which statement is true about the c##USER1 account?
Correct Answer: A
Vote an answer
You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB and that old files are not being purged.
Which statement is true?
Which statement is true?
Correct Answer: E
Vote an answer
