单项选择题
You executed the following procedure to collect statistics regarding an index: SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE;
Which view will you use to determine whether you need to rebuild the index or not?()
A. INDEX_STATS
B. DBA_INDEXES
C. DBA_IND_COLUMNS
D. V$OBJECT_USAGE
相关考题
-
单项选择题
Theonlineredologgroupconfigurationforyourdatabaseisasfollows:Whatwillhappeniftheonlineredologfile’ora02/oradata/redo02b.log’iscorruptedwhileworkingonthedatabase?()
A. The database will hang.
B. The database will be crashed.
C. The database will be shut down.
D. The LGWR process writes redo log entries to the other redo log member of the Group2 group -
单项选择题
Youaremaintainingadatabaseofcreditcardtransactions.YouwantthedatatobereturnedautomaticallyinthechronologicalorderofthecreditcardnumberswithoutusingtheORDERBYclauseinthequery.Whichtypeofclusterwillyouusetoobtainthedesiredresult?()
A. Hash cluster
B. Index cluster
C. Sorted hash cluster
D. Real Application cluster -
单项选择题
YouwanttoestimatethesizeofatablebyusingtheOracleEnterpriseManager.OnwhichdataisthesizeofthetableNOTbased?()
A. column sizes
B. column data types
C. PCTFREE
D. projected number of row
E. PCTUSED
