可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You executed this comm


You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()

  • AThe rows stay in the table only until session termination.
  • BThe rows stay in the table only until the next transaction starts on the table.
  • CThe rows are visible to all current sessions after the transaction is committed.
  • DThe rows stay available for subsequent sessions after the transaction is committed
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、You executed the follo

You executed the following procedure to collect statistics regarding an index:      ...

2、You execute the follow

You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION&en...

3、You execute the follow

You execute the following command to audit the database activities:  SQL> AUDIT DROP ANY ...

4、You execute the follow

You execute the following command in your Supportcenter.cn production database to change the width&e...

5、You executed the follo

You executed the following code:  BEGIN  DBMS_SCHEDULER.SET_ATTRIBUTE (  NAME => ’JOB_A&rsqu...

6、You execute the follow

You execute the following command to start an Automatic Storage Management (ASM) instance:  ...