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.
正确答案
答案解析
相似试题
(单选题)
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?()