While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

Which statement is true while creating subplans using Resource Manager？（）

单选题查看答案

Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）

多选题查看答案

You want to create a temporary table while executing a procedure in a form. Which statement is true?（）

单选题查看答案

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）

多选题查看答案

Which options must you configure while performing an automated Tablespace Point-in-Time Recovery （TSPITR） by using Recovery Manager （RMAN）？（）  

单选题查看答案

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）

多选题查看答案

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

单选题查看答案

While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）

单选题查看答案

A customer claims that while redeploying a web application in the production system all their  customers are having to log in again. What do you recommend? （）

单选题查看答案

While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）

单选题查看答案