A. Advising on block checksum failures
B. Advising on inaccessible control files
C. Advising on inaccessible block change tracking files
D. Advising on empty password files
E. Advising on invalid block header field values
第1题:
YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase?()
A.DB_RECOVERY_FILE_DESTonly
B.DB_FLASHBACK_RETENTION_TARGETonly
C.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonly
D.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonly
E.DB_RECOVERY_FILE_DEST_SIZE,DB_RECOVERY_FILE_DESTand
F.DB_FLASHBACK_RETENTION_TARGET
第2题:
A. Cisco Smart Foundation Service
B. SMARTnet Partner Service
C. Cisco Smart Care Service
D. Cisco Technical Assistance Center
E. CiscoSMARTnet for SBCS
第3题:
第4题:
Evaluatethefollowingcode:SQL>VARIABLEtask_nameVARCHAR2(255);SQL>VARIABLEsql_stmtVARCHAR2(4000);SQL>BEGIN:sql_stmt:=’SELECTCOUNT(*)FROMcustomersWHEREcust_state_province=’’CA’’’;:task_name:=’MY_QUICKTUNE_TASK’;DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,:task_name,:sql_stmt);END;Whatistheoutcomeofthisblockofcode?()
A.Itcreatesataskandworkload,andexecutesthetask.
B.Itcreatesataskandworkloadbutdoesnotexecutethetask.
C.Itproducesanerrorbecauseatemplatehasnotbeencreated.
D.ItproducesanerrorbecausetheSQLTuningSethasnotbeencreated.
第5题:
第6题:
1. 创建并访问DataFrame对象。 1) 创建3×3DataFrame数据对象:数据内容为1-9;行索引为字符a,b,c;列索引为字符串‘one’,‘two’,‘three’; 2) 查询列索引为‘two’和‘three’两列数据; 3) 查询第0行、第2行、第0列、第2列数据; 4) 筛选第1列中值大于2的所有行数据,另存为data1对象; 5) 为data1添加一列数据,列索引为‘four’,值都为10; 6) 将data1所有值大于9的数据修改为8; 7) 删除data1中第0行和第1行数据。