26、View the Exhibit to examine the details for an incident.
Which statement is true regarding the status of the incident? A. The DBA is working on the incident and prefers that the incident be kept in the ADR B. The incident is now in the Done state and the ADR can select the incident to be purged C. The incident has been newly created and is in the process of collecting diagnostic information D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support Answer: D
调用意外事件打包服务，该服务可以对收集到的有关某个问题的所有诊断数据进行打包，可以选择将这些数据上载到Oracle 技术支持
27、
27.What can you achieve by implementing reverse key index? A. Reverse the bytes of each column indexed including the row ID B. Store a bitmap for each key value instead of a list of row IDs in the leaf node C. Prevent contention on the highest leaf block when using sequences to generate keys D. Remove repeated key values from the index to fit more index entries in a given amount of disk space Answer: C
Reversing the key solves the problem of contention for leaf blocks in the right side of a B-tree index
28、
28.What is the effect of this command? SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT Answer: C
审计
默认情况下，审计设置为BY ACCESS
BY SESSION子句将这些记录组成一组，以便每个会话只生成一条记录
29、
29.You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error? A. The MTTR Advisor is disabled. B. The database is in NOARCHIVELOG mode. C. The tablespace is already in backup mode. D. The Flash Recovery Area is not configured. Answer: B
热备份、归档模式
30、
30.Which statements listed below describe the data dictionary views? 1. These are stored in the SYSTEM tablespace 2. These are the based on the virtual tables 3. These are owned by the SYS user 4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE 5. The V$FIXED_TABLE view can be queried to list the names of these views A. 1 and 3 B. 2,3 and 5 C. 1,2, and 5 D. 2,3,4 and 5 Answer: A
他们都被存在system表空间以及owned是sys用户
用数据字典保护使用 O7_DICTIONARY_ACCESSIBILTY参数设置为false，则阻止普通用户访问数据字典
