摘要：
SQL˃AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;A.OneauditrecordiscreatedforeverysuccessfulDROPTABLEcommandexecutedinthesessionofSCOTTB.OneauditrecordisgeneratedforthesessionwhenSCOTTgrantstheDROPANYTABLEprivilegetootherusersC.OneauditrecordiscreatedforthewholesessionifuserSCOTTsuccessfullydropsoneormoretablesinhissessionD.OneauditrecordiscreatedforeverysessionofanyotheruserinwhichatableownedbySCOTTisdroppedsuccessfullyE.OneauditrecordiscreatedforeverysuccessfulDROPTABLEcommandexecutedbyanyusertodroptablesownedbySCOTTAnswer:C审计默认情况下，审计设置为BYACCESSBYSESSION子句将这些记录组成一组，以便每个会话只生成一条记录29、29.YouexecutedthefollowingcommandtoperformabackupoftheUSERStablespace:SQL˃ALTERTABLESPACEusersBEGINBACKUP;ALTERTABLESPACEusersBEGINBACKUP*ERRORatline1:ORA-01123:cannotstartonlinebackup;mediarecoverynotenabledWhatcouldbethereasonforthiserror?
26、View the Exhibit to examine the details for an incident.
Which statement is true regarding the status ofthe incident? A. The DBA is working on the incident and prefers that the incident be kept inthe ADR B. The incident is now in the Done state and the ADR can select the incident tobe purged C. The incident has been newly created and is in the process ofcollecting diagnostic information D. The data collection for the incident is complete and the incident can be packaged and sent toOracle Support Answer: D
调用意外事件打包服务，该服务可以对收集到的有关某个问题的所有诊断数据进行打包，可以选择将这些数据上载到Oracle 技术支持
27、
27.What can you achieve by implementing reverse key index? A. Reverse the bytes of each columnindexed including the row ID B. Store a bitmap for each key value instead of a list of row IDs inthe leaf node C. Prevent contention on the highest leaf block when using sequences togenerate keys D. Remove repeated key values from the index to fit more index entries in a given amount of disk spaceAnswer: 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 ofthis command? SQL> AUDIT DROP ANY TABLE BY scott BYSESSION WHENEVER SUCCESSFUL; A. One audit record is created for every successful DROP TABLE command executed in the session ofSCOTT B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session D. One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned bySCOTT Answer: C
审计
默认情况下，审计设置为BY ACCESS
BY SESSION子句将这些记录组成一组，以便每个会话只生成一条记录
29、
29.You executed the following command to perform a backup ofthe 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 notenabled What could be the reason forthis error? A. The MTTR Advisor isdisabled. B. The database is inNOARCHIVELOG mode. C. The tablespace is already in backupmode. D. The Flash Recovery Area is notconfigured. Answer: B
热备份、归档模式
30、
30.Which statements listed below describe the data dictionary views? 1. These are stored inthe SYSTEM tablespace 2. These are the based onthe 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 toTRUE 5. The V$FIXED_TABLE view can be queried to list the names ofthese views A. 1 and 3B. 2,3 and 5C. 1,2, and 5D. 2,3,4 and 5Answer: A
他们都被存在system表空间以及owned是sys用户
用数据字典保护使用 O7_DICTIONARY_ACCESSIBILTY参数设置为false，则阻止普通用户访问数据字典