单项选择题
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?()
单项选择题 You issued the following command: ALTER TABLE SCOTT.EMP SHRINK SPACE; The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties: DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE; command that generates the following error: ORA-10635: Invalid segment or tablespace type What could be the reason for the failure of the command?()
单项选择题 YouareperformingtheshrinkoperationontheSCOTT.EMPtable.YouwanttoperformthesameoperationonalldependentobjectsoftheSCOTT.EMPtable.WhatisNOTaprerequisitefortheoperation?()