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

简介: Which two are true about LGWR?A)LGWR always writes to the redo logs each time a COMMIT occurs.B)LGWR always writes to the redo logs each time a ROLLBACK occurs.

Which two are true about LGWR?

A)LGWR always writes to the redo logs each time a COMMIT occurs.

B)LGWR always writes to the redo logs each time a ROLLBACK occurs.

C)LGWR never writes a single COMMIT to the redo logs.

D)LGWR may write to the redo logs when DBWR writes a dirty buffer.

E)Multiple COMMITs can be written by LGWR in the same write request.

F)LGWR always writes to the redo logs when DBWR writes a dirty buffer.

Answer: DE

赵:AF=>DE

冉:

DE 两个答案更妥,D 比 F 要好,因为 D 答案用了 may 没有用 always

E 答案给的是 group commit 的概念,即在 lgwr 正在执行时,其他会话发生的 commit 可以做为一组,随后一起提交。

目录
相关文章
|
数据安全/隐私保护 关系型数据库 Oracle
OCP-052考试题库汇总(60)-CUUG内部解答版
Examine these facts about a database: The database default tablespace to EXAMPLE. DEFERRED_SEGMENT_CREATION is TRUE (原来为 FALSE,题目有错) Examine these co...
3762 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.
773 0
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 ...
804 0
|
Oracle 关系型数据库 数据库管理
OCP-052考试题库汇总(47)-CUUG内部解答版
Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Oracle ‘s best practices.
857 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(45)-CUUG内部解答版
You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column in a table to access the flat file.
1884 0
|
XML SQL 数据库
OCP-052考试题库汇总(41)-CUUG内部解答版
Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; NAME VALUE ----...
920 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(31)-CUUG内部解答版
which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used to load data from text files.
830 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 ...
746 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(29)-CUUG内部解答版
When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing.
1070 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(30)-CUUG内部解答版
Which two are true about the Inventory directory? A)It is shared by all Oracle software installations on a single server.
703 0