一又固、源題
QUESTION 36
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command:
LSNRCTL> STOP
What happens to the sessions that are presently connected to the database instance?
A. The sessions are able to perform only queries
B. The sessions are not affected and continue to function normally
C. The sessions are terminated and the active transactions are rolled back
D. The sessions are not allowed to perform any operations till the listener is started
Correct Answer: B
二淋样、題目翻譯
你的數(shù)據(jù)庫處于open且LISTENER正在運行缅阳。新的DBA停止監(jiān)聽使用命令：
command: LSNRCTL> STOP
現(xiàn)在連接數(shù)據(jù)庫實例會話會發(fā)生什么？
A. 會話只能執(zhí)行查詢
B. 會話無影響并且功能正常
C. 會話中止并且活動的事務(wù)回滾
D. 會話不允許任何操作直到監(jiān)聽啟動

答案：B
三雷袋、題目解析
當(dāng)會話連接到數(shù)據(jù)庫，即使停止了監(jiān)聽，也不會影響會話的政策操作
四宏娄、測試
--首先在一個crt窗口連接上數(shù)據(jù)庫

[oracle@oel ~]$ sqlplus sys/oracle@prod as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 22 08:03:32 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from scott.dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

在另外一個crt窗口執(zhí)行下面命令

[oracle@oel ~]$ lsnrctl stop --停止監(jiān)聽

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-APR-2017 08:04:15

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[oracle@oel ~]$ lsnrctl status --查看狀態(tài)

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-APR-2017 08:07:10

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
 TNS-00511: No listener
  Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel.example.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
 TNS-00511: No listener
  Linux Error: 111: Connection refused

在第一個crt窗口驗證是否中斷會話

SQL> select * from scott.dept; --不受影響，執(zhí)行dml也不受影響

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL> exit --退出
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@oel ~]$ sqlplus sys/oracle@prod as sysdba --重新連接逮壁，發(fā)現(xiàn)無法連接了

SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 22 08:04:53 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12541: TNS:no listener

一孵坚、源題
QUESTION 37
You are managing an Oracle Database 11g database with the following backup strategy:

1. On Sunday, an incremental level 0 tape backup is performed
2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed
   Which two statements are true regarding the backups performed? (Choose two.)
   A. The backup performed in step 1 backs up all blocks that have ever been in use in the database
   B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup
   C. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup
   D. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1
   Correct Answer: AB
   二、題目翻譯
   你管理一個Oracle Database 11g數(shù)據(jù)庫使用下面的備份策略：

3.    周日執(zhí)行一個level 0增量磁帶備份
   

4.    周一到周六窥淆，執(zhí)行一個level 1累積增量磁帶備份
   

哪兩句是正確的關(guān)于執(zhí)行備份卖宠？（選擇兩個）
A. 第一步執(zhí)行的備份會備份所有數(shù)據(jù)庫使用過的數(shù)據(jù)塊
B. 第二步執(zhí)行的備份拷貝所有自從上次level 0備份改變的數(shù)據(jù)塊
C. 第一步執(zhí)行的備份會備份自從上次level 1備份改變的數(shù)據(jù)塊
D. 第二步執(zhí)行的備份會備份自從上次level 1增量備份改變的數(shù)據(jù)塊

答案：AB
三、題目解析
此題考查的是增量累積備份

一忧饭、源題
QUESTION 38
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old

image.png

What could be the reason for this error?
A. The query is unable to get a read-consistent image.
B. There is not enough space in Flash Recovery Area.
C. There is not enough free space in the flashback archive.
D. The query is unable to place data blocks in undo tablespace.
Correct Answer: A
二扛伍、題目翻譯
查看下圖并檢查undo表空間的屬性。在OLTP系統(tǒng)眷昆，用戶SCOTT在事務(wù)頂峰時期在一個大表啟動一個查詢執(zhí)行批量插入蜒秤。查詢運行超過15分鐘并且SCOTT收到下面錯誤：
ORA-01555: snapshot too old
這個錯誤的原因是什么汁咏？
A. 查詢不能得到一致性讀副本
B. Flash Recovery Area沒有足夠的空間
C. 閃回歸檔沒有足夠的空間
D. 查詢不能放數(shù)據(jù)塊在undo表空間

答案：A
三亚斋、題目解析

[oracle@oel ~]$ oerr ora 1555
01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"
// *Cause: rollback records needed by a reader for consistent read are
//         overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
//          setting. Otherwise, use larger rollback segments

該錯誤的意思是，快照太舊了攘滩，回滾段太小帅刊，
原因：讀一致性需要獲取其他寫用戶的回滾段
解決辦法：如果是自動undo管理模式，增加undo_retention的設(shè)置漂问，否則赖瞒，使用比較大的回滾段
因此選擇A

一女揭、源題
QUESTION 39
Which two operations can be performed on an external table? (Choose two.)
A. Create a view on the table
B. Create an index on the table
C. Create a synonym on the table
D. Add a virtual column to the table
E. Update the table using the UPDATE statement
F. Delete rows in the table using the DELETE command
Correct Answer: AC
二、題目翻譯
哪兩種操作可以在外部表執(zhí)行栏饮？（選擇兩個）
A. 在表上創(chuàng)建視圖
B. 在表上創(chuàng)建索引
C. 在表上創(chuàng)建同義詞
D. 在表上增加一個虛擬列
E. 更新表使用UPDATE語句
F. 刪除行使用DELETE命令

答案：AC
三吧兔、題目解析
你可以做，例如袍嬉，查詢境蔼，連接，排序外部表數(shù)據(jù)伺通，你也可以為外部表創(chuàng)建視圖和同義詞箍土。當(dāng)然，外部表不能做ＤＭＬ操作(update,insert或delete)罐监，不能創(chuàng)建索引吴藻。
You can, for example, select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.
參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables.htm#ADMIN12896

一、源題
QUESTION 40
Which two statements are true regarding listeners? (Choose two.)
A. Listeners use only the TCP/IP protocol.
B. Multiple listener processes can run simultaneously on a host.
C. Multiple database instances can be registered with a single listener.
D. The listener-related errors can be traced only at the administrative level.
E. Only one database instance can be registered with a single listener at any time.
Correct Answer: BC
二弓柱、題目翻譯
哪兩句是正確的關(guān)于監(jiān)聽沟堡？（選擇兩個）
A. Listener只使用TCP/IP協(xié)議
B. 多個linstener進程可以同時運行在一個主機上
C. 多個數(shù)據(jù)庫實例可以在一個監(jiān)聽上注冊
D. Listener相關(guān)的錯誤只能在管理員級別追蹤
E. 一個數(shù)據(jù)庫實例只能被一個listener注冊在任何時候

答案：BC
三、題目解析
A錯誤矢空，還有IPC
B正確弦叶，可以設(shè)置不同的端口號，從而啟動多個監(jiān)聽
C正確妇多，多個數(shù)據(jù)庫可以注冊到同一個監(jiān)聽伤哺。
D錯誤，相關(guān)信息會寫入到Listener Log File
E和C沖突者祖，錯誤

