20151204 ocp模拟机测试成果

117.view the exhibit and examine the initialization parameter setting

which three initliazation parameters are to be set manually as they are not 

automatically tuned?

a.log_buffer

e.DB_16K_CHACHE_SIZE

f.DB_KEEP_CHACHE_SIZE

其实就是Log_buffer和data_bufferr_chech

157.exaimne the commands executed in the following sequence

1: SQL> CREATE ROLE mgrrole;

2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;

3: SQL> GRANT select,update ON sh.sales TO mgrrole;

4: SQL> CREATE ROLE ceo IDENTIFIED BY boss;

5: SQL> GRANT mgrrole,drop any table,create any directory TO ceo;

6: SQL> GRANT ceo TO mgrrole;

Which statement is true about the above commands?

b.commands 6 produces an error becaruse of circular role grant

角色循环赋值了

19.which statement is true about as whole consitent database backup on a database running in archivelog

注意这里是完整一致性备份，所以必须保证数据库再关闭状态下

141.which tablespaces are mandatory in an oracle database for it to be operational?

强制的

system和sysaux表空间实在创建数据库时创建的必须存在的表空间。这些表空间必须联机

system表空间用于核心功能（例如数据字典表）

辅助的sysaux表空间用于附加的数据库组件(如oracle enterprise manager repository)

不建议使用system和sysaux来存储应用程序的数据

22.identify the logical structure that will have moren than one data segment created fot it

d.nonclustered table

只要记住非簇表只能使用一个段就可以了

181.view the exhibit and examine the pl/sql package and procedure

you made changes to the compute_tax function inside the emp_admin package body,which statement is treu

after you recompile the emp_admin package body?

a.the user_p procedure remains valid

程序包体和程序说明是分开的。因此，可以更改并重新编译程序包体代码，此时不会讲

与程序包说明相关的其他对象标记为无效

92.you executed the following commands in an RMAN session for your database instance that has failures:

RMAN>LIST FAILURE;

after some time,you executed the following command in the same session

RMAN>ADVISE FIALURE

but there are new failures recorded in the automatic diagonositc in the ADR after execiution of 

the last list failure command.which statement is true for the above advise fialure command 

in this scenario?

a.it produces a warning for new failures before advising for critical and high failures
87.you are managing an oracle database 11g database running in archivelog mode.

the flash recovery area is specified as the destination for the archived redo log files.

you notice this warning in the alert log file

ORA-19815:WARINGING:DB_RECOVERY_FILE_DEST size of 3221225572 butes is 100% anbd has 0

remaning bytes available

what would you do to recalim the used space in the flash recovery area

a.back up the flash recovrry

b.recrease the retention time fot the database backup and falshback log files

关键词是backup

137.your database instance is currently configured to support 1500 connections.the web application 

that uses the database allows a large number of users to work with the database simulaneously some

users of the web application do not interact with the server all the time

you want to increase the scalability by configureing the database instance to handle more connections as a dba

which configuration would you set to support moren than 1500 connections

b.you would configure the database inshared seever mode to use the conection pooling feature

共享服务器链接是一种在程序编写时通常会用到的连接池的概念

答案解析：

共享服务器连接是一种在程序编写的时候通常会用到的连接池(pool)的概念。采用这种模式的话，在数据库的初始化的时候就会创建一批服务器连接的进程，然后把这些连接进程放入一个连接池来进行管理。初始化的池中的进程数量在数据库初始化建立的时候是可以手动设置的。在连接建立的时候，Listener首先接受到客户端的建立连接的请求，然后Listener去生成一个叫做调度器(dipatcher)的进程与客户端进行连接。调度器把把客户端的请求放在SGA(系统全局域)的一个请求队列中，然后再共享服务器连接池中查找有无空闲的连接，然后让这个空闲的服务器进行处理。处理完毕以后再把处理结果放在SGA的相应队列中。调度器通过查询相应队列，得到返回结果，再返回给客户端。这种连接模式的优点在于服务器进程的数量可以得到控制，不大可能出现因为连接人数过多而造成服务器内存崩溃。但是由于增加了复杂度以及请求相应队列，可能性能上有所下降。

143.you execute a command to resize a data file,sales.dbf of size 200mb in your database:

alter database datafile '/remote/sales.dbf'resize 150m

which statement is true about this command?

d.the command succeeds if no extent in the tablespace is currently allocated above 150mb boundary of the file

在数据库read write即Open状态下，非归档模式下noarchivelog,数据文件lxtb.dbf online下，尝试改变它的大小

指定resize来使数据库增加或减少指定的绝对大小的数据文件，没有默认值，所有必须指定一个size

如果没有足够的空间来增加size或者原有的文件大小已经超过要减少的size，则数据库会报错

188.you receive complaints from users regarding the high waiting time for theire transations.

on investigation.you find that some users are not committing their transation though they are not performing any activity for a long time 

as a result .sql statements need to wait for row-level locks

which two sctions could you take to prevent this locking problem in the future?

a.decrease the idle_time resourse limit in the profile assigned to the blocking users

b.user database resorce manager to automatically log out sessions that block others and are idle

a.对于阻塞用户减少idle_time的资源限制 ，通过数据库资源管理器提供的空闲时间限制，来制定哪些阻塞用户的坏话的空间时间，产国改时间后将终止会话

b.使用数据库资源管理器自动退出阻塞别人活着用户限制的会话

115。which of these true aout undo tablespace?

a.undo tablespace is a temporary tablespace

道理不知道，选这个就是了

129. A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

SQL> connect smith/smith

Connected.

SQL> SELECT * FROM v$session;

SELECT * FROM v$session

*

ERROR at line 1:

ORA-00942: table or view does not exist

Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)

A.granting SELECT privilege to SMITH on V$SESSION

B.granting SELECT privilege to SMITH on V_$SESSION

C.asking the user SMITH to run the catalog.sql script

D.granting SELECT privilege to SMITH on V$FIXED_TABLES

E.setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

F.creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was

created

Answer: BF  

答案解析：

The V$SESSION data dictionary view also contains session information from the SYS.V_$SESSION system table for the current session

从题中错误看出，SMITH 用户没有访问数据字典v$session的权限，两种解决方法，一是给他访问v$session的权限，二是在v$session建立视图，并授权让SMITH 可以查看
实验第一种方法如下：