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

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

A A primary key must have been created.

B A mapping table must have been created.

C An overflow tablespace must have been specified.

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

    答案解析

快考试在线搜题