ITPub博客

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

155.Observe the structure of the table employees: The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query ca...

96.Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The shrink operation touches every block in the BOOKING tableB. The high-water mark (HWM) for the BOOKING table is shifted from its original positi...

92.You observed the following output for a user session:What do you infer from the preceding output?A. Resumable set for session with sid 18B. The user session has entered into a deadlockC. The database instance is enabled to use asynchronous commitD. The threshold warning limit is exceeded fo...

20.View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output? (Choose two.)Exhibit:A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user b...

613.You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?A. Enable the flash recovery area and specify it as the archived redo log destination.B. Disable the flash recovery area and start the database instance in AR...

622.You need to maintain a record of all transactions on some tables for at least three years.Automatic undo management is enabled for the database.What must you do accomplish this task?A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create...

637.Which three statements are true about windows? (Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. ...

102.Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGN...

539.How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed?A. Issue the ALTER DISKGROUP ... ADD DISK command.B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D. Retrieve the disk from ...

534.How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?A. Issue the ALTER DISKGROUP ... ADD DISK command.B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D. Retrieve the disk from ...