You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）

In which scenario will you create a hash cluster？（）

单选题查看答案

In which scenario will you create a sorted hash cluster？ （）

单选题查看答案

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

单选题查看答案

Which command do you use to create a recovery-catalog schema? （）

单选题查看答案

Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

单选题查看答案

You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）  

单选题查看答案

While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

单选题查看答案

If you create your database using Oracle Managed Files （OMF）， what is true？（）

单选题查看答案

You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）

单选题查看答案

You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）

单选题查看答案