You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.Identify three possible reasons for this.（）A. Missing or stale histogram statisticsB. Undersized shared poolC. High clustering factor for the indexesD. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameterE. Oversized buffer cache
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.Identify three possible reasons for this.（）
A. Missing or stale histogram statistics
B. Undersized shared pool
C. High clustering factor for the indexes
D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
E. Oversized buffer cache
相关考题：
YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE，DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET
YouareworkingasaDBAonOracleDatabase9i.Youplantoupgradeyour9idatabasetoOracle10g.Tobefamiliarwiththenewdatabasetechnology，youdecidetoinstallOracleDatabase10gonyourworkstationathome.Youcreateageneralpurposedatabase.Aftertheinstallation，youmakethefollowingchangesinyourinitializationparameterfile：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’DB_RECOVERY_FILE_DEST=’LOCATION=d：\product\10.1.0\flash_recovery_area’DB_RECOVERY_FILE_DEST_SIZE=10gWherearethearchivedredologsstoredforyourdatabase？（）
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?() A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n
执行下列命令后,当前打开的数据库文件名是Number="3"File="File"＋NumberUSEFileA.File3B.FileA．File3B．FileC．FileNumberD．File
下面哪2个参数是flashback databae必须设置的? () A. DB_FLASHBACK_RETENTION_TARGETB. DB_RECOVERY_FILE_DESTC. RECOVERY_PARALLELISMD. FLASHBACK_TRANSACTION_QUERYE. DB_RECOVERY_FILE_DEST_SIZE
Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）A.AB.BC.CD.D
假设文件file是文本文件对象，下列选项只能够，哪个用于读取一行内容（）A．file.read()B．file.read(200)C．file.readline()D．file.readlines()
假设file是文本文件对象，下列选项中，哪个用于读取一行内容？（）A．file.read()B．file.read(200)C．file.readline()D．file.readlines()
3、假设file是文本文件对象，下列选项中，哪个用于读取一行内容？（）A．file.read()B．file.read(200)C．file.readline()D．file.readlines()