ITPub博客

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

93.The database is configured in ARCHIVELOG mode and regular complete database backups are taken.The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two)A. Control filesB. Password filesC. Inactive online redo log fileD. Archived log files required to ...

86.Your production database is running in archivelog mode and you are using recovery manager(RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displ...

53.You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.B. The ZLIB compression algorithm consumes more CPU resources than the...

16.Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you...

10.Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.The TOOLS tablespace is read-only since November 4, 2007.On November 23...

644.View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?A. Because the FRA disk ...

638.Which three statements are true about persistent configuration? (Choose three.)A. A user cannot set privileges on the persistent lightweight jobsB. Persistent lightweight jobs generate a large amount of metadataC. It is possible to create fully self-contained persistent lightweight jobsD. Th...

616.The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.Which two statements about the results of the query shown in the Exhibit are correct? (C...

271.Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of thi...

250.You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.How would you create these jobs?A. Create bo...