一立莉、源題
QUESTION 41
You set the following parameters in the parameter file and restarted the database:

MEMORY_MAX_TARGET=0 
MEMORY_TARGET=500M 
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M

Which two statements are true about these parameters after the database instance is restarted? (Choose two.)
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
C. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
Correct Answer: AD
二、題目翻譯
設(shè)置下列參數(shù)在參數(shù)文件并重啟數(shù)據(jù)庫

MEMORY_MAX_TARGET=0 
MEMORY_TARGET=500M 
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M

哪兩句是正確的關(guān)于這些參數(shù)在數(shù)據(jù)庫實例重啟之后七问？（選擇兩個）
A. MEMORY_MAX_TARGET參數(shù)自動設(shè)置為500MB
B. PGA_AGGREGATE_TARGET 和SGA_TARGET參數(shù)自動設(shè)置為0
C. MEMORY_MAX_TARGET參數(shù)為0直到手動修改
D. PGA_AGGREGATE_TARGET 和SGA_TARGET的下限分別是90MB和270MB

答案：AD
三蜓耻、題目解析
設(shè)置了MEMORY_TARGET之后，會自動管理sga和pga械巡。
如果只設(shè)置了MEMORY_TARGET刹淌，沒設(shè)置MEMORY_MAX_TARGET，則MEMORY_MAX_TARGET會和MEMORY_TARGET相同讥耗。故A正確
PGA_AGGREGATE_TARGET和SGA_TARGET分別設(shè)置為90M和270M有勾，意味著pga和sga最小不會小于90M和270M，故D正確古程。

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams143.htm#REFRN10285

一蔼卡、源題
QUESTION 42
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:

1. SGA is allocated.
2. Control file is read.
3. Redo log files are opened.
4. Instance recovery is started.
5. Background processes are started.
6. Data file headers are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
   Which option has the correct order in which these steps occur?
   A. 7, 1, 5, 2, 3, 6, 4
   B. 1, 2, 3, 7, 5, 6, 4
   C. 7, 1, 4, 5, 2, 3, 6
   D. 1, 7, 5, 4, 2, 3, 6
   Correct Answer: A
   二宏赘、題目翻譯
   你執(zhí)行SHUTDOWN ABORT命令關(guān)閉數(shù)據(jù)庫實例律杠〗鹗瘢考慮打開數(shù)據(jù)庫之的步驟：

8.    分配SGA
   

9.    讀取控制文件
   

10.    打開日志文件
    

11.    開始實例恢復(fù)
    

12.    啟動后臺進程
    

13.    檢查數(shù)據(jù)文件頭一致性
    

14.    讀取spfile或pfile文件
    

哪個是正確的步驟珠移？
A. 7, 1, 5, 2, 3, 6, 4
B. 1, 2, 3, 7, 5, 6, 4
C. 7, 1, 4, 5, 2, 3, 6
D. 1, 7, 5, 4, 2, 3, 6

答案：A
三、題目解析
本題考查的是數(shù)據(jù)庫啟動

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e25494/start.htm#ADMIN11142

一塘砸、源題
QUESTION 43
A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?
A. Set REMOTE_OS_ROLES to FALSE
B. Set OS_ROLES parameter to FALSE
C. Set the REMOTE_OS_AUTHENT parameter to FALSE
D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE
Correct Answer: C
二节仿、題目翻譯
一個用戶，通過外部認證掉蔬，登錄一個遠程機器并連接數(shù)據(jù)庫實例粟耻。你采取什么行動才能確保用戶僅僅不能通過遠程機器連接數(shù)據(jù)庫實例？
A. 設(shè)置REMOTE_OS_ROLES為false
B. 設(shè)置OS_ROLES為false
C. 設(shè)置REMOTE_OS_AUTHENT參數(shù)為false
D. 設(shè)置REMOTE_LOGIN_PASSWORD_FILE參數(shù)為none

答案：C
三眉踱、題目解析
參數(shù)REMOTE_OS_ROLES指定操作系統(tǒng)角色是否被遠程客戶端允許
參數(shù)OS_ROLES定義了是由Oracle還是操作系統(tǒng)來驗證和管理每個用戶的角色挤忙。TRUE表示操作系統(tǒng)管理，F(xiàn)LASE表示Oracle自身驗證和管理角色谈喳。
參數(shù)REMOTE_OS_AUTHENT用來限制外部驗證的方式遠程數(shù)據(jù)庫驗證册烈。FLASE不允許，TRUE代表允許
參數(shù)REMOTE_LOGIN_PASSWORD_FILE代表是否使用口令文件驗證婿禽，NONE是不使用赏僧，exclusive獨占口令文件，share共享口令文件

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_network_secure.htm#TDPSG60672
四扭倾、測試

SQL> show parameter REMOTE_OS_AUTHENT

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_os_authent                    boolean     FALSE

一淀零、源題
QUESTION 44
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)
A. The MTTR advisor will be disabled
B. Automatic checkpoint tuning will be enabled
C. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET
D. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter
Correct Answer: BC
二、題目翻譯
哪兩句是正確的關(guān)于設(shè)置FAST_START_MTTR_TARGET初始參數(shù)為非零值膛壹？（選擇兩個）
A. MTTR advisor會被禁用
B. 自動檢查點調(diào)優(yōu)被啟用
C. 初始參數(shù)LOG_CHECKPOINT_INTERVAL會被FAST_START_MTTR_TARGET重寫
D. 實例崩潰后恢復(fù)實例花費的時間總是恰好同F(xiàn)AST_START_MTTR_TARGET初始參數(shù)給的值

答案：BC
三驾中、題目解析
啟用MTTR Advisor需要設(shè)置STATISTICS_LEVEL和FAST_START_MTTR_TARGET，故A錯
快速啟動檢查點功能是通過指定所需的非零恢復(fù)平均時間（MTTR）值來啟用的模聋，該值將用于設(shè)置FAST_START_MTTR_TARGET初始化參數(shù)肩民。此參數(shù)控制數(shù)據(jù)庫對單個實例執(zhí)行崩潰恢復(fù)所花費的時間量。啟用快速啟動檢查點功能時链方，Oracle將自動保持檢查點的速度持痰，已便達到請求的MTTR.如果將該值設(shè)置為0，將禁用此功能祟蚀，故B正確
FAST_START_MTTR_TARGET 會被 LOG_CHECKPOINT_INTERVAL所覆蓋工窍，故C正確
D錯誤，是在所需時間內(nèi)或在盡量接近此事件的范圍內(nèi)前酿，并不是指定的時間點

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams090.htm#REFRN10058
四患雏、測試

SQL> show parameter FAST_START_MTTR_TARGET

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target               integer     41
SQL> show parameter LOG_CHECKPOINT_INTERVAL

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_checkpoint_interval              integer     0

一、源題
QUESTION 45
You want to create a role to meet these requirements:

1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
   Which method would you use to restrict enabling of such roles?
   A. Create the role with external authentication.
   B. Create the role as a secure application role.
   C. Create the role as a password-protected role. operating system group that will be specified must have p
   D. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
   Correct Answer: B
   二薪者、題目翻譯
   你想創(chuàng)建一個角色有下面這些需求：

