网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）
A.Every SQL statement in the STS is considered only once for execution
B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C.The execution plan and execution statistics are computed for each SQL statement in the STS
D.The effects of DDL and DML are considered to produce the execution plan and execution statistics
参考答案
更多 “ You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）A.Every SQL statement in the STS is considered only once for executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics ” 相关考题
考题
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
将本地数据库服务器上的数据库navy2的test表导出到脚本（/data/test.sql）的正确语句是A．mysqldump navy2 test ＞ /data/test.sqlB．mysql navy2 test ＞/data/test.sqlC．output navy2 test ＞ /data/test.sqlD．navy2 test ＞ /data/test.sql
考题
【单选题】以下关于MyBatis的＜set＞元素的使用及说法正确的是。A.＜set＞元素主要用于更新操作，其主要作用是在动态包含的SQL语句前输出一个SET关键字，并将SQL语句中最后一个多余的逗号去除。#B.使用MyBatis的＜set＞元素来更新操作时，前端需要传入所有参数字段，否则未传入字段会默认设置为空。#C.在映射文件中使用＜set＞和＜if＞元素组合进行update语句动态SQL组装时， ＜set＞元素内包含的内容可以都为空，＜if＞元素会进行判断处理。#D.在映射文件进行更新操作时，只需要使用＜set＞元素就可以进行动态SQL组装。
考题
下列关于动态SQL、静态SQL的叙述中，不正确的是_________。A．SQL语句在程序中已经按要求写好，体现为一个可执行的SQL语句，把一些参数通过变量传送给SQL语句即可执行，这是静态SQL；B．SQL语句在程序中动态构造，体现为一个字符串，然后再交给DBMS执行，执行时可以传递变量，这是动态SQL；C．动态SQL语句的执行方式只能是Prepare-Execute-Using方式，即预编译-传递参量并执行；D．动态SQL 语句是指在程序编译时尚未确定，需要在程序执行过程中临时生成的SQL语句；
考题
8、下列关于动态SQL、静态SQL的叙述中，不正确的是_________。A．SQL语句在程序中已经按要求写好，体现为一个可执行的SQL语句，把一些参数通过变量传送给SQL语句即可执行，这是静态SQL；B．SQL语句在程序中动态构造，体现为一个字符串，然后再交给DBMS执行，执行时可以传递变量，这是动态SQL；C．动态SQL语句的执行方式只能是Prepare-Execute-Using方式，即预编译-传递参量并执行；D．动态SQL 语句是指在程序编译时尚未确定，需要在程序执行过程中临时生成的SQL语句；
考题
删除数据库Test的正确SQL语句是（）A．Drop DataBase TestB．Delete DataBase TestC．Alter DataBase TestD．Delete From DataBase Test
考题
5、在MyBaits映射文件中使用＜set＞和＜if＞元素组合进行update语句动态SQL组装时，如果＜set＞元素内包含的内容都为空，则会出现SQL语法错误。
热门标签
最新试卷