ITPub博客

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...

611.To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:SQL> ALTER TABLESPACE users BEGIN BACKUP;While copying the file to the backup destination a power outage caused the instance to te minate abnormally.Which statement ...

489.For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A.viewsB.fixed tablesC.heap tablesD.external tablesE.temporary tablesF.index-organized tables (IOT)Answer: CF参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements...

485.You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device.The current consumption of your CPU is approximately 40 percent.Which type of backup should you perform?A. ...

264.Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)A. stored scripts in the recovery catalogB. backups that can be deleted from diskC. backup sets and image copies are obsoleteD. backups that do not have the A...

236.Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?A. only the control file, the current SPFILE, and data filesB. only the current SPFILE and data files if...

160.Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)A. It's only supported for the backups performed on the tapeB. It is not supported for backup operations that produce image copiesC. Duplex backups need a parallelism for the device to be equal to num...

154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:ERROR at line 1:ORA-01116: error in opening database file 3ORA-01110: data file 11: '/oracle/oradata/orcl/data/userdata01.dbf'ORA-27041: unable to open fileWhich is the r...

153.You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you i...

152.You are performing incomplete recovery using RMAN. You execute the following RUN block:RUN{SET UNTIL SCN 1107600;RESTORE DATABASE;RECOVER DATABASE;}Which statement is true about the result?A.RMAN restores all datafiles from the most recent backup available since the failure and applies t...

95.Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplic...