Online Access Free 1Z0-045 Practice Test

Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three.)

• A.SWITCH_GROUP
• B.SWITCH_ESTIMATE
• C.SWITCH_TIME
• D.MAX_SESS_POOL

The Oracle 10g LogMiner needs a data dictionary copy to display the object names. From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)

• A.redo information stored within the redo vectors of the DML operation
• B.a Data Dictionary copy stored in an operating system flat file
• C.a Data Dictionary copy stored in the redo log file
• D.separate supplemental log file
• E.the current online data dictionary
• F.information in the control file

While creating an Oracle 10g Release 1 (10.1) database, you set the COMPATIBLE parameter to
10.0.0 in the initialization parameter file. Which two statements are true in this situation? (Choose two.)

• A.You can use all the new features in 10g.
• B.You can change the setting of the COMPATIBLE parameter to 9.2.0.2.
• C.You can advance the compatibility of your database with the COMPATIBLE initialization parameter.
• D.You can assign any value to the COMPATIBLE parameter, but the parameter would still take the default value as 10.0.0.

Which two statements regarding unusable indexes are correct? (Choose two.)

• A.You can set SKIP_UNUSABLE_INDEXES to true to skip unusable indexes.
• B.You can check the alert log file to get a message recorded about unusable indexes.
• C.Your Data Definition Language (DDL) statement shows a warning message when an index is made unusable.
• D.You do not need to set any parameter because unusable indexes are skipped automatically.

The SQL Access Advisor may recommend additional structures to improve the performance of SQL statements. You can select the type of structure recommended by the SQL Access Advisor. Which two structures can you select? (Choose two.)

• A.Hash or index clusters
• B.Materialized views
• C.Sequences
• D.Indexes
• E.Index-Organized Table
• F.Database links
• G.Synonyms
• H.Partitions