Onlineindexrebuildfunctionalityhasbeenextendedtoincludewhichfourindexstructures?()
A. Bitmapindexes.
B. Reversekeyindexes.
C. Function-basedindexes.
D. Key-compressedindexesonregulartables.
E. Key-compressedindexesonIOT(includingsecondaryindexes)
查看答案
ToincreasetheavailabilityofanAdvancedReplicationenvironment,youcanaddanewmastertoareplicationgroupwithoutquiescingthegroup.Thisisachieved().
A. Onlywhenthenewmastersitealreadyhasexistingreplicationgroups.
Byissuingasinglecommandtocreate,populate,andactivatethenewmaster.
C. Whenthemasterdefinitionsiteisnotthesameforallofthemastergroups.
D. Withoutimpactingenduserswhoareexecutingdatamanipulationlanguage(DML)commandsonthereplicatedtables.
WhatisthemaximumnumberofARCnprocessesthatcanbedefinedusingtheinitializationparameterLOG_ARCHIVE_MAX_PROCESSES?()
A. 1
B. 5
C. 10
D. 15
E. Dependsonsystemmemoryresources
WhichtwodatatypescanbeconvertedtoLOBsusinganALTERTABLE…MODIFYcommand?()
A. RAW
B. LONG
C. VARCHAR
D. LONGRAW
Oracle9iofferstheabilitytomonitorthedynamicuseoftheSGAthroughtheDB_CACHE_ADVICEparameter.WhenthisparameterissettoREADY,whatisitseffect?()
A. TheAdvisoryisonandwillcapturebothCPUandmemoryoverhead.
B. TheAdvisoryisonbutthememoryfortheAdvisoryisnotallocated.
C. TheAdvisoryisoffandthememoryfortheAdvisoryisnotallocated.
D. TheAdvisoryisoffbutthememoryfortheAdvisoryremainsallocated.