单项选择题

A. Index-organized tableB. Mapping TableC. Clustered Ta……

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：
SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；
Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）

A. Index-organized table
B. Mapping Table
C. Clustered Table
D. Journal Table

<上一题目录下一题>

热门试题

单项选择题The configuration of the online redo log files is as follows： Based on this configuration， which statement is true？（）

A. The LGWR process concurrently writes the redo log entries to both the members of a group.
B. When a member of a group becomes corrupt， the database crashes.
C. The sizes of the redo01a.log and redo01b.log online redo log members of group Group1 can be different.
D. When redo02a.log and redo02b.log files become corrupt， then the database operations will proceed as normal.

单项选择题Yourdatabaseblocksizeis4KB.Inthisdatabase，youarerequiredtocreateatablespacewithablocksizeof8KB.Whichistheprerequisiteforcreatingthistablespace？（）

A. The parameter DB_CACHE_SIZE must be a multiple of 8.
B. The value of the parameter SGA_MAX_SIZE must be increased.
C. The tablespace must be created with a uniform extent size of 8 KB
D. The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.

单项选择题YouareshrinkingtheSCOTT.EMPtablebyexecutingtheALTERTABLESCOTT.EMPSHRINKSPACECASCADEstatement.WhatisaprerequisiteforshrinkingtheSCOTT.EMPtable？（）

A. You must enable the block change tracking feature.
B. You must have enable the flashback feature.
C. You must use the OMF in your database.
D. You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

单项选择题YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase，youwanttodeterminethelogfilesizethatshouldequaltheminimumsizeofalltheonlineredologfiles.Whichcolumnwillenableyoutoperformthedesiredtask？（）

A. the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
B. the column of the V$INSTANCE_RECOVERY view
C. the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
D. the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

单项选择题Youarecreatingacluster.Thetablesintheclusterhavearelativelyuniformdistributionofvaluesintheindexcolumnandthequeriesagainsttheclusteredtablewillalmostuseanequalityoperatortoretrievethedesiredrow.Whichtypeofclusterwillyoucreate？（）

A. Index cluster
B. Hash cluster
C. Sorted Hash cluster
D. Real Application Cluster