Oracle Database 12c: Advanced Administration
Question No: 71
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?
by using the RMAN switch command to set the new location for the data files
by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
by creating a new database in the new host, and then using the RMAN recover command
Question No: 72
Which three statements are true about compression of backup sets?
Compressed backups can only be written to media.
Binary compression creates performance overhead during a backup operation.
Unused blocks below the high-water mark are not backed up.
Compressed backups cannot have section size defined during a backup operation
It works only for locally managed tablespaces.
Question No: 73
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1.Restore an autobackup of the server parameter file. 2.Restore the control file.
3. Start up the database instance in nomount state. 4.Mount the database.
Restore the data files.
Open the database with the resetlogs option. 7.Recover the data files.
8.Set D3ID for the database.
Identify the required steps in the correct order.
A. 1, 8, 3, 2, 4, 5, 7, 6
B. 8, 1, 3, 2, 4, 5, 7, 6
C. 1, 3, 2, 4, 8, 5, 6, 7
D. 8, 3, 2, 4, 5, 7, 6
E. 8, 1, 3, 2, 4, 5, 6
Question No: 74
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
The backup must be performed in mount state.
The tablespace must betaken offline.
All files must be backed up as backup sets.
The database must be backed up as an image copy.
Question No: 75
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQLgt; CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users
QUOTA I00M ON users TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?
The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
The command succeeds only if all the PDBs have the users and temp tablespaces.
The command gives an error because the container=all clause is missing.
The commandsucceeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.
Question No: 76
The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RCII user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands: Srman
RMANgt; CONNECT CATALOG rc12c/pass12c8catdbI2c
RMANgt; IMPOST CATALOG rc1l/pwdcatl19catdbl1 DBID=I423241;
What is the outcome of the import?
It fails because the target database and recovery catalog database are of different versions.
It succeeds and all global scripts in the sc:: catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
It succeeds but the database is not automatically registered in the Rc12c catalog.
It fails because RMAN is not connected to the target database with DBID=1423241.
Question No: 77
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQLgt; ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?
It is immediately set to all in the SPFILE and the CDB instance.
It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
It is immediately set to all only for cd3Sroot.
It is immediately set to all in all PDBs where the statistics_level parameter is not set.
It is set to all for all PDBs only in the SPFILE.
Question No: 78
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
Place all the user-defined tablespace in read-only mode on the source database.
Upgrade the source database to a 12c version.
Create a new PDB in the target container database.
Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility.
Copy the associated data files and export the dump file to the desired location in the target database.
Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
A. 2, 1, 3, 4, 5, 6
B. 1, 3, 4, 5, 6, 7
C. 1, 4, 3, 5, 6, 7
D. 2, 1, 3, 4, 5, 6, 7
E. 1, 5, 6, 4, 3, 2
Question No: 79
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 isPDB modifiable.
As the user sys, execute the following command on pdb2:
SQLgt; ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID=#39;*#39; SCOPE=SPFILE;
Which statement is true about the result of this command?
The statistics_level parameter is set to all when anyof the PDBs is reopened.
The statistics_level parameter is set to all only for PDB2 when it is reopened.
The statistics_level parameter is set to all when the root database is restarted.
The statement is ignored because there is no SPFILE for a PDB.
Question No: 80
You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2.
While opening pdb_1, you get an error: SQLgt; alter pluggable database pdb_1 open;
ORA-01110:data file 11:#39;/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf#39;
To repair the failure, you open an RMAN session for the target database CDBSROOT. You execute the following as the first command:
Which statement describes the consequence of the command?
The command performs the recovery and closes the failure.
The command produces an error because RMAN is not connected to the target database pdb_1.
The command produces an errorbecause the advise failure command was not executed before the REPAIRFAILUER command.
The command executes successfully, performs recovery, and opens PDB_1.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|