首页计算机考试Oracle认证
(单选题)

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?() 

AA primary key must have been created.

BA mapping table must have been created.

CAn overflow tablespace must have been specified.

DThe PCTTHRESHOLD option must have been specified.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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?()

    答案解析

快考试在线搜题