need-to-insert-img
need-to-insert-img
1z0-052ExamPass
need-to-insert-img
⺫录
⼀一. DML5
⼆二. DDL7
四. PL/SQL9
五. AWR11
六. PROCESS13
⼋八. CHECKPOINT17
⼗十⼀一.ARCHIVELOG20
⼗十⼆二.DATA PUMP21
⼗十三.AUDIT23
⼗十四.DBLINK26
⼗十五.EXTERNAL TABLE27
⼗十七.ADDM29
⼗十⼋八.FRA30
⼗十九.PRIVILEGES31
⼆二⼗十.UNDO38
⼆二⼗十.INITIALIZATION PARAMETER44
⼆二⼗十⼀一.BACKUP45
⼆二⼗十⼆二.RECOVER48
need-to-insert-img
⼆二⼗十三.TABLESPACE49
⼆二⼗十四.PROFILES53
⼆二⼗十五.ALERT LOG54
⼆二⼗十六.FAST_START_MTTR_TARGET55
⼆二⼗十七.INSTALL56
⼆二⼗十⼋八.SERVER-GENERATED58
⼆二⼗十九.DBCA59
三⼗十.DISPATCHER60
三⼗十⼀一.ADVISOR62
三⼗十⼆二.SECURITY64
三⼗十三.LOCK65
三⼗十四.MEMORY66
三⼗十五.INDEX68
三⼗十七.ROLES69
三⼗十⼋八.DYNAMIC PERFORMANCE VIEWS AND DATA DICTIONARY VIEWS71
三⼗十九.SHUTDOWN73
四⼗十.RMAN74
四⼗十⼀一.DATA RECOVERY ADVISOR79
四⼗十⼆二.EM82
四⼗十四.STARTUP DATABASE85
四⼗十六.PATCH88
need-to-insert-img
四⼗十七.TRACE89
四⼗十⼋八.SHRINK90
四⼗十九.CONSTRAINT91
need-to-insert-img
⼀一.DML
1. USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:
SQL> UPDATE dept SET loc='UK' where dno=1;
1 row updated.
SQL> UPDATE emp SET sal=1000 where eno=100;
1 row updated.
SQL>ALTER TABLE dept DROP(dno)
这题看晕了
What will be the outcome and why?
A) It will fail because a referential integrity constraint is defined on USER1.EMP.
B) It will execute successfully and drop DEPNT.DNO.
C) It will fail because there is an uncommitted transaction on USER1.DEPT.
D) It will execute successfully and drop the DEPT.DNO and EMP.DNO columns.
E) It will fail because there is an uncommitted transaction on USER1.EMP
Answer：A
2. Examine these commands and their output:
SQL> SELECT * FROM emp ENOENAME
----------
100 Adam
101 Alan
SQL> INSERT INTO emp VALUES(102,'Ben');
1 row created.
SQL>COMMIT;
Commit completed.
SQL>UPDATE emp SET ename='Bryan' WHERE eno=102;
1 row updated.
A power failure occurs. The instance is restarted and this query is executed.
SQL>SELECT ename FROM emp;
What is the outcome?
A) Only Adam and Alan are displayed.
need-to-insert-img
B) No rows are returned.
C) Only Adam, Alan, and Bryan are displayed.
D) Adam, Alan, Ben, and Bryan are displayed.
E) Only Adam, Alan, and Ben are displayed.
Answer：E
这题没问题
3. Each row in the TRANS_SUMMARY table contains details of one product.
Each row in the TRANS_MONTHLY table contains transaction details either for new products or for updates to existing products.
There is a monthly requirement to:
1. Insert TRANS_MONTHLY rows for new products to the TRANS_SUMMARY table
2. Update the TRANS_SUMMARY table when a TRANS_MONTHLY row refers to an existing product. Which two can be used to do this?
A) INSERT INTO .. SELECT FROM ..
B) a called procedure.
C) an Oracle loader type external table.
D) the MERGE command.
E) CREATE TABLE AS SELECT (CTAS)
Answer：BD
这题答案应该没问题，背诵一下。
need-to-insert-img
⼆二.DDL
4. Which four statements are true about truncating a table?
A) Any insert triggers for the table will be executed.
B) Any of the table’s indexes are also truncated.
C) Any delete triggers for the table will be executed.
D) All table storage can be retained.
E) Only HEAP tables may be truncated.
F) All table storage is converted to free space.
G) MINEXTENTS amount of storage for the table can be retained.
Answer：BCFG
这题答案背诵一下
TRUNCATE TABLE：删除内容、释放空间但不删除定义。DELETE TABLE:删除内容不删除定义，不释放空间。DROP TABLE：删除内容和定义，释放空间
need-to-insert-img
5. Examine these attributes for the profile assigned to USER1 whose password is oracle_4U.
• PASSWORD_REUSE_MAX is 5.
• PASSWORD_REUSE_TIME is 10.
• PASSWORD_GRACE_TIME is 15.
Which two conditions must be met for USER1 to reuse oracle_4U?
A) At least 5 days must have passed since oracle_4U was last used.
B) The password must have changed 5 times since oracle_4U was last used.
C) At least 10 days must have passed since oracle_4U was last used.
D) The password must have changed 10 times since oracle_4U was last used.
E) At least 15 days must have passed since oracle_4U was last used.
Answer：BC
password_reuse_time指定了密码不能重用前的天数
password_reuse_max则指定了当前密码被重用之前密码改变的次数
如果密码过期了并且PASSWORD_GRACE_TIME设置为10天, 那么在10天在之内如果不变更密码账号就会被锁定
背诵一下
6. Examine these attributes for the profile assigned to USER1 whose password is oracle_4U
• PASSWORD_REUSE_MAX is 5
• PASSWORD_REUSE_TIME is 10
• PASSWORD_GRACE_TIME is 15
Which two are true?
A) The USER1 password must not have been used for at least 10 days before oracle_4U can be reused as the password
B) The USER1 account will be locked if the password is changed more then 5 times in 10 days
C) The USER1 password must be changed 5 times before oracle_4U can be reused as the password
D) The USER1 account will be locked if the password is not changed at least 5 times in 15 days
E) The USER1 password must not have been used for at least 25 days before oracle_4U can be reused as the password
Answer：AC
need-to-insert-img
四.PL/SQL
7. Which is true about invalid PL/SQL objects?
A) They are automatically recompiled against the new definition of a referenced object when they are called.
B) They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.
C) They are automatically recompiled against the new definition of a referenced object at the same time as the referenced object is modified.
D) They can be manually recompiled only by using SQL commands.
Answer：A
8. Which two are true about PL/SQL objects?
A) They must be in an invalid state to be recompiled.
B) They can never be manually recompiled.
C) They can be manually recompiled.
D) They must be manually recompiled.
E) They can be automatically recompiled.
Answer：CE
need-to-insert-img
9. Which three are true about Optimizer Statistics?
A) They can be gathered manually
B) They are automatically updated by DML statements
C) They contain the execution plan for each executed SQL statement.
D) They include the number of rows in a table and the number of distinct values per column.
E) They can be gathered automatically by an automatic maintenance job.
Answer: ADE
10. Which two are true about Oracle's Optimizer statistics?
A) They are automatically updated when ddl statements execute.
B) They can be calculated exactly.
C) They can be gathered on external tables.
D) They are automatically updated when dml statements execute.
E) They can be estimated.
Answer: BE
http://blog.itpub.net/26015009/viewspace-1068582/
11. Which two are true about Optimizer Statistics?
A) They are gathered by the Manageability Monitor(MMON) background process.
B) They can be gathered by executing the PL/SQL procedures in the DBMS_STATES package.
C) They do not persist across instance restarts.
D) They can be used to determine the events on which a database instance waited.
E) They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements.
F) They are automatically updated when DDL statements execute.
Answer：BE
need-to-insert-img
五.AWR
12. Which three are true about the Automatic Workload Repository (AWR)?
A) AWR data is stored in the SYSAUX tablespace.
B) Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.
C) It includes statistics that contain the number of distinct values per table column.
D) By default, AWR data is retained for eight days.
E) it is maintained by executing the pl/sql procedures in the dbms_stats package.
F) It includes statistics that contain the number of rows per table.
Answer：ABD
13. Which three are true about the Automatic Workload Repository (AWR)?
A) AWR data is stored in the SYSTEM tablespace.
B) By default, AWR snapshots are taken every 60 minutes.
C) It is the foundation for the self-managing infrastructure.
D) The taking of AWR snapshots cannot be disabled.
E) Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
Answer：BCE
14. Which three are true about the Automatic Workload Repository (AWR)?
A) AWR data is stored in the SYSTEM tablespace.
B) By default, AWR snapshots are taken every 60 minutes.
C) It is the foundation for the self-managing infrastructure.
D) The taking of AWR snapshots cannot be disabled.
E) Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
F) It is used by the Optimizer to determine optimal execution plans.
Answer: BCE
15. Which two are true about AWR snapshots?
A) They are stored in the SYSAUX tablespace.
B) They are always created automatically.
C) They can be retained forever.
D) They can be modified by using DMLs.
E) They are not generated if STATISTICS_LEVEL is set to TYPICAL.
need-to-insert-img
Answer：AC
16. Which three are true about AWR snapshots?
A) They are always created automatically.
B) They are always created manually.
C) They are generated If statistics—level is set to basic.
D) They are generated If statistics—level is set to typical.
E) They are always retained forever.
F) They can be retained forever.
G) They are generated if statistics⼀一level Is set to all.
Answer: DFG
17. Which four are true about the Automatic Workload Repository (AWR)?
A) AWR data can be retained for a month.
B) It includes statistics on the number of columns in each view.
C) Automatic AWR snapshots can be written once per hour.
D) It includes statistics on the number of columns in each table.
E) Automatic AWR snapshots can be written once every 6 hours
F) AWR data can be retained for 3 months.
Answer: ACEF
need-to-insert-img
六.Process
18. Which two events always request the LGWR to write?
A) When DBWn writes dirty buffers.
B) When a log switch occurs.
C) When a checkpoint occurs.
D) When LGWR is notified by a server process that performs a COMMIT or ROLLBACK.
E) When PMON restarts a serve process.
Answer：AB
19. Which three events always result in a write request made to the LGWR process?
A) after undo is applied by PMON during process recovery
B) when dirty buffers are found during the processing of a checkpoint
C) when the password file is updated
D) when an Instance Is shutdown
E) when flashback logs are updated
Answer：ABD
20. Which two are true about LGWR?
A) LGWR always writes to the redo logs each time a COMMIT occurs.
B) LGWR always writes to the redo logs each time a ROLLBACK occurs.
C) LGWR never writes a single COMMIT to the redo logs.
D) LGWR may write to the redo logs when DBWR writes a dirty buffer.
E) Multiple COMMITs can be written by LGWR in the same write request.
F) LGWR always writes to the redo logs when DBWR writes a dirty buffer.
Answer：AF
21. Which two are true about the Archive (ARCn) processes?
A) They archive redo directly from the redo log buffer.
B) They are used during instance recovery.
C) They automatically delete obsolete archive logs to make space for new archive logs.
D) They are enabled only when the database is in ARCHIVELOG mode.
E) They create archivelogs after every log switch.
Answer：DE
need-to-insert-img
18. Which four are true about the Archive (ARCn) processes?
A) They might be used during instance recovery.
B) They can create archivelogs.
C) They are always used during instance recovery.
D) They archive redo from an active redo log.
E) They are always used during media recovery.
F) They can ship redo automatically to standby databases
G) They might be used during media recovery.
Answer：BDFG
need-to-insert-img
19. Which three structures can span multiple data files？
A) migrated rows
B) table extents
C) temporary segment extents
D) index extents
E) chained rows
F) segments
Answer：AEF
20. Which structure can span multiple data files?
A) a bigfile tablespace
B) a permanent tablespace
C) a segment
D) a temporary tablespace
E) an extent
Answer：C
21. Which four database objects never have any segments？
A) A partitioned index
B) A view selecting from a populated table
C) An empty index
D) An Oracle Loader type external table
E) An empty table
F) A view selecting from an empty table
G) An Oracle Data Pump type external table
Answer：BDFG
背诵一下啊，view和extenral table不会有段
22. Which three of these must be accessible to keep a database open?
A) Control file.
B) All members of a redo log group.
C) SYSTEM tablespace.
D) SYSAUX tablespace.
E) spfile
need-to-insert-img
Answer：ABC
23. Which two of these must be available READ/WRITE to keep a database open?
A) all copies of the control file.
B) the password file.
C) all members of the current redo log group.
D) spfile.
E) TEMP tablespace
F) SYSAUX tablespace
Answer：AC
24. Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/ db01’.The parameters, DB_CREATE_ONLINE_LOG_DESN_n and DB_RECOVERY_FILE_DEST, and not specified.
Which four are stored in the location specified by DB_CREATE_FILE_DEST?
A) audit logs
B) control files
C) redo logs
D) audit files
E) data files
F) archived redo logs
G) temp files
H) RMAN backups
这题背诵一下吧
https://blog.csdn.net/swordmanwk/article/details/6232445
Answer：BCEG
need-to-insert-img
⼋八.Checkpoint
25. When does an incremental checkpoint occur ?
A) when an online redo log switch occurs.
B) when DBWn writes dirty buffers as part of its normal processing.
C) when the ALTER SYSTEM CHECKPOINT statement is executed.
D) when a user tablespace is tabken offline.
Answer：A
need-to-insert-img
24. Which two are true about the Inventory directory?
A) It is shared by all Oracle software installations on a single server.
B) It is required only for Oracle Grid Infrastructure and Oracle Database software Installations.
C) It can be created only if the ORACLE_BASE environment variable is set.
D) It should be created before installing Oracle software for the first time on a server.
E) It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server.
Answer：AD
need-to-insert-img
25. which four are true about the tools used to administer Oracle database?
A) the Data Pump utility can be used to load data from text files.
B) SRVCTL can be used to shut down Oracle instances.
C) SQL* Plus can be used to create databases.
D) SQL*Plus can be used to startup Oracle instances.
E) DBCA can be used to upgrade databases.
F) RMAN can be used to startup Oracle instances.
Answer：BCDF
dbca是下面这个玩意：
need-to-insert-img
need-to-insert-img
need-to-insert-img
⼗十⼀一.Archivelog
26. Which state must a database be to enable ARCHIVELOG ?
A) NOMOUNT
B) OPEN IN READ WRITE mode
C) OPEN IN READ ONLY mode
D) OPEN IN RESTRICTED mode
E) MOUNT
Answer: E
这题没问题，终于有一题会的了。
need-to-insert-img
⼗十⼆二.Data Pump
27. Which two can be exported by a non-administrative account by using Data Pump?
A) directory objects
B) tables
C) tablespaces
D) schemas
E) database
Answer：BD
28. Where is an expdp operation tracked?
A) dump files
B) control file
C) log files
D) Automatic Diagnostic Repository(ADR)
E) master table (MT)
Answer：E
Master table是一个临时table专门为import pump和export pump创建的。
一旦完成就会自动被drop。
29. Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?
A) If the directory used in the export operation has existing dump files, it overwrites them.
B) It allows encryption to be performed without using a password.
C) It supports the export of specific views as tables.
D) It allows compression levels to be defined for the export.
E) It supports the renaming of tables during import.
Answer：AE
11g expdp工具支持压缩和加密功能，但是加密的时候需要用到密码。压缩的方式分别是ALL, DATA_ONLY, METADATA_ONLY, DEFAULT 或NONE。默认是会采
用DEFAULT的压缩方式采用METADATA_ONLY级别压缩。加密的级别是ALL,
DATA_ONLY, METADATA_ONLY, ENCRYPTED_COLUMNS_ONLY 或 NONE。设置参
数REUSE_DUMPFILES覆盖目标转储文件 ( 如果文件存在) ( N) 。
30. Which two statements are true regarding the Oracle Data Pump export and import operations?（choose two）
A) You cannot export data from a remote database.
B) You can rename tables during an import operation.
C) You can overwrite existing dump files during an export operation.
D) You can compress the data during export but not the metadata because it is not supported.
need-to-insert-img
31. Examine these facts about objects in the SYSTEM schema: 1.EMP is a table.
2.EMP_PK is a primary key constraint on EMP.ENO. 3.EMP_IDX is an index on EMP.MGR_NO.
4.EMP_SEQ is a sequence used to generate values for EMP.ENO. 5.EMP_OPS_PKG is a package that performs DML operations on EMP. 6.EMP_VU is a view on EMP.
7. EMP_TRG is a trigger on EMP. Examine this command:
$ expdp system/oracle \
> FULL =Y \
> EXCLUDE=TABTLE:"= 'EMP' "\
> DIRECTORY=data_pump_dir \
> DUMPFILE=full_db.dmp \
> LOGFILE=full_db.1og
Which three objects will be exported?
A) EMP_PK
B) EMP_SEQ
C) EMP_OPS_PKG
D) EMP_VU
E) EMP_IDX
F) EMP_TRG
G) EME_FN
Answer：BCD（已验证）
如果在导出的过程中排除了一张表，那么跟这张表相关的数据就不会导出，比如表的结构、数据、索引、约束、触发器等。但是其它跟这张表相关的关系不是密切的对象还是会导出，比如：该表引用序列、访问该表的存储过程、创建在该表上的视图等。这道题是新题，相关的内容以前没有出现过。
expdp system/oracle DUMPFILE=scott.dmp
DIRECTORY=dmpdir SCHEMAS=scott EXCLUDE=TABLE:\"IN\(\'EMP\'\)\"
SCHEMAS=scott
注意以上cxclude的语法
need-to-insert-img
⼗十三.Audit
32. You want to audit update statements that refer to USER1.DEPT.DNAME. Which type of auditing must you use?
A) standard auditing
B) mandatory auditing
C) value-based auditing
D) fine-grained auditing
Answer：D
33. Which three are true about auditing?
A) Auditing is active only when the database is OPEN.
B) Audit records are always stored in the database.
C) Audit of the use of system privileges can be enabled for individual database users.
D) DDL statements can be audited when they fail to execute.
E) All Oracle auditing operations occur by default.
F) DML statements can be audited when they execute successfully.
Answer：CDF
34. Which four are true about auditing?
A) DML statements can be audited when they fail to execute
B) Select statements can be audited when they execute successfully.
C) All Oracle auditing operations occur by default.
D) No Oracle auditing operations occur by default.
E) DDL statements can be audited when they fail to execute.
F) Some auditing is active before the database is open.
G) Audit records are never stored in the database.
H) Audit records are always stored in the database.
Answer：ABEF
need-to-insert-img
35. Examine this session output:
SQL> connect scott/tiger Connected.
SQL>select name,value
2 from v$parameter
3 where name='audit_trail';
NAMEVALUE
--------------------------------------
audit_trailDB
SQL> audit all on emp; Audit succeeded.
Which two will generate on audit record?
A) every update statement executed by scott that updates scott.emp
B) every ddl statement executed by scott that affects scott.emp
need-to-insert-img
C) any dml statement executed by sys on scott.emp
D) only the first select statement executed by scott in a session on scott.emp
E) every update statement executed by scott that updates hr.emp
F) only the first dml statement executed by system in a session on scott.emp
Answer：AB
