ITPub博客

134.You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each.To accomplish the backup, you issued the following RMAN command:RMAN>BACKUP SECTION SIZE 300M TABLESPACE...

606.Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)A. Limiting the input/output (I/O) bandwidth consumptionB. Specifying the size of backup sets and backup piecesC. Specifying vendor-specific information ...

604.You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED m...

603.While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this...

133.You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)A. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.B. The KEEP option overrides the con...

601.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? (Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN...

100.Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? (Choos...

634.Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle...

618.You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch'LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY'Identify the statement th...

660.You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:1. Set the retention target:SQL> ALTER SYSTEM SET DB_FLASHBA...

659.Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)A. ALTER DISKGROUP misc MOUNT;B. ALTER DISKGROUP misc DROP DISK misc2;C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;E. ALTER DISKGROUP dgroupA ADD DISK '/...

658.Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN). (Choose two.)A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control file First Test,C. You can store backup infor...

657.The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?A. Allow the database to continue running, drop the TEMP tablespace, and then re...

651.The user SYS creates a job by using the following command:BEGIN    DBMS_SCHEDULED.CREATE_JOB( job_name ==> 'update_sales',        job_type ==> 'STOPED-PROCEDURE',        job_action ==> 'OPS.SALES_PKG.UPDATE_...

646.View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table: SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?A. An error is produced.B. T...

636.Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)A. Backup retention policyB. Default backup device typeC. Default destinations for backupsD. Multiple backup device types for single backupE. Default s...

635.While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the ev...

630.Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The database uses the same encryption key for every encrypted backupC. The password encryption of backups only uses the password while creating and re...

627.In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace...

626.Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tablespaceD. Au...