최신Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z0-067무료샘플문제
문제1
Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods are performed the truncated table data? (Choose two.)
Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods are performed the truncated table data? (Choose two.)
정답: D,E
문제2
Which two statements are true about RMAN duplexed backups? (Choose two.)
Which two statements are true about RMAN duplexed backups? (Choose two.)
정답: A,E
문제3
You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)
You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)
정답: A,B
문제4
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
Which parameter must be set to which value to implement automatic PGA memory management?
Which parameter must be set to which value to implement automatic PGA memory management?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제6
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제7
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which statement is true about the execution of the command?
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which statement is true about the execution of the command?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1. Restore the control files by using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order.
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1. Restore the control files by using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order.
정답: B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제9
Which two statements describe the relationship between a window, a resource plan, and a job class?
Which two statements describe the relationship between a window, a resource plan, and a job class?
정답: B,D
설명: (ITDumpsKR 회원만 볼 수 있음)