Athe CREATE TABLE .. command
Bsorting of the SYSTEM tablespace’s data
Csorting of data required by recursive SQL statements
Dthe CREATE TABLE .. ORGANIZATION EXTERNAL .. command
Esorting of data if the users have not been allocated temporary tablespace explicitly
Fsorting of data if the users have been allocated temporary tablespace explicitly
Which statement is true while creating subplans using Resource Manager?()
单选题查看答案
You want to create a temporary table while executing a procedure in a form. Which statement is true?()
单选题查看答案
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?()
单选题查看答案
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?()
单选题查看答案
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?()
单选题查看答案
While designing your database, you have created the EMPLOYEES table as an index-organized 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?()
单选题查看答案
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?()
单选题查看答案
While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to resolve this error?()
多选题查看答案
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?()
单选题查看答案