QUESTION NO: 1
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
Correct Answer: A
Vote an answer
QUESTION NO: 2
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
Correct Answer: D
Vote an answer
QUESTION NO: 3
Examine the command:
Which statement is true about the execution of the command?
Examine the command:
Which statement is true about the execution of the command?
Correct Answer: B
Vote an answer
QUESTION NO: 4
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
Correct Answer: C
Vote an answer
QUESTION NO: 5
Which three RMAN persistent settings can be set explicitly? (Choose three.)
Which three RMAN persistent settings can be set explicitly? (Choose three.)
Correct Answer: B,C,F
Vote an answer
QUESTION NO: 6
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.
Examine the command executed to back up PDB2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.
Examine the command executed to back up PDB2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
Correct Answer: C
Vote an answer
QUESTION NO: 7
You plan to create a new PDB by copying PDB$SEED.
Which two requirements ensure a successful creation? (Choose two.)
You plan to create a new PDB by copying PDB$SEED.
Which two requirements ensure a successful creation? (Choose two.)
Correct Answer: B,E
Vote an answer
QUESTION NO: 8
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configured for the database and OID and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configured for the database and OID and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
Correct Answer: D
Vote an answer
QUESTION NO: 9
Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)
Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)
Correct Answer: A,C,D
Vote an answer
QUESTION NO: 10
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?
Correct Answer: B
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 11
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)
Correct Answer: C,D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 12
One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.
One data file is corrupt and the current online redo log is missing due to media failure.
Which four actions must you take for recovery? (Choose four.)
One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.
One data file is corrupt and the current online redo log is missing due to media failure.
Which four actions must you take for recovery? (Choose four.)
Correct Answer: C,D,E,F
Vote an answer
QUESTION NO: 13
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command? (Choose two.)
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command? (Choose two.)
Correct Answer: B,C
Vote an answer
QUESTION NO: 14
An incremental level 1 backup is taken every week day. A new tablespace is created before the backup is performed.
You execute:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which two are true? (Choose two.)
An incremental level 1 backup is taken every week day. A new tablespace is created before the backup is performed.
You execute:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which two are true? (Choose two.)
Correct Answer: B,D
Vote an answer