Oracle 1z0-067 Exam Practice Questions (P. 2)
- Full Access (264 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #6
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1.Determine which backup contains the table that needs to be recovered.
2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
3.Import the Data Pump export dump file into the auxiliary instance.
4.Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.
Examine the steps to recover this table from an RMAN backup:
1.Determine which backup contains the table that needs to be recovered.
2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
3.Import the Data Pump export dump file into the auxiliary instance.
4.Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.
- A1, 4, 3
- B1, 2
- C1, 4, 3, 2
- D1, 2, 4
Correct Answer:
D
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
D
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689
send
light_mode
delete
Question #7
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?
- AThe current online redo log file is missing.
- BA data file belonging to a noncritical tablespace is missing.
- CAll the control files are missing.
- DThe database backup is older than the control file backup.
- EAll the data files are missing.
Correct Answer:
AC
http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel
AC
http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel
send
light_mode
delete
Question #8
Which two are prerequisites for setting up Flashback Data Archive?
- AFast Recovery Area should be defined.
- BUndo retention guarantee should be enabled.
- CSupplemental logging should be enabled.
- DAutomatic Undo Management should be enabled.
- EAll users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
- FThe tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.
Correct Answer:
DF
References:
DF
References:
send
light_mode
delete
Question #9
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAMETYPEVALUE -
-------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring
What is the location of the ADR base?
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAMETYPEVALUE -
-------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring
What is the location of the ADR base?
- AIt is set to/u01/app/oracle/product:/12.1.0/db_1/log.
- BIt is set to /u01/app/oracle/admin/enl2r&p/adump.
- CIt is set to /u01/app/oracle.
- DIt is set to /u01/app/oracle/flash_recovery_area.
Correct Answer:
C
http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008
The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.
C
http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008
The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.
send
light_mode
delete
Question #10
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1
PDB.
Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause.
3.Open the emp_pdb1 PDB.
4.Mount the emp_pdb1 PDB.
5.Synchronize the emp_pdb1 PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB.
8.Import data into emp_pdb1 with the full and remap clauses.
9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.
PDB.
Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause.
3.Open the emp_pdb1 PDB.
4.Mount the emp_pdb1 PDB.
5.Synchronize the emp_pdb1 PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB.
8.Import data into emp_pdb1 with the full and remap clauses.
9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.
- A2, 1, 3, 7, 6, and 8
- B2, 1, 4, 5, 3, 7, 6, 9, and 8
- C2, 1, 3, 7, 6, 9, and 8
- D2, 1, 3, 5, 7, 6, and 8
Correct Answer:
C
C
send
light_mode
delete
All Pages