搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.<br /> Which two statements describe the implications of this?（）

A、It produces less accurate results of the comparison analysis.

B、It automatically calls the SQL Tuning Advisor for recommendations.

C、It shortens the time of execution and reduces the impact on system resources.

D、Only the changes in the execution plan, and not performance regression, are detected.

查看正确答案
更多“ When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.<br /> Which two statements describe the implications of this?（）”相关的问题
第1题
[多选题] When does a transaction complete?（）

A、when a DELETE statement is executed   B、when a ROLLBACK command is executed   C、when a PL/SQL anonymous block is executed   D、when a data definition language (DDL) statement is executed   E、when a TRUNCATE statement is executed after the pending transact ion  

点击查看答案
第2题
[单选题] 循环队列sq中，用数组elem存放数据元素，sq．front指示队头元素的前一个位置，sq．rear指示队尾元素的当前位置，队列的最大容量为MAXSIZE，则在队列未满时元素x入队列的主要操作为（）。

A、sq．rear= （sq．rear+1）mod MAXSIZE； sq．elem[sq．rear]=x；  B、sq．elem[sq．rear]=x； sq．rear= （sq．rear+1）mod MAXSIZE；  C、sq．front= （sq．front+1）mod MAXSIZE； sq．elem[sq．front]=x；  D、sq．elem[sq．front]=x； sq．front= sq．front+1；  

点击查看答案
第3题
[] 循环队列sq中，用数组elem存放数据元素，sq．front指示队头元素的前一个位置，sq．rear指示队尾元素的当前位置，队列的最大容量为MAXSIZE，则队列满的条件为（）。

A、A．sq．front= sq．rear  B、B．sq．front= sq．rear+1  C、C．（sq．front +1）mod MAXSIZE= sq．rear  D、D．（sq．rear+1）mod MAXSIZE= sq．front  

点击查看答案
第4题
[单选题] Which statement about using RMAN stored scripts is true?（）

A、To create and execute an RMAN stored script, you must use a recovery catalog.  B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.  C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.  D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.  

点击查看答案
第5题
[单选题] Which statement about using RMAN stored scripts is true?（）

A、To create and execute an RMAN stored script, you must use a recovery catalog.  B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.  C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.  D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.  

点击查看答案
第6题
[多选题] 在因子实验设计分析结果中，以下对于回归效果的度量参数R-sq及R-sq（调整）描述正确的是（）

A、R-sq及R-sq（调整）称为确定系数与调整确定系数  B、R-sq及R-sq（调整）称为多元全相关系数与调整的多元全相关系数  C、R-sq及R-sq（调整）越大越好  D、R-sq及R-sq（调整）越接近越好  

点击查看答案
第7题
[简答题] 由两台电动机M1、M2分别驱动两个工作台A和B，机构示意图如图所示。动作过程如下：  （1）按下起动按钮后，工作台A由SQ1进至SQ2； （2）然后工作台B由SQ3自动进至SQ4； （3）然后工作台A由SQ2自动退至SQ1； （4）最后工作台B由SQ4自动退至SQ3。  试画出逻辑关系图，标明各信号特性及电动机M1、M2正反转控制接触器的工作区间。

点击查看答案
第8题
[单选题] 循环队列sq中，用数组elem[0‥25]存放数据元素，sq．front指示队头元素的前一个位置，sq．rear指示队尾元素的当前位置，设当前sq．front为20，sq．rear为12，则当前队列中的元素个数为（）。

A、8  B、16  C、17  D、18  

点击查看答案
第9题
[单选题] A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）

A、When view V1 is created  B、Each time the REFRESH VIEW v1 statement is executed  C、Each time an SQL statement is executed against view V1  D、Only the first time an SQL statement is executed against view V1  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服