OCP-052考试题库汇总(46)-CUUG内部解答版

简介: Examine this command:SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area(startdate DATE,enddate DATE,class CHAR(20)) ON COMMIT PRESERVE ROWS;Whi...

Examine this command:

SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area

(startdate DATE,

enddate DATE,

class CHAR(20)) ON COMMIT PRESERVE ROWS;

Which three statements are true about rows inserted into REPORT_WORK_AREA?

A)Rows will be lost if a ROLLBACK is done.

B)Rows will be lost upon session failure.

C)Rows are visible to all sessions logged in by the same user until the session that inserted the rows terminates.

D)Rows are visible to all sessions logged in by all users granted the DBA role until the session that inserted the rows terminates.

E)Rows will be lost upon session normal termination.

F)Rows are visible globally to all sessions logged in by any user until the session that inserted the rows terminates.

Answer: ABE

赵:

on commit delete rows,事务提交时自动删除临时表中的记录。

on commit preserve rows,当用户退出 session 时(会话结束后)自动清除临时表的数据。

前者在事务提交后数据就已经清除了.后者在会话中止时或者正 s 常退出时数据都会被清除掉.

CDF 错,Temporary Table 的数据存放在 PGA 或临时表空间下,它被每个 session 单独使用,即隔离session 间的数据,每个 session 只能看到自己的数据。

目录
相关文章
OCP-052考试题库汇总(58)-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
800 0
OCP-052考试题库汇总(57)-CUUG内部解答版
Examine these facts about a databases: 1.USERS is the database default tablespace. 2.USER1,USER2,and USER3 have the CREATE SESSION privilege 3.
771 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(49)-CUUG内部解答版
Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE.
1007 0
|
数据库 存储
OCP-052考试题库汇总(48)-CUUG内部解答版
Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.
778 0
|
SQL
OCP-052考试题库汇总(44)-CUUG内部解答版
Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL.
8280 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(39)-CUUG内部解答版
Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are always stored in the database.
774 0
|
数据安全/隐私保护 关系型数据库 Oracle
OCP-052考试题库汇总(35)-CUUG内部解答版
Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A)If the directory used in the export operation has existing dump files, it overwrites them.
732 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(32)-CUUG内部解答版
Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN IN READ ONLY mode D)OPEN IN RESTRICTED mode E)MOUNT ...
742 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(28)-CUUG内部解答版
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, and not specified.
645 0
|
机器学习/深度学习 Oracle 关系型数据库
OCP-052考试题库汇总(25)-CUUG内部解答版
Which four database objects never have any segments? A)A partitioned index B)A view selecting from a populated table C)An empty index D)An Oracle Loader type external table E)An empty table F)A view selecting from an empty table G)An Oracle Data Pump type external table Answer: BDFG 赵:视图和外部表不存在段。
757 0
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等