Oracle OCP 1Z0-050（181-183题）解析

Oracle OCP 1Z0-050（181-183题）解析

QUESTION 181:

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:

SQL> @utlrp.sql

What is the significance of executing this script?

A. It performs sequential recompilation of any stored PL/SQL as well as Java code.

B. It performs parallel recompilation of any stored PL/SQL as well as Java code.

C. It performs sequential recompilation of only the stored PL/SQL code.

D. It performs parallel recompilation of only the stored PL/SQL code.

Answer: B

解析：参考Oracle官方文档

https://docs.oracle.com/cd/E11882_01/server.112/e23633/intro.htm#UPGRD12472

 

QUESTION 182:

View the Exhibit.

Examine the following command that is executed for the TRANSPORT table in the SH schema:

SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe',

'(country_id, cust_state_province)') FROM dual;

Which statement describes the significance of this command?

A. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.

B. It collects statistics into the pending area in the data dictionary.

C. It creates a histogram to hold skewed information about the data in the columns.

D. It creates a virtual hidden column in the CUSTOMERS_OBE table.

Answer: D

解析：参考Oracle官方文档

https://docs.oracle.com/cd/E11882_01/server.112/e41573/stats.htm#PFGRF95153

 

QUESTION 183:

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

A. The audit trail is stored in an operating system file.

B. Auditing is disabled for all privileges.

C. The audit trail is stored in the database.

D. Auditing is enabled for all privileges.

E. Auditing is enabled for certain privileges related to database security.

Answer: C,E

解析：

如果数据库是使用Database Configuration Assistant (DBCA) 创建的，默认情况下，audit_trail参数设置为DB。

当AUDIT_TRAIL设置为DB时，默认的行为是将审计线索记录到数据库的AUD$表中。

默认审计

在Oracle Database 11g中启用审计时，将默认审计那些对安全性非常重要的特定权限和语句。系统将针对所有用户，按成功、失败以及访问来审计上面列出的这些权限和语句。

（完）