1Z0-063 | Replace 1Z0-063 Exam Study Guides With New Update Exam Questions
Q71. Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?
A. by using the RMAN switch command to set the new location for the data files
B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
D. by creating a new database in the new host, and then using the RMAN recover command
Answer: D
Q72. You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?
A. The event parameter was not set.
B. The sql_trace parameter is set to false.
C. Enterprise Manager was not used.
D. The statistics_level parameter is set to basic.
E. The t:kid_statistics parameter is set to false.
Answer: D
Q73. You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on allthe other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?
A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
C. Restore all the data files, recoverthem by using the recover database command, and open the database.
D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
Answer: B
Q74. Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job’,FORCED_TRACKING=>'Y');
Which two statements are true?
A. Database operations will be monitored only when they consume a significant amount of resource.
B. Database operations for all sessions will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D. Only DML and DDL statements will be monitored for the session.
E. All subsequent statements in the session will be treated as one database operation and will be monitored.
Answer: C,E
Explanation: C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL
Monitoring and Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the
current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'.
/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.
Q75. Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incrementalbackup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
Answer: B
Q76. Examine the command to back up the ASM metadata:
ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?
A. when one or more disks in an ASM disk group are lost
B. when the data file on an ASM disk group gets corrupted
C. when one of the disks in a disk group is accidentally unplugged
D. when one or more file directory paths are accidentally deleted from an ASM disk group
E. when all the ASM disk groups for the ASM instance are lost
Answer: B,C,D
Q77. Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
A. A PDB opened in restricted mode allows only local users to connect.
B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
C. When a CDB is in mount state, PDBs are automatically placed in mount state.
D. All PDBs must be shut down before shutting down a CDB instance.
E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable databasecommand.
Answer: B,C,E
Q78. Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?
A. Shut downthe instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
D. Mount the database, restore all data files belongingto the system tablespace from the last backup, and open the database.
Answer: C
Q79. Yourdatabase is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set D3ID of the target database in RMAN.
2.Start the database instance by using the startup force nomount command in RMAN.
3.Restore the control files from the backup.
4.Mount the database.
5.Restore theSPFILE from the autobackup.
6.Create a PFILE from the recovered SPFILE.
7.Restart the instance in nomount state.
Identify the required steps in the correct order.
A. 1, 2, 5, 3, 6, 4
B. 1, 2, 3, 5, 6, 4
C. 2, 1, 5, 7, 3, 4
D. 2, 1, 5, 6, 7, 4, 3
Answer: C
104. You want to move your existing recovery catalog to another database.
Examine the steps:
1)Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target
database.
3) Create a recovery catalog by using the create catalog command.
4)Import the catalog data into the new recovery catalog by using the Data Pump Import
utility in the target database.
5)Import the source recovery catalog schema by using the import catalog command.
6)Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.
A. 1, 6, 4
B. 2, 3, 7, 5
C. 1, 2, 6, 4
D. 1, 2, 3, 6, 5
Answer: C
Q80. In your database, there are tablespaces that were read-only when thelast backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing anincomplete recovery?
A. All the read-only tablespaces should be taken offline.
B. All the read-only tablespaces should be restored separately.
C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
D. All the read-only tablespacesshould be made online with logging disabled.
Answer: B