Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Question No: 101
Examine the commands executed to monitor database operations:
$gt; conn sys/oracle@prod as sysdba SQLgt; VAR eid NUMBER SQLgt;EXEC :eid :=
Which two statements are true?
Database operations will be monitored only when they consume a significant amount of resource.
Database operations for all sessions will be monitored.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC TUNING.
Only DML and DDL statements will be monitored for the session.
All subsequent statements in the session will be treated as one database operation and will be monitored.
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.
* 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 #39;Y#39;.
/ (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 #39;N#39;.
Question No: 102
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:
RMANgt; BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?
It returns an error because there isno level 0 backup available for new data files.
It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
It performs a level-0 backup of all data files including those that belong to the new
It performs an image copy backup of all data files including those that belong to the new tablespace.
It performs a backup as a backup set of all data files including those that belong to the new tablespace.
Question No: 103
Examine the command to duplicate a database:
RMANgt; DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?
The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
A backup of pdbi and pd35 must exist before executing the command.
The duplicate command first creates a backup, and then duplicates the PDBs by using the
An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
Question No: 104
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true?
A resumable statement can be suspended and resumed only once during execution.
Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
A suspended statement will report an error if no corrective action has taken place during a timeout period.
Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
Question No: 105
You install quot;Oracle Grid Infrastructure for a standalone serverquot; on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?
Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
All database listeners running from the database home are automatically added to the Oracle
The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restartconfiguration.
The crsct1 start has command must be used to start software services for Oracle AutomaticStorage Management (ASM) after the quot;Oracle Grid Infrastructure for a standalone serverquot; installation is complete.
All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
Question No: 106
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.
RMANgt; BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?
All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
All data files belonging to pdb2_1 are backed up along with the archive log files.
Only the data files belonging to pdb2_ are backed up.
This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.
Question No: 107
Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l =#39;LOCATION=/disk1/arch MANDATORY#39;
LOG_ARCHIVE_DEST_2 =#39;LOCATION=/disk2/arch#39; LOG_ARCHIVE_DEST_3 =#39;LOCATIO=/disk3/arch#39; LOG_ARCHIVE_DEST _4 =#39;LOCATIONs/disk4/arch#39; LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?
The database instance hangs and the redo logfiles are not overwritten.
The archived redo log files are written to the fast recovery area until the mandatory
destination is made available.
The database instance is shutdown immediately.
The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Question No: 108
You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?
MAXSETSIZE TO 2;
DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CHANNEL DEVICE TYPE DISK FORMAT #39;/disk1/%U#39; , #39;/disk2/%U#39;;
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Question No: 109
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: 110
You want to move your existing recovery catalog to another database.
Examine the steps:
Export the catalog data by using the Data Pump Export utility in the source database.
Create a recovery catalog user and grant the necessary privileges in the target database.
Create a recovery catalog by using the create catalog command.
Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
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
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|