ITPub博客

33.You want to perform the following operations for the DATA ASM disk group:-Verify the consistency of the disk.-Cross-check all the file extent maps and allocation tables for consistency. heck whether the alias metadata directory and file directory are linked correctly.-Check that ASM metadata d...

32.In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals Set the control file autobackup to "on"-Are maintaining image copies of the database filesYou have lost the server parameter tile (SPFILE) and the co...

28.You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default...

27.You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database.After regular monitoring of space usage in the flash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. ...

26.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242,...

708. You executed the following query:select oldest_flashback_scn, oldest_flashback_time from v$flashback_database_log;Considering that all the redo logs are available, what information can you derive from the output of the preceding query?A.The time when the last flashback operation in your data...

704. View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.What could be the reason?A.The first two updated were not explicitly committed.B.ALTER TABLE ca...

703. Given below are RMAN commands to enable ba ckup optimization and set the retention policy:The USERS tablespace has never been backed up. Y ou take the USERS tablespace offline on Monday.View the Exhibit to examine the operations performed by using RMAN. Which two statements are true about th...

702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE).When you tried to start the database instance, you received the following error:Why did the instance fail to start?A.Because the PGA_AGGREGATE_TARGET parameter is not setB.Because the STATISTIC...

700. Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)A.It is a copy or a subset of the target database.B.It is opened in RESTRICT mode after a duplicating operation.C.It is created by using backups and archived redo log...

699. Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default temporary tablspace. A user issues a query on the ORDERS table and receives the following error:What would be the most efficient way to rectify this...

698. In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals-Set the control file autobackup to “on”-Are maintaining image copies of the database filesYou have lost the server parameter file (SPFILE) and t...

696. Examine the following command for RMAN backup:Which statement Is true regarding the approach in the command?A.The RMAN multiplexing level is 4.B.It is the use of asynchronous I/O by RMAN.C.It is a case of parallelization of the backup set.D.It is an implementation of a multisection backup...

694. As part of archiving the historical data, you want to trans fer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online.The source and target databases use the same compatibility level and character sets.View the...

689. View the Exhibit and examine the RMAN commands.Which statement describes the effect of a backup retention policy on the backup of a backup set?A.Either all the copies of a backup set are obsolete or none of them are as per the retention policy.B.The copies of the backup will be reported as ...

688. Which two statements are true about the compressed backups in RMAN? (Choose two.)A.Compressed backups can only be taken on the tape drives.B.The binary compression creates some performance overhead during backup operation.C.The ZLIB compression algorithm can be used only if the COMPATIBLE in...

685. In your test database:-You are using Recovery Manager (RMAN) to perform incremental backups of your test database-The test database is running in NOARCHIVELOG mode-One of the data files is corrupted-All online redo log files are lost because of a media failureWhich option must you consider...

684. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.You decide to perform an i...

532.As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy inyour database. Using ASM, you want to create a disk group that will provide for the greatestamount of redundancy for your ASM data (you do not have advanced SAN mirroring technologyavailable to you, u...

525.What components are present in an ASM instance? (Choose three.)A. SGAB. Database processesC. Database datafilesD. Control filesE. Database parameter file or spfileAnswer: ABEASM 实例是ASM 的进程和内存组件的组合。每次启动ASM 或数据库时，都会分配名为系统全局区(SGA) 的共享内存区...