최신 1z1-074 무료덤프 - Oracle Upgrade Oracle DBA 11g or 12c to 12c R2
Examine these statements:
Which statement is true?
Which statement is true?
정답: D
In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command:
FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;
Which action must you perform next?
FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;
Which action must you perform next?
정답: B
Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?
정답: C
The EMP_CDB1 and EMP_CDB2 CDBs are in ARCHIVELOG mode.
Oracle Managed Files is enabled in both CDBs.
EMP_CDB1 has a PDB, EMP_PDB1.
In EMP_CDB2, you log in as the SYS user.
You plan to execute this statement:
CREATE PLUGGABLE DATABASE emp_pdb2 FROM emp_pdb1@emp_link RELOCATE;
Which two statements are true? (Choose two.)
Oracle Managed Files is enabled in both CDBs.
EMP_CDB1 has a PDB, EMP_PDB1.
In EMP_CDB2, you log in as the SYS user.
You plan to execute this statement:
CREATE PLUGGABLE DATABASE emp_pdb2 FROM emp_pdb1@emp_link RELOCATE;
Which two statements are true? (Choose two.)
정답: E,F
Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)
정답: D,E
The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH.
For what purpose is this optimized?
For what purpose is this optimized?
정답: E
USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?
정답: E
You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?
정답: C