You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM?()
对于Oracle的服务,描述正确的是()。
On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()
Which statement about the enabling of table compression in Oracle Database 11g is true?()
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()
You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()
Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid?()
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()