A. the RMAN utilityB. the import export utilityC. the O……

单项选择题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

单项选择题You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

A. creating a table in your schema and you exceed your allocated space quota on the tablespace
B. executing a long query that involves a sort operation and the statement runs out of temporary space
C. loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
D. creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error