3.    創(chuàng)建一個角色防止未授權(quán)使用
   

4.    角色的密碼沒有嵌入到應(yīng)用的源碼或存儲在表里
   

哪些方法你可以用來限制使用這樣的角色纵苛？
A. 創(chuàng)建角色使用外部認證
B. 創(chuàng)建角色作為安全應(yīng)用程序角色
C. 創(chuàng)建角色作為密碼保護角色剿涮。
D. 創(chuàng)建角色并使用FGAC去保護角色

答案：C
三言津、題目解析
secure application role, 是授予給應(yīng)用程序用戶的數(shù)據(jù)庫角色攻人，通過調(diào)用者權(quán)限存儲過程從數(shù)據(jù)庫表獲取角色的口令。
secure application role的口令不是嵌在應(yīng)用程序中的

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/network.112/e36292/glossary.htm#i996755

一悬槽、源題
QUESTION 46
View the Exhibit and identify the component marked with a question mark.

image.png

A. Checkpoint (CKPT)
B. Process Monitor (PMON)
C. Archiver Processes (ARcn)
D. Recoverer Process (RECO)
E. Memory Manager Process (MMAN)
Correct Answer: A
二怀吻、題目翻譯
查看下圖并鑒別問號標(biāo)志的組件。

A. Checkpoint (CKPT)
B. Process Monitor (PMON)
C. Archiver Processes (ARcn)
D. Recoverer Process (RECO)
E. Memory Manager Process (MMAN)

答案：A
三初婆、題目解析
檢查點被記錄在控制文件和每個數(shù)據(jù)文件的文件頭蓬坡。
出現(xiàn)檢查點的時候，DBWr會將所有修改的緩沖區(qū)內(nèi)容寫到數(shù)據(jù)文件中
當(dāng)DBWr需要寫入的數(shù)據(jù)的SCN號大于LGWR記錄的SCN號磅叛，會觸發(fā)LGWR寫入
故可以知道問好處應(yīng)為CKPT

參考文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT1246

一屑咳、源題
QUESTION 47
Note the following points describing various utilities in Oracle Database 11g:

1. It enables the transfer of data from one database to another
2. It provides a complete solution for the backup, restoration and recovery needs of the entire database
3. It enables the loading of data from an external file into tables of an Oracle Database
4. It provides a tape backup management for the Oracle ecosystem
   Which point describes the Oracle Data Pump utility?
   A. 1
   B. 2
   C. 3
   D. 4
   E. 1 and 3
   F. 1, 2, 3 and 4
   Correct Answer: A
   二、題目翻譯
   注意以下幾點描述Oracle Database 11g各種功能：

5.    它使數(shù)據(jù)從一個數(shù)據(jù)庫轉(zhuǎn)移到另一個地方
   

6.    它提供了一個備份弊琴，恢復(fù)和恢復(fù)整個數(shù)據(jù)庫的完整解決方案
   

7.    它使數(shù)據(jù)從外部文件加載到數(shù)據(jù)庫的表
   

8.    提供了一個Oracle磁帶備份管理生態(tài)系統(tǒng)
   

哪一個描述了Oracle Data Pump功能兆龙？
A.1
B.2
C.3
D. 4
E. 1 and 3
F. 1, 2, 3 and 4

答案：A
三、題目解析
1　描述的是數(shù)據(jù)泵的功能
2　是RMAN
3　是SQL*Load
4　是Oracle Secure Backup

一敲董、源題
QUESTION 48
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this?
A. To limit the User Global Area (UGA) memory allocated to a session from the SGA
B. To limit the amount of memory to be used for the dispatcher queue of a session in SGA
C. To limit the amount of memory to be used for the request pool in System Global Area (SGA)
D. To control the amount of memory allocated in SGA for the local variables for each shared server process
Correct Answer: A
二紫皇、題目翻譯
你的數(shù)據(jù)庫配置為共享服務(wù)模式。然而腋寨，你的高級dba要求你修改PRIVATE_SGA的值限制用戶資源聪铺。原因可能是什么？
A. 限制從SGA分配給會話的UGA
B. 限制SGA中一個會話中用于調(diào)度隊列的內(nèi)存數(shù)量
C. 限制SGA中用于request pool的內(nèi)存數(shù)量
D. 控制SGA中分配給每個共享服務(wù)進程的本地變量的內(nèi)存數(shù)量

答案：A
三萄窜、題目解析
在專用服務(wù)器模式下铃剔，進程和會話是一對一的關(guān)系，UGA被包含在PGA中查刻，
在共享服務(wù)器模式下番宁，進程和會話是一對多的關(guān)系，UGA在大池(Large Pool)中分配赖阻。
如果分配失敗蝶押，如大型池太小，或是根本沒有設(shè)置大型池火欧，則從共享池(Shared Pool)中分配

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e41573/memory.htm#PFGRF94334

一棋电、源題
QUESTION 49
You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:

1. SGA is allocated.
2. Control file is read.
3. Redo log files are read.
4. Instance recovery is started.
5. Background processes are started.
6. Data files are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
   Which option has the correct order in which these steps occur? A. 7, 1, 5, 2, 3, 6, 4
   B. 1, 5, 7, 2, 3, 6; step 4 is not required
   C. 7, 1, 5, 2, 3, 6 step 4 is not required
   D. 1, 2, 3, 5, 6, 4; step 7 is not required
   Correct Answer: C
   二、題目翻譯
   你使用IMMEDIATE選項關(guān)閉數(shù)據(jù)庫實例苇侵「峡考慮打開數(shù)據(jù)庫需要執(zhí)行的步驟：

8.    分配SGA
   

9.    讀取控制文件
   

10.    讀取日志文件
    

11.    開始實例恢復(fù)
    

12.    啟動后臺進程
    

13.    檢查數(shù)據(jù)文件一致性
    

14.    讀取spfile或者pfile
    

哪個選項是正確的關(guān)于這些步驟？

A. 7, 1, 5, 2, 3, 6, 4
B. 1, 5, 7, 2, 3, 6; step 4 is not required
C. 7, 1, 5, 2, 3, 6 step 4 is not required
D. 1, 2, 3, 5, 6, 4; step 7 is not required

答案：C
三榆浓、題目解析
shutdown abort后于未，再startup，需要用到smon進行實例恢復(fù)，而shutdown immediate則不需要進行實例恢復(fù)烘浦。

一抖坪、源題
QUESTION 50
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?
A. The minimum memory size for the database buffer cache is set to 100 MB.
B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.
C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.
D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.
Correct Answer: A
二、題目翻譯
你的數(shù)據(jù)庫啟用了自動共享內(nèi)存管理（ASMM）闷叉。ASMM管理的組件的初始化參數(shù)沒有設(shè)置擦俐。為了觀察ASMM的影響，你執(zhí)行下面命令：

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

哪些語句是正確的在這個場景握侧？

A. 數(shù)據(jù)庫buffer cache的最小設(shè)置為100MB
B. 在ASMM中數(shù)據(jù)庫buffer cache最大可以獲得的內(nèi)存是100MB
C. 數(shù)據(jù)庫buffer cache在專用模式下分配給一個服務(wù)進程最小為100MB
D. 數(shù)據(jù)庫buffer cache動態(tài)管理被釋放的最大值設(shè)置為100MB

答案：A
三蚯瞧、題目解析
啟用ASMM 之前，應(yīng)該從 SPFILE 中刪除單個內(nèi)存區(qū)參數(shù)品擎，因為設(shè)置這些參數(shù)會使
ASMM 受到限制埋合。看到 ASMM 分配的效果之后萄传，如果決定要調(diào)整特定組件的分配值饥悴，可以為這些組件指定值。如果指定的值比目前的值小盲再，這些值將被視為各個組件的最小內(nèi)存大小西设。如果指定的值比目前的值大，那么只要有空閑內(nèi)存答朋，就可以將內(nèi)存組件的大小重新上調(diào)至您提供的值贷揽。執(zhí)行此操作會限制可用于自動調(diào)整的內(nèi)存量，但在環(huán)境需要對大小進行特殊調(diào)整梦碗、而ASMM 又無法滿足此需要時禽绪，可使用此功能。

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#ADMIN00207

一洪规、源題
QUESTION 51
Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)
A. The SGA advisor will be disabled
B. The MTTR advisor will be disabled
C. Automatic checkpoint tuning will be disabled
D. Checkpoint information will not be written to the alert log file
Correct Answer: BC
二印屁、題目翻譯
檢查下面初始化參數(shù)的值：
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
哪兩個將被影響在你的數(shù)據(jù)庫中？（選擇兩個）
A. SGA advisor將被禁用
B. MTTR advisor將被禁用
C. Automatic checkpoint tuning將被禁用
D. 檢查點信息將被寫入alert日志中

答案：BC

一斩例、源題
QUESTION 52
View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true about the output of the command?

image.png

A. The backup piece is expired as the new backup is available
B. The backup piece is expired because the operating-system file was not found
C. The backup piece is expired because the retention period for the backup has expired
D. The backup piece is expired because the backup set to which it belongs is not complete
Correct Answer: B
二雄人、題目翻譯
查看下表并檢查CROSSCHECK BACKUP命令的輸出結(jié)果。
哪些語句是正確的關(guān)于命令的輸出

A. 備份片失效因為新的備份是可用的
B. 備份片失效因為操作系統(tǒng)上文件找不到
C. 備份片失效因為備份保留時間失效
D. 備份片失效因為它所屬的備份集不完整

答案：B
三念赶、題目解析
CROSSCHECK BACKUP的作用是檢查備份的可用性（物理上是否存在）础钠，并對失效的備份集打上expired標(biāo)記
ACD都屬于違背備份策略的備份集，需要使用obsolete操作叉谜。

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmmaint.htm#BRADV8171

一旗吁、源題
QUESTION 53
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?
A. The extents in the undo tablespace retain data until the next full database backup
B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down
D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten
Correct Answer: B
二、題目翻譯
你的數(shù)據(jù)庫實例配置UNDO自動管理并且UNDO_RETENTION參數(shù)設(shè)置為900秒停局。執(zhí)行下面的命令啟用retention guarantee：
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
這個命令在數(shù)據(jù)庫中會有什么影響很钓？
A. undo表空間中的extent會保留數(shù)據(jù)直到下次數(shù)據(jù)庫完整備份
B. undo表空間中的包含已提交的undo的extent不會被覆蓋在15分鐘內(nèi)
C. undo表空間中的包含已提交的data的extent不會被覆蓋直到數(shù)據(jù)庫實例關(guān)閉
D. undo表空間中包含已提交的undo的extent會被傳輸?shù)紽lash Recovery Area在被覆蓋前

答案：B
三香府、題目解析
因為undo表空間是自動管理的，所以執(zhí)行上面的命令后码倦，UNDO_RETENTION變成強依賴參數(shù)企孩，即使拒絕執(zhí)行SQL DML操作，也不會發(fā)生undo數(shù)據(jù)覆蓋的情況叹洲。

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams265.htm#REFRN10225

一柠硕、源題
QUESTION 54
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files?
A. Archiving will be disabled because the destination for the redo log files is missing
B. The database instance will shut down and the error details will be logged in the alert log file
C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly
D. Archiving will be enabled and the location for the archive redo log file will be created in the default location $ORACLE_HOME/log
Correct Answer: C
二工禾、題目翻譯
為數(shù)據(jù)庫配置Flash Recovery Area运提。數(shù)據(jù)庫實例啟動于ARCHIVELOG模式并且LOG_ARCHIVE_DEST_1參數(shù)沒有設(shè)置。歸檔和歸檔日志的位置會受到什么影響闻葵？
A. 歸檔會被禁用因為歸檔目的地丟失
B. 數(shù)據(jù)庫實例會關(guān)閉并將錯誤詳細記錄在alert之日中
C. 歸檔會啟用且歸檔日志將會設(shè)置為Flash Recovery Area
D. 歸檔會啟用且歸檔日志會默認創(chuàng)建在$ORACLE_HOME/log

答案：C
三民泵、題目解析
如果打開歸檔，并且沒有指定歸檔路徑的話槽畔，那么默認就是在閃回恢復(fù)區(qū)

一栈妆、源題
QUESTION 55
Which is the correct description of a pinned buffer in the database buffer cache?
A. The buffer is currently being accessed
B. The buffer is empty and has not been used
C. The contents of the buffer have changed and must be flushed to the disk by the DBWn process
D. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk
Correct Answer: A
二、題目翻譯
哪些描述是正確的關(guān)于數(shù)據(jù)庫buffer cache中的pinned buffer厢钧？
A. buffe目前正在被訪問
B. buffer是空的鳞尔，沒有被使用
C. buffer的內(nèi)容被修改且必須通過DBWn進程刷新到磁盤
D. buffer作為即將老化的候選并且內(nèi)容和磁盤上的內(nèi)容相同

答案：A
三、題目解析
Every buffer has an access mode: pinned or free (unpinned). A buffer is "pinned" in the cache so that it does not age out of memory while a user session accesses it. Multiple sessions cannot modify a pinned buffer at the same time.
每個buffer都有一個訪問方式：pinned 或者free（unpinned）早直。Buffer固定在cache中以至于內(nèi)存不會老化當(dāng)一個用戶會話訪問的時候寥假。多個會話不能同時修改pinned buffer
參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT1222

一、源題
QUESTION 56
In which situation would you use static database registration for a listener?
A. When multiple databases are to be registered with the listener
B. When DBAs need to connect remotely to start up the database instance
C. When users need to connect the database instance using the host naming method
D. When the database instance that is to be registered with the listener is configured in shared server mode
Correct Answer: B
二霞扬、題目翻譯
在什么情況下你使用數(shù)據(jù)庫靜態(tài)注冊監(jiān)聽糕韧？
A. 當(dāng)多個數(shù)據(jù)庫被注冊使用監(jiān)聽
B. 當(dāng)DBA需要遠程啟動數(shù)據(jù)庫實例
C. 當(dāng)用戶需要連接數(shù)據(jù)庫實例使用主機名方法
D. 當(dāng)數(shù)據(jù)庫實例被使用監(jiān)聽注冊配置為共享服務(wù)模式

答案：B
三、題目解析
靜態(tài)注冊可以遠程管理數(shù)據(jù)庫喻圃，比如數(shù)據(jù)庫的起停萤彩，而動態(tài)注冊必須數(shù)據(jù)庫啟動才可以
動態(tài)注冊為ready從字面的意思理解為準(zhǔn)備好，而靜態(tài)注冊為unknow也就是不知道數(shù)據(jù)庫狀態(tài)

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/network.112/e41945/listenercfg.htm#NETAG1154

一斧拍、源題
QUESTION 57
While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?
A. Validate the index structure using the ANALYZE .... INDEX command
B. Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command
C. Change the block space utilization parameters using the ALTER INDEX command
D. Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command
Correct Answer: B
二雀扶、題目翻譯
觀察索引統(tǒng)計信息，你發(fā)現(xiàn)一個索引高度分裂肆汹，從而導(dǎo)致數(shù)據(jù)庫性能下降怕吴。哪種方法你可以用來減少分裂不影響正在使用索引的用戶？
A. 分析索引結(jié)構(gòu)使用ANALYZE……INDEX命令
B. 重建索引使用ALTER INDEX…..REBUILD ONLINE命令
C. 改變塊空間利用率使用ALTER INDEX命令
D. 釋放未使用的空間索引使用ALTER INDEX……DEALLOCATE UNUSED命令

答案：B
三县踢、題目解析
由于頻繁的dml转绷，索引就會產(chǎn)生碎片，它的效率會越來越慢硼啤，因此就需要重建议经，
可以使用online關(guān)鍵字在線重建索引，因為重建索引的時候會加鎖，假如該關(guān)鍵字后煞肾，可以使加鎖時間變的很短咧织，從而減少對使用索引用戶的影響

參考官方文檔:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_1010.htm#SQLRF00805

一、源題
QUESTION 58
See the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

image.png

A. The user must enable the role explicitly
B. The user can grant the role to other users
C. The user cannot user the role until the DBA enables it explicitly
D. The user can start using the role immediately without any changes
Correct Answer: A
二籍救、題目翻譯
觀察下圖SL_REP用戶分配的角色习绢。哪些語句是正確的關(guān)于分給SL_REP用戶的SELECT_CATALOG_ROLE角色？
A. 用戶必須顯式的啟用角色
B. 用戶可以授予角色給其他的用戶
C. 用戶不能使用角色直到DBA顯式的啟用它
D. 用戶可以立即使用角色不做任何改變

答案：A
select_catalog_role 是一種角色蝙昙，題中默認為N闪萄，需要重新登錄或者顯式的set role 來生效，所以選A奇颠。

一败去、源題
QUESTION 59
To make audit information more productive, the DBA executes the following command before starting an audit operations:
SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting the database?
A. It contains only the plan for the SQL statement executed by the user
B. It contains the SQL text executed by the user and the bind variables used with it
C. It contains the plan and statistics associated with the SQL statement executed by the user
D. It contains the plan for the SQL statement executed by the user and the bind variables used with it
Correct Answer: B
二、題目翻譯
為了使審計更生產(chǎn)化烈拒，DBA執(zhí)行下面命令在開始審計操作之前：
SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
哪些語句是正確的關(guān)于審計記錄產(chǎn)生當(dāng)啟動審計在重啟數(shù)據(jù)庫后圆裕？
A. 只包含用戶執(zhí)行的SQL語句執(zhí)行計劃
B. 包含用戶執(zhí)行的SQL文本和它使用的綁定變量
C. 包含用戶執(zhí)行的執(zhí)行計劃和統(tǒng)計信息相關(guān)的SQL語句
D. 包含用戶執(zhí)行的SQL語句執(zhí)行計劃和使用的綁定變量

答案：B
三、題目解析
AUDIT_TRAIL值含義如下：
DB：啟用審計荆几，信息記錄在SYS.AUD$中
OS：啟用審計吓妆，審計信息保存在操作系統(tǒng)，Oralce建議使用該配置
Db吨铸，extended：啟用審計行拢，并且記錄對應(yīng)的執(zhí)行語句
Xml：啟用審計，審計信息以xml形式保存在操作系統(tǒng)上
Xml焊傅，extended：啟用審計剂陡，并且包括所有的執(zhí)行語句
db, extended
Performs all actions of AUDIT_TRAIL=db, and also populates the SQL bind and SQL text CLOB-type columns of the SYS.AUD$ table, when available. These two columns are populated only when this parameter is specified.

If the database was started in read-only mode with AUDIT_TRAIL set to db, extended, then Oracle Database internally sets AUDIT_TRAIL to os. Check the alert log for details.
參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams017.htm#REFRN10006

一、源題
QUESTION 60
database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:
$ impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"
The command fails displaying the following error:

ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable to obtain file status

What would you do to overcome the error?
A. Add the user, SYSTEM, to the schemas option.
B. Add the network_link = devdb.us.oracle.com option.
C. Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D. Replace the schemas option with the network_link = devdb.us.oracle.com
E. Replace the dumpfile option with the network_link = devdb.us.oracle.com
Correct Answer: E
二狐胎、題目翻譯
你想導(dǎo)入HR用戶使用數(shù)據(jù)泵從開發(fā)數(shù)據(jù)庫DEVDB到生產(chǎn)數(shù)據(jù)庫PRODDB鸭栖。一個數(shù)據(jù)庫連接devdb.us.oracle.com被創(chuàng)建在PRODDB和DEVDB之間。你執(zhí)行下面命令在PRODDB數(shù)據(jù)庫服務(wù)端：
$ impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"
命令報錯如下：

ORA-39001: invalid argument value 
ORA-39000: bad dump file specification 
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable to obtain file status

你做什么來解決這個錯誤握巢？
A. 增加用戶SYSTEM在schema選項
B. 增加network_link=devdb.us.oracle.com 選項
C. 改變dumpfile選項為schema.dat@devdb.us.oracle.com
D. 代替schema選項為network_link = devdb.us.oracle.com
E. 代替dumpfile選項為network_link = devdb.us.oracle.com
答案：E
三晕鹊、題目解析
impdp hr TABLES=employees DIRECTORY=dpump_dir1 NETWORK_LINK=source_database_link EXCLUDE=CONSTRAINT
通過database link 導(dǎo)數(shù)據(jù)需要提供參數(shù) network_link ，這時不會生成 dump file暴浦，所以不需要dumpfile 參數(shù)溅话。
參考官方文檔：http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#SUTIL300

一、源題
QUESTION 61
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A. The ADDM requires at least four AWR snapshots for analysis
B. The ADDM runs after each AWR snapshot is collected automatically by MMON
C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
D. The ADDM analysis provides only diagnostics information but does not provide recommendations
E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors
Correct Answer: BC

二歌焦、題目翻譯
哪兩句是正確的關(guān)于自動數(shù)據(jù)庫診斷監(jiān)視器（ADDM）飞几？（選擇兩個）
A. ADDM需要至少四個AWR快照用于分析
B. ADDM運行在MMON自動收集每個AWR快照之后
C. ADDM分析的結(jié)果存儲在AWR
D. ADDM分析提供診斷信息不提供建議
E. ADDM調(diào)用其它advisors如果需要，但是不提供建議

答案：BC
三独撇、題目解析
ADDM
每個awr快照被記錄后屑墨，addm就會自動運行躁锁，分析與最后兩個快照對應(yīng)的時段中的數(shù)據(jù)，addm會主動監(jiān)視實例
多數(shù)情況下卵史，addm會為檢測到的問題提供解決方案战转，addm可以檢測到一些常見問題如下

1. cpu瓶頸
2. oracle net 連接管理問題
3. 鎖的競爭
4. IO問題
5. 一些數(shù)據(jù)庫實例內(nèi)存結(jié)構(gòu)的大小不足
6. 過載的sql語句
7. plsql和java運行時間過長
8. 檢查點負載過高及原因(如日志文件過小)

因此：BC正確

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e41573/diag.htm#PFGRF02602

一、源題
QUESTION 62
Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?
A. Run the root.sh script.
B. Create the oraInst.loc file.
C. Create the tnsnames.ora file.
D. Run the oraInstRoot.sh script.
Correct Answer: B
二以躯、題目翻譯
哪些任務(wù)需要執(zhí)行在你運行Oracle Universal Installer（OUI）在靜默模式或suppressed模式安裝之前槐秧？
A. 運行root.sh腳本
B. 創(chuàng)建oraInst.loc文件
C. 創(chuàng)建tnsname.ora文件
D. 運行oraInstRoot.sh腳本

答案：B
三、題目解析
oraInst.loc是定義inventory路徑的忧设，必須咋運行OUI之前創(chuàng)建
root.sh和oraintRoot.sh都是安裝的時候執(zhí)行的
tnsnames.ora是配置網(wǎng)絡(luò)連接遠程的
To install and configure Oracle products using Oracle Universal Installer in silent or suppressed mode, follow these steps:
Create the oraInst.loc file.
Prepare a response file.
Run Oracle Universal Installer in silent or suppressed mode.
參考官方文檔：
http://docs.oracle.com/cd/E11882_01/gateways.112/e12076/responsefiles.htm#IVACU592

一刁标、源題
QUESTION 63
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:

1. Shut down the instance.
2. Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3. Execute the ALTER DATABASE FLASHBACK OFF command.
4. Start up the instance and mount the database.
5. Execute the ALTER DATABASE FLASHBACK ON command.
6. Open the database.
   Select the correct order in which these tasks need to be performed.
   A. 2, 1, 4, 3, 5, 6
   B. 1, 4, 3, 2, 6, 5
   C. 1, 4, 2, 6, 3, 5
   D. 3, 2, 1, 4, 5, 6
   Correct Answer: A
   二、題目翻譯
   你正在一個使用spfile啟動的數(shù)據(jù)庫實例工作见转。你想移動Flash Recovery Area到一個新的位置命雀。你想Flashback 日志存儲在新的位置蒜哀。下面是完成這項任務(wù)的隨機排序步驟：

1） 關(guān)閉實例
2） 改變參數(shù)DB_RECOVERY_FILE_DEST的值為新的值
3） 執(zhí)行ALTER DATABASE FLASHBACK OFF命令
4） 啟動數(shù)據(jù)庫實例并mount數(shù)據(jù)庫
5） 執(zhí)行ALTER DATABASE FLASHBACK ON命令
6） 打開數(shù)據(jù)庫

選擇正確的執(zhí)行順序
A. 2, 1, 4, 3, 5, 6
B. 1, 4, 3, 2, 6, 5
C. 1, 4, 2, 6, 3, 5
D. 3, 2, 1, 4, 5, 6

答案：A
三斩箫、題目解析
本題是想考查更換Flash Recovery Area的位置

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/flashdb.htm#BRADV594

一、源題
QUESTION 64
You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation?
A. The online redo log files and archived redo log files are required to accomplish the recovery
B. The uncommitted transaction will be committed at the next startup of the database instance
C. The uncommitted transaction is rolled back automatically at the next opening of the database
D. The DBA has to perform the recovery on the database to recover the uncommitted transaction
Correct Answer: C
二撵儿、題目翻譯
你處于一個正在更新一個非常重要的表的事務(wù)中乘客。數(shù)據(jù)庫正在運行的機器因為斷電重啟。這導(dǎo)致數(shù)據(jù)庫實例故障淀歇。哪些語句是正確的在這種情況易核？

A. 完成恢復(fù)需要聯(lián)機重做日志和歸檔日志
B. 下一次數(shù)據(jù)庫實例啟動的時候會提交未提交的事務(wù)
C. 下一次數(shù)據(jù)庫打開會自動回滾未提交的事務(wù)
D. DBA執(zhí)行數(shù)據(jù)庫恢復(fù)去恢復(fù)未提交的事務(wù)

答案：C
三、題目解析
完成恢復(fù)只需要聯(lián)機重做日志浪默，不需要歸檔日志牡直，所以A錯
下一次啟動實例的時候會將位提交的事務(wù)回滾而不是提交，B錯纳决，C對
實例恢復(fù)由SMON自動執(zhí)行碰逸，而不是DBA控制，D錯

一阔加、源題
QUESTION 65
View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0;

image.png

What do you infer from this?
A. The database instance is running with manual PGA management.
B. The database instance is running with manual shared memory management.
C. The database instance has the MEMORY_TARGET value set to a nonzero value.
D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
Correct Answer: C
二饵史、題目翻譯
查看下圖檢查存儲過程輸出結(jié)果，自從數(shù)據(jù)庫實例啟動并經(jīng)歷不同的工作負載在三個不同的時間：
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0;
你能推斷出什么胜榔？
A. 數(shù)據(jù)庫實例正在運行胳喷，使用手動管理PGA
B. 數(shù)據(jù)庫實例正在運行，使用手動管理共享內(nèi)存
C. 數(shù)據(jù)庫實例設(shè)置MEMORY_TARGET為非0值
D. 所有的會話連接數(shù)據(jù)庫實例為專用模式夭织，沒有RMAN或者并行查詢操作執(zhí)行

答案：C
三吭露、題目解析
動態(tài)性能視圖V$MEMORY_DYNAMIC_COMPONENTS顯示所有動態(tài)優(yōu)化的內(nèi)存組件的當(dāng)前大小，其中包括SGA 和實例PGA 的總大小尊惰。三次啟動的SGA的各個組件大小都一樣讲竿，是動態(tài)變化的纬向，PGA也是動態(tài)變化的，所以此數(shù)據(jù)庫是處于自動內(nèi)存管理即AMM戴卜，也即是說MEMORY_TARGET設(shè)定為非零值

一逾条、源題
QUESTION 66
Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
What would be the outcome of this command?
A. The command succeeds only if Automatic Memory Management is not enabled.
B. The command succeeds, but you need to restart the database for changes to take effect.
C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
Correct Answer: C
二、題目翻譯
你的數(shù)據(jù)庫實例啟動使用SPFILE投剥。你執(zhí)行一個命令改變LOG_BUFFER的值：
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
這個命令的輸出結(jié)果是什么师脂？
A. 命令執(zhí)行成功只有自動內(nèi)存管理沒有啟用的時候
B. 命令執(zhí)行成功，但是你需要重啟數(shù)據(jù)庫來生效
C. 命令返回一個錯誤因為redo log buffer不能動態(tài)修改
D. 參數(shù)值被修改并且會立即生效只要SGA中有可用的空間

答案：C
三江锨、題目解析
LOG_BUFFER為靜態(tài)參數(shù)吃警，故只能使用SCOPE=spfile，重啟后生效

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#ADMIN11119
四啄育、測試

SQL> ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

一酌心、源題
QUESTION 67
The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:

image.png

1. Shut down the instance, if not already done.
2. Copy one of the remaining control files to a new location.
3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
   Identify the correct sequence of steps?
   A. 1, 2, 4, 3, 5, 6
   B. 2, 4, 3, 5, 6; 1 not required
   C. 4, 5, 6, 2, 3; 1 not required
   D. 5, 2, 3, 4; 1 and 6 not required
   Correct Answer: A
   二、題目翻譯
   數(shù)據(jù)庫實例正在使用SPFILE挑豌。查看下表并檢查運行DB結(jié)構(gòu)完整性檢查時發(fā)生的錯誤安券。下面給出隨機步驟恢復(fù)錯誤：

7.    關(guān)閉實例，如果尚未完成
   

8.    拷貝一個冗余控制文件到新的位置
   

9.    改變CONTROL_FILES初始參數(shù)的值和新位置一致
   

10.    啟動數(shù)據(jù)庫實例到NOMOUNT階段
    

11.    恢復(fù)數(shù)據(jù)庫到控制文件的故障點
    

12.    打開數(shù)據(jù)庫
    

鑒別正確的步驟順序氓英？
A. 1, 2, 4, 3, 5, 6
B. 2, 4, 3, 5, 6; 1 不需要
C. 4, 5, 6, 2, 3; 1不需要
D. 5, 2, 3, 4; 1 和 6不需要

答案：A
三侯勉、題目解析
本題考查的是使用RMAN恢復(fù)控制文件

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV154

一、源題
QUESTION 68
You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA). Some of the requirements set for your database creation task are:

1. Configure the database to operate in shared server mode.
2. Disable automatic maintenance tasks such as optimizer statistics collection.
3. Configure a naming method to help the remote user connect to the database instance.
4. Use Automatic Storage Management (ASM) for storing the database files.
5. Configure daily database backup to flash recovery area.
6. Configure Enterprise Manager Database Control to manage the database.
   Which of these requirements can be met while creating the database?
   A. 4 and 6
   B. 2, 3, 4, and 6
   C. 1, 2, 4, 5, and 6 D. 1, 2, 3, 4, 5, and 6
   Correct Answer: C
   二铝阐、題目翻譯
   你正在一個新的Oracle 11g數(shù)據(jù)庫工作址貌，只安裝了軟件沒有創(chuàng)建數(shù)據(jù)庫。你計劃使用DBCA創(chuàng)建一個數(shù)據(jù)庫在這個服務(wù)器上徘键。
   一些數(shù)據(jù)庫創(chuàng)建需要的設(shè)置任務(wù)是：

7.    配置數(shù)據(jù)庫為共享服務(wù)器模式
   

8.    禁用自動維護任務(wù)例如優(yōu)化器統(tǒng)計信息收集
   

9.    配置一個命名方法幫助遠程用戶連接數(shù)據(jù)庫實例
   

10.    使用自動儲存管理（ASM）存儲數(shù)據(jù)文件
    

11.    配置日常數(shù)據(jù)庫備份到FRA
    

12.    配置企業(yè)管理控制臺管理數(shù)據(jù)庫
    

哪些要求可以被滿足當(dāng)創(chuàng)建數(shù)據(jù)庫的時候练对？
A. 4 和 6
B. 2, 3, 4, 和 6
C. 1, 2, 4, 5, 和 6
D. 1, 2, 3, 4, 5, 和 6

答案：C
三、題目解析
DBCA創(chuàng)建數(shù)據(jù)庫如下：
1.Database Configuration Assistant:Welcome
2.Database Configuration Assistant,Step 1 of 13:Operations 選擇Create a Database
3.Database Configuration Assistant,Step 2 of 13:Database Templates 選擇General Purpose or Transaction Processing
4.Database Configuration Assistant,Step 3 of 13:Database Identification 填寫Global Database Name和SID
5.Database Configuration Assistant,Step 4 of 13:Management Options 選擇Enterprise Manager和Automatic Maintenance Tasks
6.Database Configuration Assistant,Step 5 of 13:Database Credentials 填寫密碼
7.Database Configuration Assistant,Step 6 of 13:Network Configuration 選擇監(jiān)聽器
8.Database Configuration Assistant,Step 7 of 13:Database File Locations 選擇ASM
9.Database Configuration Assistant,Step 8 of 13:Recovery Configuration快速恢復(fù)區(qū)指定
10.Database Configuration Assistant,Step 9 of 13:Database Content 勾選Sample Schemas
11.Database Configuration Assistant,Step 10 of 13:Initialization Parameters 包括Memory,Sizing,Character Sets,Connection
參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#ADMIN12479

一吹害、源題
QUESTION 69
Examine the following output:

SQL> SELECT index_name,status FROM dba_indexes WHERE status='UNUSABLE';

INDEX_NAME STATUS 
--------------- --------------- 
EIND UNUSABLE 

Which two statements about the above index are true? (Choose two.)
A. It is ignored by the query optimizer.
B. It is not used while the index is being rebuilt.
C. The index cannot be rebuilt, and has to be re-created.
D. The index is automatically rebuilt when used the next time.
二螟凭、題目翻譯
檢查下面的輸出：

SQL> SELECT index_name,status FROM dba_indexes WHERE status='UNUSABLE';

INDEX_NAME STATUS 
--------------- --------------- 
EIND UNUSABLE 

哪兩句關(guān)于索引的描述是正確的？（選擇兩個）
A. 它被查詢優(yōu)化器忽略
B. 它不用被使用當(dāng)重建的時候
C. 索引不能被rebuilt必須重新create
D. 索引會自動rebuilt當(dāng)下次使用的時候

答案：AB
三赠制、題目解析
Creating an Unusable Index
When you create an index in the UNUSABLE
state, it is ignored by the optimizer and is not maintained by DML. An unusable index must be rebuilt, or dropped and re-created, before it can be used.
If the index is partitioned, then all index partitions are marked UNUSABLE.
Beginning with Oracle Database 11g Release 2, the database does not create an index segment when creating an unusable index.
當(dāng)你創(chuàng)建一個索引為UNUSABLE狀態(tài)赂摆，它會被查詢優(yōu)化器忽略并且不會被DML維護。一個UNUSABLE索引必須被rebuilt或刪除后create钟些，在它被使用之前烟号。如果索引被分區(qū)，所有的分區(qū)索引會被標(biāo)記為UNUSABLE政恍。
在Oracle 數(shù)據(jù)庫11g Release 2汪拥，當(dāng)數(shù)據(jù)庫創(chuàng)建一個unusable 索引的時候，不會創(chuàng)建索引段篙耗。

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e25494/indexes.htm#ADMIN13282

一迫筑、源題
QUESTION 70
In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement. What would you do to automate this configuration for the memory components with change in mode of working?
A. Set the SGA_TARGET initialization parameter to zero.
B. Set the PRE_PAGE_SGA initialization parameter to TRUE.
C. Set the MEMORY_MAX_TARGET initialization parameter to zero.
D. Set the SGA_TARGET initialization parameter to a nonzero value.
Correct Answer: D
二宪赶、題目翻譯
在一個大型聯(lián)機事務(wù)處理（OLTP）系統(tǒng)在白天需要巨大的數(shù)據(jù)庫buffer cache。在晚上脯燃，系統(tǒng)支持批量任務(wù)需要設(shè)置large pool為很大的值搂妻。你必須配置內(nèi)存組件同時適應(yīng)峰值要求。
你會怎么做來自動化配置內(nèi)存組件適用模式變化的工作辕棚？
A. 設(shè)置SGA_TARGET初始值為0
B. 設(shè)置PRE_PAGE_SGA初始值為TRUE
C. 設(shè)置MEMORY_MAX_TARGET初始值為0
D. 設(shè)置SGA_TARGET初始值為非0值

答案：D
三欲主、題目解析
因為白天需要大的BUFFER CACHE，晚上需要大的LARGE POOL逝嚎，所以可以啟動ASMM管理扁瓢。
啟動ASMM，需要：
1.除了sga_target,sga_max_size,lock_sga,pre_page_sga需要靜態(tài)調(diào)整外补君，其他都可以動態(tài)調(diào)整
2.啟用方法是需要將sga_target 設(shè)置為非0引几，同時將statistics_level設(shè)置為typical或者all
3.如果使用了自動共享內(nèi)存管理，下面這些緩存區(qū)就不需要在進行設(shè)置了,他們會自動設(shè)置為0
i.db_cache_size
ii.shared_pool_size
iii.large_pool_size
iv.java_pool_size
v.streams_pool
4.盡管使用了assm挽铁，還是可以設(shè)置緩存區(qū)大小的伟桅，設(shè)置后表示的是該緩存區(qū)的下限值，即oracle任何時候該緩存區(qū)都應(yīng)該不小于這個值屿储，至少預(yù)留這么大的空間

一贿讹、源題
QUESTION 71
You have executed this command to change the size of the database buffer cache:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; 
System altered. 

To verify the change in size, you executed this command:

SQL> SHOW PARAMETER DB_CACHE_SIZE 
NAME TYPE VALUE
 -------------- ------------ ------------ 
db_cache_size big integer 4194304 

Why is the value set to 4194304 and not to 2516582?
A. Because 4194304 is the granule size
B. Because 4194304 is the standard block size
C. Because 4194304 is the largest nonstandard block size defined in the database
D. Because 4194304 is the total size of data already available in the database buffer cache
Correct Answer: A
二渐逃、題目翻譯
你執(zhí)行下面命令去改變數(shù)據(jù)庫buffer cache的值：

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; 
System altered.

為了驗證大小的修改够掠，執(zhí)行下面命令：

SQL> SHOW PARAMETER DB_CACHE_SIZE 
NAME TYPE VALUE
-------------- ------------ ------------ 
db_cache_size big integer 4194304

為什么值設(shè)置為4194304,而不是2516582?

A. 因為4194304是粒度大小
B. 因為4194304是標(biāo)準(zhǔn)塊大小
C. 因為4194304是數(shù)據(jù)庫定義中最大的非標(biāo)準(zhǔn)塊大小
D. 因為4194304是數(shù)據(jù)庫buffer cache已使用的數(shù)據(jù)總大小

答案：A
`三、題目解析
如果指定的大小不是粒度的整倍數(shù)茄菊，則約等于到整倍數(shù)疯潭，例如粒度為4M，指定DB_CACHE為10M面殖，則實際上為12M

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#BABGEGEH

一竖哩、源題
QUESTION 72
Identify two situations in which the block header grows in a data block. (Choose two.)
A. When row directories need more row entries
B. When there is row migration in the data block
C. When there is an increase in the PCTFREE value for the data block
D. When more transaction slots are required than are initially configured
Correct Answer: AD
二、題目翻譯
確定數(shù)據(jù)塊塊頭增長的兩種情況（選擇兩個）
A. 當(dāng)行目錄需要更多的行信息
B. 當(dāng)數(shù)據(jù)塊中發(fā)生行遷移
C. 當(dāng)數(shù)據(jù)塊中的PCTFREE的值增加
D. 當(dāng)更多的事務(wù)槽需要比最初設(shè)置

答案：AD
三脊僚、題目解析
塊頭：塊頭包含段類型（如表或索引）相叁、數(shù)據(jù)塊地址、表目錄辽幌、行目錄和事務(wù)處理插槽增淹。每個插槽的大小約為23 字節(jié)，修改塊中的行時會使用這些插槽乌企。塊頭自上而下進行增長虑润。
? 行數(shù)據(jù)：這是塊中行的實際數(shù)據(jù)。行數(shù)據(jù)空間自下而上進行增長加酵。

? 空閑空間：空閑空間位于塊的中部拳喻，允許頭和行數(shù)據(jù)空間在必要時進行增長哭当。當(dāng)插入新行或用更大的值更新現(xiàn)有行的列時，行數(shù)據(jù)會占用空閑空間冗澈。

參考官方文檔：
http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT004

一钦勘、源題
QUESTION 73
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name. Which statement is true in this case?
A. The ORACLE_BASE parameter is not set.
B. The installation is being performed by the root user.
C. The operating system group that will be specified should have root user as its member.
D. The installation is being performed without the "Create Starter Database" option selected.
E. The operating system group that will be specified must have permission to write to the inventory directory.
Correct Answer: E
二、題目翻譯
你正在安裝Oracle 數(shù)據(jù)庫 11g在你的服務(wù)器上亚亲。在安裝期間个盆，Oracle Universal Installer（OUI）提示你輸入產(chǎn)品目錄路徑并提示你指定一個操作系統(tǒng)組名。哪些語句是正確的在這種情況下朵栖？
A. ORACLE_BASE參數(shù)沒設(shè)置
B. 使用root用戶執(zhí)行安裝
C. 被指定的操作系統(tǒng)組應(yīng)該有root用戶作為成員
D. 沒有使用選項"Create Starter Database"執(zhí)行安裝
E. 被指定的操作系統(tǒng)組必須有權(quán)限寫產(chǎn)品目錄

答案：E