Oracle Database 12c: Advanced Administration
Question No: 81
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?
Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
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.
Restore all the data files, recoverthem by using the recover database command, and open the database.
Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
Question No: 82
Examine the command used to perform an incrementallevel-0 backup: RMANgt;BACKUPINCREMENTALLEVEL0DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
To perform an incremental level-1 cumulative backup, you issue the command: RMANgt;BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;
Which two statements are true in the preceding situation?
The block change tracking data is used only from the next incremental backup.
The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
The incremental level 1 backup does not use change tracking data for accomplishing the
The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.
Question No: 83
Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST =#39;/u01/app/oracle/oradata/#39;
You execute the following command to create theCDB1. container database (CDB):
SQLgt;CREATEDATABASECDB1 DEFAULTTABLESPACE users DEFAULTTEMPORARY TABLESPACEtemp
UNDO TABLESPACEundotbsl ENABLEPLUGGA3LEDATABASE SEED
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED SYSAUXDATAFILESSIZE100M;
Which three statements are true?
It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
The files created for both the root and seed databases use Oracle Managed Files (OMF).
It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
It sets the users tablespace as the default for both the root and seed databases.
undotbs1 is used as the undo tablespace for both the root and seed databases.
It creates a multitenant container database with the root database opened and the seed database mounted.
Question No: 84
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
Database Resident Connection Pooling
Oracle Suggested Backup Strategy
Database Vault in ORACLE_HOME
Configure Label Security
Question No: 85
Examine the command:
SQLgt;RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?
The current online redo log file is missing.
A data file belonging to a noncritical tablespace is missing.
All the control files are missing.
The database backup is older than the control file backup.
All the data files are missing.
Explanation: http://searchoracle.techtarget.com/answer/Recover-database-using-backup- controlfile-until-cancel
Question No: 86
Examine the RMAN commands executed in your database:
RMANgt;CONFIGUREDEFAULT DEVICE TYPE TO disk; RMANgt;CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET; RKANgt; CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command: RMANgt; BACKUP DATABASE;
Which two statements are true about the command?
It performs a log switch.
It creates compressed backup sets by using binary compression by default.
It backs up only the used blocks in data files.
It backs up data files, the control file, and the server parameter file.
It creates a backup of only the control file whenever the database undergoes a structural change.
Question No: 87
SQLgt; ALTER SESSION SET RECYCLBIN = ON;
SQLgt; DROP TABLE emp; -(First EMP table) Total dropped.
SQLgt; CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
You then execute multiple INSERT statements to insert rows into EMP table and drop the
SQLgt; DROP TABLE emp; – (Second EMP table) Table dropped.
SQLgt; FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
It recovers the structure, data, and indexes of the first emp table.
It recovers only the structure of the second emp table.
It returns an error because two tables with the same name exist in the recycle bin.
It recovers the structure, data, and indexes of the second emp table.
Question No: 88
Which three statements are true about Oracle Secure Backup (OSB)?
It can encrypt client data written to tape.
It can be used to take image copy backups to tape.
It can be used to manage tape backup and restore operations for multiple databases.
It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
It can be used to perform file system backups at the file, directory, file system, or raw partition level.
Question No: 89
While performing database backupto tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup?
Configure backup optimization.
Configure the channel to increase maxopenfiles.
Configure a backup policy by using incremental backups.
Configure the channel to increase capacity with the rate parameter.
Configure the channel to adjust the tape buffer size byusing the 3LKSIZE option.
Configure large_pool, if not done already. Alternatively, you can increase the size of
Question No: 90
Examine the command:
$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?
It fails because the log file parameter is not specified.
It fails because no absolutepath is specified for the log file and dump file.
It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|