网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（）
A
ADR diagnostic files
B
all the optimizer statistics
C
initialization parameter settings
D
PL/SQL functions，procedures，and packages
E
the table and index definitions and actual data
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（）AADR diagnostic filesBall the optimizer statisticsCinitialization parameter settingsDPL/SQL functions，procedures，and packagesEthe table and index definitions and actual data” 相关考题
考题
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL－related problems?()
A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual data
考题
Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)
A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances
考题
You enabled an audit policy by issuing the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? （）A. SYS, SYSTEMB. SCOTTC. Only for successful executionsD. Only for failed executionsE. Both successful and failed executions
考题
Which of the following is the MOST efficient way to troubleshoot network problems?()
A. Create an action planB. Implement and test a solutionC. Determine if anything has changedD. Identity a probable cause
考题
A server is having problems booting into the operating system. Which of the following can provide important information to begin to troubleshoot the cause?（）A、System logsB、Firmware updatesC、POST messagesD、Application logs
考题
Which of the following is the MOST efficient way to troubleshoot network problems?（）A、Create an action planB、Implement and test a solutionC、Determine if anything has changedD、Identity a probable cause
考题
A server is having problems booting into the operating system. Which of the following can provide important information to begin to trouble shoot the cause？（）A、 System logsB、 Firmware updatesC、 POST messagesD、 Application logs
考题
Which of the following procedures should be performed to minimize possible problems for a customer when updating software?（）A、Apply the updates without committing.B、Commit the new updates to be certain there is no change after the next reboot.C、Update one fileset at a time and test to ensure that it works before updating the next fileset.D、No action is necessary since the software can always be uninstalled and re-installed.
考题
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）A、Control CenterB、Development CenterC、Developer WorkbenchD、Stored Procedure Builder
考题
Which of the following options indicates why it is important to talk to the user and ask appropriate questions about a software problem? （）A、Software problems don't generate errors. B、The user is more knowledgeable about software. C、The system logs will provide useful information alone. D、Key information pertaining to the software may be uncovered.
考题
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） A、 The ADR base keeps all diagnostic information in binary formatB、 SQL*Plus provides the ADRI script， which can be used to work with ADRC、 The ADR can be used for problem diagnosis only when the database is openD、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、 The ADR can be used for problem diagnosis even when the database instance is downF、 The ADR base is shared across multiple instances
考题
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（） A、 ADR diagnostic filesB、 all the optimizer statisticsC、 initialization parameter settingsD、 PL/SQL functions，procedures，and packagesE、 the table and index definitions and actual data
考题
You enabled an audit policy by issuing the following statements: SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）A、SYS, SYSTEMB、SCOTTC、Only for successful executionsD、Only for failed executionsE、Both successful and failed executions
考题
Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)A、The ADR base keeps all diagnostic information in binary formatB、SQL*Plus provides the ADRI script, which can be used to work with ADRC、The ADR can be used for problem diagnosis only when the database is openD、The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、The ADR can be used for problem diagnosis even when the database instance is downF、The ADR base is shared across multiple instances
考题
You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A、 The statistics are stored in the pending statistics table in the data dictionary.B、 The statistics are treated as the current statistics by the optimizer for all sessions.C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）A、The optimizer adds the new plan to the plan history.B、The optimizer selects the new plan for the execution of the SQL statement.C、The optimizer adds the new plan to the SQL plan baseline as an accepted plan.D、The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.E、The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
考题
Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）A、Log fileB、Discard fileC、Parameter fileD、Bad file
考题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（） A、For the AdventureWorks database, enable Server Auditing B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance C、You should configure the data collector and make it capture the deadlock graphsD、You should configure a SQL Profiler trace, and make it capture the deadlock graphs
考题
多选题Which of the following are not fundamental tasks of the Support Workbench？（）AView long-running SQL workloadsBView problem detailsCGather additional diagnostic informationDCreate a Service RequestEClean up incident data after upload to Oracle Support
考题
多选题The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）AThe optimizer adds the new plan to the plan history.BThe optimizer selects the new plan for the execution of the SQL statement.CThe optimizer adds the new plan to the SQL plan baseline as an accepted plan.DThe optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.EThe optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
考题
单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）A
Library cache B
Row cacheC
Dictionary cache D
Large area E
Buffer cache
考题
多选题You enabled an audit policy by issuing the following statements: SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）ASYS, SYSTEMBSCOTTCOnly for successful executionsDOnly for failed executionsEBoth successful and failed executions
考题
多选题Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）AStatistics collection is not done for the CUSTOMERS table when schema stats are gathered.BStatistics collection is not done for the CUSTOMERS table when database stats are gathered.CAny existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.DStatistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.EStatistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
考题
多选题A legacy network that is prone to errors may have issues with services that use UDP. Which of the following services could have problems in this case, due to the fact that UDP is used?（）ADNSBTelnetCSMTPDSNMPEHTTPFTFTP
考题
多选题While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）AThe plan baselines can be evolved over time to produce better performance.BThe newly generated plans are directly placed into the SQL plan baseline without being verified.CThe new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.DThe optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
考题
多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion
考题
多选题Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?（）AADR diagnostic filesBall the optimizer statisticsCinitialization parameter settingsDPL/SQL functions, procedures, and packagesEthe table and index definitions and actual data
考题
单选题Which of the following options indicates why it is important to talk to the user and ask appropriate questions about a software problem? （）A
Software problems don't generate errors. B
The user is more knowledgeable about software. C
The system logs will provide useful information alone. D
Key information pertaining to the software may be uncovered.
热门标签
最新试卷
