题目内容

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.

答案查题题库