单项选择题

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.

点击查看答案&解析

上一题目录下一题

相关考题

多项选择题

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：
RMAN> RESTORE CONTROLFILE；
Which two operations do you need to perform after restoring the control file from backup？（）

A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D. perform a media recovery and bring the database to NOARCHIVELOG mode

单项选择题

Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1；
3> ALTER DATABASE MOUNT；
4> RESTORE DATABASE；
5> RECOVER DATABASE；
6> ALTER DATABASE OPEN RESETLOGS；
7> }；
With reference to this scenario， which statement is true？（）

A. RMAN recovers up to log sequence 230， but not including 230.
B. RMAN returns an error because the log sequence number mentioned in the command should be 229.
C. RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D. RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.

单项选择题

You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）

A. a list of files that require a backup within three days
B. a list of files that have not been backed up for three days
C. a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
D. a list of files for which a backup has already been performed and may need a backup after three days