单项选择题

A. INDEX_STATSB. DBA_INDEXESC. DBA_IND_COLUMNSD. V$OBJE……

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

多项选择题You have the following online redo log configuration： Group Member 1 ’ disk1 oradata redo01a.log’ 2 ’ disk2 oradata redo02a.log’ 3 ’ disk3 oradata redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）

A. ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；
B. ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；
C. ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；
D. ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；
E. ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；
F. ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；