单选题

While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()

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

正确答案

来源:www.examk.com

答案解析

相似试题
  • 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?()

    单选题查看答案