（单选题）
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?（）
ARecreate the query and default the layout.
BAlter the query, default the layout and redo the boiler plates.
CQuery and manually change the layout to save the boiler plate.
DAlter the query and make no further 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？（）
