[单选]
You executed this command to create a temporary table：
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）

A . The rows stay in the table only until session termination.
B . The rows stay in the table only until the next transaction starts on the table.
C . The rows are visible to all current sessions after the transaction is committed.
D . The rows stay available for subsequent sessions after the transaction is committed

To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（） EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor。 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor。 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor。 Either B or C。 All of the above。时花养护质量标准 While upgrading an existing x445 with a second SMP expansion module and four processors， a technician notices the SMP connector cables are missing on the back， so the technician connects the cables. Upon powering up， the technician notices the upper SMP expansion module is disabled. Which of the following is the most likely cause of the problem？（） The system requires 220V power to enable the upper SMP expansion module.。 The technician cabled the SMP expansions wrong.。 The Xcel4 cache needs to be reset in the BIOS because of the addition of the second SMP expansion module.。 If no hardware licenses keys have been purchased for the processors in the upper SMP expansion module， it will not be activated.。 Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（） Both technologies guarantee an identical copy of data on the secondary node。 Only MySQL can maintain a time-delayed copy of data on the secondary node。 Both technologies use the TCP/IP stack as their primary transmission medium。 DRBD uses shared-disk technology。锅炉排污的目的是（），排污的方式有（）、（）。

You executed this command to create a temporary table：
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-052题库

相关题目: