一、源题
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
二、题目翻译
你的数据库处于open且LISTENER正在运行。新的DBA停止监听使用命令：
command: LSNRCTL> STOP
现在连接数据库实例会话会发生什么？
A. 会话只能执行查询
B. 会话无影响并且功能正常
C. 会话中止并且活动的事务回滚
D. 会话不允许任何操作直到监听启动
答案：B
三、题目解析
当会话连接到数据库，即使停止了监听，也不会影响会话的政策操作
四、测试
--首先在一个crt窗口连接上数据库
[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窗口执行下面命令
[oracle@oel ~]$ lsnrctl stop --停止监听
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 --查看状态
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; --不受影响，执行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 --重新连接，发现无法连接了
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:
- On Sunday, an incremental level 0 tape backup is performed
- 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数据库使用下面的备份策略： 周日执行一个level 0增量磁带备份周一到周六，执行一个level 1累积增量磁带备份
哪两句是正确的关于执行备份？（选择两个）
A. 第一步执行的备份会备份所有数据库使用过的数据块
B. 第二步执行的备份拷贝所有自从上次level 0备份改变的数据块
C. 第一步执行的备份会备份自从上次level 1备份改变的数据块
D. 第二步执行的备份会备份自从上次level 1增量备份改变的数据块
答案：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
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系统，用户SCOTT在事务顶峰时期在一个大表启动一个查询执行批量插入。查询运行超过15分钟并且SCOTT收到下面错误：
ORA-01555: snapshot too old
这个错误的原因是什么？
A. 查询不能得到一致性读副本
B. Flash Recovery Area没有足够的空间
C. 闪回归档没有足够的空间
D. 查询不能放数据块在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的设置，否则，使用比较大的回滚段
因此选择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
二、题目翻译
哪两种操作可以在外部表执行？（选择两个）
A. 在表上创建视图
B. 在表上创建索引
C. 在表上创建同义词
D. 在表上增加一个虚拟列
E. 更新表使用UPDATE语句
F. 删除行使用DELETE命令
答案：AC
三、题目解析
你可以做，例如，查询，连接，排序外部表数据，你也可以为外部表创建视图和同义词。当然，外部表不能做ＤＭＬ操作(update,insert或delete)，不能创建索引。
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
二、题目翻译
哪两句是正确的关于监听？（选择两个）
A. Listener只使用TCP/IP协议
B. 多个linstener进程可以同时运行在一个主机上
C. 多个数据库实例可以在一个监听上注册
D. Listener相关的错误只能在管理员级别追踪
E. 一个数据库实例只能被一个listener注册在任何时候
答案：BC
三、题目解析
A错误，还有IPC
B正确，可以设置不同的端口号，从而启动多个监听
C正确，多个数据库可以注册到同一个监听。
D错误，相关信息会写入到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
二、题目翻译
设置下列参数在参数文件并重启数据库
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
哪两句是正确的关于这些参数在数据库实例重启之后？（选择两个）
A. MEMORY_MAX_TARGET参数自动设置为500MB
B. PGA_AGGREGATE_TARGET 和SGA_TARGET参数自动设置为0
C. MEMORY_MAX_TARGET参数为0直到手动修改
D. PGA_AGGREGATE_TARGET 和SGA_TARGET的下限分别是90MB和270MB
答案：AD
三、题目解析
设置了MEMORY_TARGET之后，会自动管理sga和pga。
如果只设置了MEMORY_TARGET，没设置MEMORY_MAX_TARGET，则MEMORY_MAX_TARGET会和MEMORY_TARGET相同。故A正确
PGA_AGGREGATE_TARGET和SGA_TARGET分别设置为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:
- SGA is allocated.
- Control file is read.
- Redo log files are opened.
- Instance recovery is started.
- Background processes are started.
- Data file headers are checked for consistency.
- 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
二、题目翻译
你执行SHUTDOWN ABORT命令关闭数据库实例。考虑打开数据库之的步骤： 分配SGA读取控制文件打开日志文件开始实例恢复启动后台进程检查数据文件头一致性读取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
三、题目解析
本题考查的是数据库启动
参考官方文档：
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
二、题目翻译
一个用户，通过外部认证，登录一个远程机器并连接数据库实例。你采取什么行动才能确保用户仅仅不能通过远程机器连接数据库实例？
A. 设置REMOTE_OS_ROLES为false
B. 设置OS_ROLES为false
C. 设置REMOTE_OS_AUTHENT参数为false
D. 设置REMOTE_LOGIN_PASSWORD_FILE参数为none
答案：C
三、题目解析
参数REMOTE_OS_ROLES指定操作系统角色是否被远程客户端允许
参数OS_ROLES定义了是由Oracle还是操作系统来验证和管理每个用户的角色。TRUE表示操作系统管理，FLASE表示Oracle自身验证和管理角色。
参数REMOTE_OS_AUTHENT用来限制外部验证的方式远程数据库验证。FLASE不允许，TRUE代表允许
参数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
二、题目翻译
哪两句是正确的关于设置FAST_START_MTTR_TARGET初始参数为非零值？（选择两个）
A. MTTR advisor会被禁用
B. 自动检查点调优被启用
C. 初始参数LOG_CHECKPOINT_INTERVAL会被FAST_START_MTTR_TARGET重写
D. 实例崩溃后恢复实例花费的时间总是恰好同FAST_START_MTTR_TARGET初始参数给的值
答案：BC
三、题目解析
启用MTTR Advisor需要设置STATISTICS_LEVEL和FAST_START_MTTR_TARGET，故A错
快速启动检查点功能是通过指定所需的非零恢复平均时间（MTTR）值来启用的，该值将用于设置FAST_START_MTTR_TARGET初始化参数。此参数控制数据库对单个实例执行崩溃恢复所花费的时间量。启用快速启动检查点功能时，Oracle将自动保持检查点的速度，已便达到请求的MTTR.如果将该值设置为0，将禁用此功能，故B正确
FAST_START_MTTR_TARGET 会被 LOG_CHECKPOINT_INTERVAL所覆盖，故C正确
D错误，是在所需时间内或在尽量接近此事件的范围内，并不是指定的时间点
参考官方文档：
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:
- The role is to be protected from unauthorized usage.
- 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
二、题目翻译
你想创建一个角色有下面这些需求： 创建一个角色防止未授权使用角色的密码没有嵌入到应用的源码或存储在表里
哪些方法你可以用来限制使用这样的角色？
A. 创建角色使用外部认证
B. 创建角色作为安全应用程序角色
C. 创建角色作为密码保护角色。
D. 创建角色并使用FGAC去保护角色
答案：C
三、题目解析
secure application role, 是授予给应用程序用户的数据库角色，通过调用者权限存储过程从数据库表获取角色的口令。
secure application role的口令不是嵌在应用程序中的
参考官方文档：
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.
A. Checkpoint (CKPT)
B. Process Monitor (PMON)
C. Archiver Processes (ARcn)
D. Recoverer Process (RECO)
E. Memory Manager Process (MMAN)
Correct Answer: A
二、题目翻译
查看下图并鉴别问号标志的组件。
A. Checkpoint (CKPT)
B. Process Monitor (PMON)
C. Archiver Processes (ARcn)
D. Recoverer Process (RECO)
E. Memory Manager Process (MMAN)
答案：A
三、题目解析
检查点被记录在控制文件和每个数据文件的文件头。
出现检查点的时候，DBWr会将所有修改的缓冲区内容写到数据文件中
当DBWr需要写入的数据的SCN号大于LGWR记录的SCN号，会触发LGWR写入
故可以知道问好处应为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:
- It enables the transfer of data from one database to another
- It provides a complete solution for the backup, restoration and recovery needs of the entire database
- It enables the loading of data from an external file into tables of an Oracle Database
- 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各种功能： 它使数据从一个数据库转移到另一个地方它提供了一个备份，恢复和恢复整个数据库的完整解决方案它使数据从外部文件加载到数据库的表提供了一个Oracle磁带备份管理生态系统
哪一个描述了Oracle Data Pump功能？
A.1
B.2
C.3
D. 4
E. 1 and 3
F. 1, 2, 3 and 4
答案：A
三、题目解析
1 描述的是数据泵的功能
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
二、题目翻译
你的数据库配置为共享服务模式。然而，你的高级dba要求你修改PRIVATE_SGA的值限制用户资源。原因可能是什么？
A. 限制从SGA分配给会话的UGA
B. 限制SGA中一个会话中用于调度队列的内存数量
C. 限制SGA中用于request pool的内存数量
D. 控制SGA中分配给每个共享服务进程的本地变量的内存数量
答案：A
三、题目解析
在专用服务器模式下，进程和会话是一对一的关系，UGA被包含在PGA中，
在共享服务器模式下，进程和会话是一对多的关系，UGA在大池(Large Pool)中分配。
如果分配失败，如大型池太小，或是根本没有设置大型池，则从共享池(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:
- SGA is allocated.
- Control file is read.
- Redo log files are read.
- Instance recovery is started.
- Background processes are started.
- Data files are checked for consistency.
- 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选项关闭数据库实例。考虑打开数据库需要执行的步骤： 分配SGA读取控制文件读取日志文件开始实例恢复启动后台进程检查数据文件一致性读取spfile或者pfile
哪个选项是正确的关于这些步骤？
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进行实例恢复，而shutdown immediate则不需要进行实例恢复。
一、源题
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
二、题目翻译
你的数据库启用了自动共享内存管理（ASMM）。ASMM管理的组件的初始化参数没有设置。为了观察ASMM的影响，你执行下面命令：
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
哪些语句是正确的在这个场景？
A. 数据库buffer cache的最小设置为100MB
B. 在ASMM中数据库buffer cache最大可以获得的内存是100MB
C. 数据库buffer cache在专用模式下分配给一个服务进程最小为100MB
D. 数据库buffer cache动态管理被释放的最大值设置为100MB
答案：A
三、题目解析
启用ASMM 之前，应该从 SPFILE 中删除单个内存区参数，因为设置这些参数会使
ASMM 受到限制。看到 ASMM 分配的效果之后，如果决定要调整特定组件的分配值，可以为这些组件指定值。如果指定的值比目前的值小，这些值将被视为各个组件的最小内存大小。如果指定的值比目前的值大，那么只要有空闲内存，就可以将内存组件的大小重新上调至您提供的值。执行此操作会限制可用于自动调整的内存量，但在环境需要对大小进行特殊调整、而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
二、题目翻译
检查下面初始化参数的值：
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
哪两个将被影响在你的数据库中？（选择两个）
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?
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命令的输出结果。
哪些语句是正确的关于命令的输出
A. 备份片失效因为新的备份是可用的
B. 备份片失效因为操作系统上文件找不到
C. 备份片失效因为备份保留时间失效
D. 备份片失效因为它所属的备份集不完整
答案：B
三、题目解析
CROSSCHECK BACKUP的作用是检查备份的可用性（物理上是否存在），并对失效的备份集打上expired标记
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
二、题目翻译
你的数据库实例配置UNDO自动管理并且UNDO_RETENTION参数设置为900秒。执行下面的命令启用retention guarantee：
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
这个命令在数据库中会有什么影响？
A. undo表空间中的extent会保留数据直到下次数据库完整备份
B. undo表空间中的包含已提交的undo的extent不会被覆盖在15分钟内
C. undo表空间中的包含已提交的data的extent不会被覆盖直到数据库实例关闭
D. undo表空间中包含已提交的undo的extent会被传输到Flash Recovery Area在被覆盖前
答案：B
三、题目解析
因为undo表空间是自动管理的，所以执行上面的命令后，UNDO_RETENTION变成强依赖参数，即使拒绝执行SQL DML操作，也不会发生undo数据覆盖的情况。
参考官方文档：
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
二、题目翻译
为数据库配置Flash Recovery Area。数据库实例启动于ARCHIVELOG模式并且LOG_ARCHIVE_DEST_1参数没有设置。归档和归档日志的位置会受到什么影响？
A. 归档会被禁用因为归档目的地丢失
B. 数据库实例会关闭并将错误详细记录在alert之日中
C. 归档会启用且归档日志将会设置为Flash Recovery Area
D. 归档会启用且归档日志会默认创建在$ORACLE_HOME/log
答案：C
三、题目解析
如果打开归档，并且没有指定归档路径的话，那么默认就是在闪回恢复区
一、源题
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
二、题目翻译
哪些描述是正确的关于数据库buffer cache中的pinned buffer？
A. buffe目前正在被访问
B. buffer是空的，没有被使用
C. buffer的内容被修改且必须通过DBWn进程刷新到磁盘
D. buffer作为即将老化的候选并且内容和磁盘上的内容相同
答案：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中以至于内存不会老化当一个用户会话访问的时候。多个会话不能同时修改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
二、题目翻译
在什么情况下你使用数据库静态注册监听？
A. 当多个数据库被注册使用监听
B. 当DBA需要远程启动数据库实例
C. 当用户需要连接数据库实例使用主机名方法
D. 当数据库实例被使用监听注册配置为共享服务模式
答案：B
三、题目解析
静态注册可以远程管理数据库，比如数据库的起停，而动态注册必须数据库启动才可以
动态注册为ready从字面的意思理解为准备好，而静态注册为unknow也就是不知道数据库状态
参考官方文档：
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
二、题目翻译
观察索引统计信息，你发现一个索引高度分裂，从而导致数据库性能下降。哪种方法你可以用来减少分裂不影响正在使用索引的用户？
A. 分析索引结构使用ANALYZE……INDEX命令
B. 重建索引使用ALTER INDEX…..REBUILD ONLINE命令
C. 改变块空间利用率使用ALTER INDEX命令
D. 释放未使用的空间索引使用ALTER INDEX……DEALLOCATE UNUSED命令
答案：B
三、题目解析
由于频繁的dml，索引就会产生碎片，它的效率会越来越慢，因此就需要重建，
可以使用online关键字在线重建索引，因为重建索引的时候会加锁，假如该关键字后，可以使加锁时间变的很短，从而减少对使用索引用户的影响
参考官方文档:
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?
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用户分配的角色。哪些语句是正确的关于分给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
二、题目翻译
为了使审计更生产化，DBA执行下面命令在开始审计操作之前：
SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
哪些语句是正确的关于审计记录产生当启动审计在重启数据库后？
A. 只包含用户执行的SQL语句执行计划
B. 包含用户执行的SQL文本和它使用的绑定变量
C. 包含用户执行的执行计划和统计信息相关的SQL语句
D. 包含用户执行的SQL语句执行计划和使用的绑定变量
答案：B
三、题目解析
AUDIT_TRAIL值含义如下：
DB：启用审计，信息记录在SYS.AUD$中
OS：启用审计，审计信息保存在操作系统，Oralce建议使用该配置
Db，extended：启用审计，并且记录对应的执行语句
Xml：启用审计，审计信息以xml形式保存在操作系统上
Xml，extended：启用审计，并且包括所有的执行语句
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
二、题目翻译
你想导入HR用户使用数据泵从开发数据库DEVDB到生产数据库PRODDB。一个数据库连接devdb.us.oracle.com被创建在PRODDB和DEVDB之间。你执行下面命令在PRODDB数据库服务端：
$ 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 导数据需要提供参数 network_link ，这时不会生成 dump file，所以不需要dumpfile 参数。
参考官方文档：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
二、题目翻译
哪两句是正确的关于自动数据库诊断监视器（ADDM）？（选择两个）
A. ADDM需要至少四个AWR快照用于分析
B. ADDM运行在MMON自动收集每个AWR快照之后
C. ADDM分析的结果存储在AWR
D. ADDM分析提供诊断信息不提供建议
E. ADDM调用其它advisors如果需要，但是不提供建议
答案：BC
三、题目解析
ADDM
每个awr快照被记录后，addm就会自动运行，分析与最后两个快照对应的时段中的数据，addm会主动监视实例
多数情况下，addm会为检测到的问题提供解决方案，addm可以检测到一些常见问题如下
- cpu瓶颈
- oracle net 连接管理问题
- 锁的竞争
- IO问题
- 一些数据库实例内存结构的大小不足
- 过载的sql语句
- plsql和java运行时间过长
- 检查点负载过高及原因(如日志文件过小)
因此：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
二、题目翻译
哪些任务需要执行在你运行Oracle Universal Installer（OUI）在静默模式或suppressed模式安装之前？
A. 运行root.sh脚本
B. 创建oraInst.loc文件
C. 创建tnsname.ora文件
D. 运行oraInstRoot.sh脚本
答案：B
三、题目解析
oraInst.loc是定义inventory路径的，必须咋运行OUI之前创建
root.sh和oraintRoot.sh都是安装的时候执行的
tnsnames.ora是配置网络连接远程的
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:
- Shut down the instance.
- Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
- Execute the ALTER DATABASE FLASHBACK OFF command.
- Start up the instance and mount the database.
- Execute the ALTER DATABASE FLASHBACK ON command.
- 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启动的数据库实例工作。你想移动Flash Recovery Area到一个新的位置。你想Flashback 日志存储在新的位置。下面是完成这项任务的随机排序步骤：
1） 关闭实例
2） 改变参数DB_RECOVERY_FILE_DEST的值为新的值
3） 执行ALTER DATABASE FLASHBACK OFF命令
4） 启动数据库实例并mount数据库
5） 执行ALTER DATABASE FLASHBACK ON命令
6） 打开数据库
选择正确的执行顺序
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
二、题目翻译
你处于一个正在更新一个非常重要的表的事务中。数据库正在运行的机器因为断电重启。这导致数据库实例故障。哪些语句是正确的在这种情况？
A. 完成恢复需要联机重做日志和归档日志
B. 下一次数据库实例启动的时候会提交未提交的事务
C. 下一次数据库打开会自动回滚未提交的事务
D. DBA执行数据库恢复去恢复未提交的事务
答案：C
三、题目解析
完成恢复只需要联机重做日志，不需要归档日志，所以A错
下一次启动实例的时候会将位提交的事务回滚而不是提交，B错，C对
实例恢复由SMON自动执行，而不是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;
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
二、题目翻译
查看下图检查存储过程输出结果，自从数据库实例启动并经历不同的工作负载在三个不同的时间：
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0;
你能推断出什么？
A. 数据库实例正在运行，使用手动管理PGA
B. 数据库实例正在运行，使用手动管理共享内存
C. 数据库实例设置MEMORY_TARGET为非0值
D. 所有的会话连接数据库实例为专用模式，没有RMAN或者并行查询操作执行
答案：C
三、题目解析
动态性能视图V$MEMORY_DYNAMIC_COMPONENTS显示所有动态优化的内存组件的当前大小，其中包括SGA 和实例PGA 的总大小。三次启动的SGA的各个组件大小都一样，是动态变化的，PGA也是动态变化的，所以此数据库是处于自动内存管理即AMM，也即是说MEMORY_TARGET设定为非零值
一、源题
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
二、题目翻译
你的数据库实例启动使用SPFILE。你执行一个命令改变LOG_BUFFER的值：
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
这个命令的输出结果是什么？
A. 命令执行成功只有自动内存管理没有启用的时候
B. 命令执行成功，但是你需要重启数据库来生效
C. 命令返回一个错误因为redo log buffer不能动态修改
D. 参数值被修改并且会立即生效只要SGA中有可用的空间
答案：C
三、题目解析
LOG_BUFFER为静态参数，故只能使用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:
- Shut down the instance, if not already done.
- Copy one of the remaining control files to a new location.
- Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
- Start up the database instance to the NOMOUNT stage.
- Recover the database to the point of failure of the control file.
- 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
二、题目翻译
数据库实例正在使用SPFILE。查看下表并检查运行DB结构完整性检查时发生的错误。下面给出随机步骤恢复错误： 关闭实例，如果尚未完成拷贝一个冗余控制文件到新的位置改变CONTROL_FILES初始参数的值和新位置一致启动数据库实例到NOMOUNT阶段恢复数据库到控制文件的故障点打开数据库
鉴别正确的步骤顺序？
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恢复控制文件
参考官方文档：
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:
- Configure the database to operate in shared server mode.
- Disable automatic maintenance tasks such as optimizer statistics collection.
- Configure a naming method to help the remote user connect to the database instance.
- Use Automatic Storage Management (ASM) for storing the database files.
- Configure daily database backup to flash recovery area.
- 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数据库工作，只安装了软件没有创建数据库。你计划使用DBCA创建一个数据库在这个服务器上。
一些数据库创建需要的设置任务是： 配置数据库为共享服务器模式禁用自动维护任务例如优化器统计信息收集配置一个命名方法帮助远程用户连接数据库实例使用自动储存管理（ASM）存储数据文件配置日常数据库备份到FRA配置企业管理控制台管理数据库
哪些要求可以被满足当创建数据库的时候？
A. 4 和 6
B. 2, 3, 4, 和 6
C. 1, 2, 4, 5, 和 6
D. 1, 2, 3, 4, 5, 和 6
答案：C
三、题目解析
DBCA创建数据库如下：
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 选择监听器
8.Database Configuration Assistant,Step 7 of 13:Database File Locations 选择ASM
9.Database Configuration Assistant,Step 8 of 13:Recovery Configuration快速恢复区指定
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
哪两句关于索引的描述是正确的？（选择两个）
A. 它被查询优化器忽略
B. 它不用被使用当重建的时候
C. 索引不能被rebuilt必须重新create
D. 索引会自动rebuilt当下次使用的时候
答案：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.
当你创建一个索引为UNUSABLE状态，它会被查询优化器忽略并且不会被DML维护。一个UNUSABLE索引必须被rebuilt或删除后create，在它被使用之前。如果索引被分区，所有的分区索引会被标记为UNUSABLE。
在Oracle 数据库11g Release 2，当数据库创建一个unusable 索引的时候，不会创建索引段。
参考官方文档：
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
二、题目翻译
在一个大型联机事务处理（OLTP）系统在白天需要巨大的数据库buffer cache。在晚上，系统支持批量任务需要设置large pool为很大的值。你必须配置内存组件同时适应峰值要求。
你会怎么做来自动化配置内存组件适用模式变化的工作？
A. 设置SGA_TARGET初始值为0
B. 设置PRE_PAGE_SGA初始值为TRUE
C. 设置MEMORY_MAX_TARGET初始值为0
D. 设置SGA_TARGET初始值为非0值
答案：D
三、题目解析
因为白天需要大的BUFFER CACHE，晚上需要大的LARGE POOL，所以可以启动ASMM管理。
启动ASMM，需要：
1.除了sga_target,sga_max_size,lock_sga,pre_page_sga需要静态调整外，其他都可以动态调整
2.启用方法是需要将sga_target 设置为非0，同时将statistics_level设置为typical或者all
3.如果使用了自动共享内存管理，下面这些缓存区就不需要在进行设置了,他们会自动设置为0
i.db_cache_size
ii.shared_pool_size
iii.large_pool_size
iv.java_pool_size
v.streams_pool
4.尽管使用了assm，还是可以设置缓存区大小的，设置后表示的是该缓存区的下限值，即oracle任何时候该缓存区都应该不小于这个值，至少预留这么大的空间
一、源题
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
二、题目翻译
你执行下面命令去改变数据库buffer cache的值：
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;
System altered.
为了验证大小的修改，执行下面命令：
SQL> SHOW PARAMETER DB_CACHE_SIZE
NAME TYPE VALUE
-------------- ------------ ------------
db_cache_size big integer 4194304
为什么值设置为4194304,而不是2516582?
A. 因为4194304是粒度大小
B. 因为4194304是标准块大小
C. 因为4194304是数据库定义中最大的非标准块大小
D. 因为4194304是数据库buffer cache已使用的数据总大小
答案：A
`三、题目解析
如果指定的大小不是粒度的整倍数，则约等于到整倍数，例如粒度为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
二、题目翻译
确定数据块块头增长的两种情况（选择两个）
A. 当行目录需要更多的行信息
B. 当数据块中发生行迁移
C. 当数据块中的PCTFREE的值增加
D. 当更多的事务槽需要比最初设置
答案：AD
三、题目解析
块头：块头包含段类型（如表或索引）、数据块地址、表目录、行目录和事务处理插槽。每个插槽的大小约为23 字节，修改块中的行时会使用这些插槽。块头自上而下进行增长。
• 行数据：这是块中行的实际数据。行数据空间自下而上进行增长。
• 空闲空间：空闲空间位于块的中部，允许头和行数据空间在必要时进行增长。当插入新行或用更大的值更新现有行的列时，行数据会占用空闲空间。
参考官方文档：
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 数据库 11g在你的服务器上。在安装期间，Oracle Universal Installer（OUI）提示你输入产品目录路径并提示你指定一个操作系统组名。哪些语句是正确的在这种情况下？
A. ORACLE_BASE参数没设置
B. 使用root用户执行安装
C. 被指定的操作系统组应该有root用户作为成员
D. 没有使用选项"Create Starter Database"执行安装
E. 被指定的操作系统组必须有权限写产品目录
答案：E
