Oracle Database 12c: Advanced Administration
Question No: 101
What can be automatically implemented after the SQL Tuning Advisoris run as part of the Automated Maintenance Task?
SQL profile recommendations
SQL statement restructure recommendations
creation of materialized views to improve query performance
Answer: C Reference:http://docs.oracle.com/cd/E11882_01/server.112/e16638/sql_tune.htm#PFGRF 028
Question No: 102
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
to store backup information of multiple databases in one place
to restrict the amount of space that is used by backups
to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog
to automatically delete obsolete backups after a specified period of time
Question No: 103
You are administering a database that supports 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 all the 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.
You want to recover the data file.
Examine the steps involved in the recovery process: 1.Shut down the database instance.
2.Start up the database instance in nomount state. 3.Mount the database.
4.Take the data file offline. 5.Put the data file online. 6.Restore the control file. 7.Restore the database.
Restore the data file.
Open the database with the resetlog option. 10.Recover the database withthe noredo option. 11.Recover the data file with the noredo option.
Identify the required steps in the correct order.
A. 4, 8, 11, 5
B. 1, 3, 8, 11, 9
C. 1, 2, 6, 3, 7, 10, 9
D. 1, 3, 7, 10, 9
E. 1, 2, 6, 3, 8, 11, 9
Question No: 104
Which three statements are true about Consolidated Database Replay?
The workload capture and replay systems must have the same operating system (OS).
Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
A subset of the captured workload can be replayed.
The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
Question No: 105
For which three pieces of information can you use the RMAN list command?
stored scripts in the recovery catalog
available archived redo log files
backup sets and image copies that are obsolete
backups of tablespaces
backups that are marked obsolete according to the current retention policy
The primary purpose of the LIST command is to list backup andcopies. For example, you can list:
-Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file
-Backups that have expired
-Backups restricted by time, path name, device type, tag, or recoverability
-Archived redolog files and disk copies
Question No: 106
When is the UNDO_RETENTION parameter value ignored by a transaction?
when the data file of the undo tablespace is autoextensible
when there are multiple undotablespaces available in a database
when the undo tablespace is of a fixed size and retention guarantee is not enabled
when Flashback Database is enabled
Answer: C Reference:http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm(undo retention, see the bullets)
Question No: 107
Examine the following set of RMAN commands:
RKANgt; CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT #39; /u02/backup/%U#39; ; RKANgt; RUN
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
Which statement is true about the RMAN run block execution?
The script is executed and both DC1 and chi channels are used for script execution.
The execution of the script fails because multiple channels cannot exist simultaneously.
The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.
The new channel, chi, is ignored because a channel has been configured already.
Question No: 108
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
whenthe duplicate … from active database command contains the section size clause
when you perform active database duplication on a database with flashback disabled
when you specify set encryption before the duplicate … from active database command
when the number of auxiliary channels allocated is equal to or greater than the number of target channels
when you perform active database duplication on a database that has read- onlytablespaces
Question No: 109
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command: SQLgt; ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
It executes successfully and continues to store metadata related to the EMPLOYEES table.
It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
Question No: 110
Examine the output:
SQL gt; ARCHIVE LOGLIST
Database log modeArchive Mode Automatic archivalEnabled
Archive DestinationUSE_DB_RECOVERY_FILE_DEST Oldest online log sequence376
Next log sequence to archive378 Current log sequence378
Which three types of files are automatically placed in the fast recovery area?
Flashback data archives (FDA)
Archived redo log files
Control file autobackups
Server parameter file (SPFILE)
Recovery Manager (RMAN) backup pieces
Answer: B,C,E Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV 526
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|