《oracle_db11g_实施专家认证考试1z0-514模拟练习题[1]》由会员分享，可在线阅读，更多相关《oracle_db11g_实施专家认证考试1z0-514模拟练习题[1]（18页珍藏版）》请在金锄头文库上搜索。
1、注意：本材料仅供合作伙伴复习认证考试参考。本材料是针对 Oracle DB 11g Implementation Specialist (1Z0-514)认证考试的模拟练习题，目的在于掌握本考试相关的一些知识点。在考试中遇到的题目如有雷同，切勿在不理解含义的情况下仅根据关键字眼直接选出答案。答案仅供参考，可能存在有些答案不完全正确的情况。1.Identify two situations in which you can use Data Recovery Advisor for recovery.(Choose two)A.The database files are corrupted w
2、hen the database is open.B.The user has dropped an important table that needs to be recovered.C.The archived redo log files are missing for which the backup is not available.D.The database is not opening because the required database files are missing.Answer:AD2.You are managing an Oracle Database 1
3、1g database. The database is open, and you plan to perform Recovery Manager(RMAN) backups. Which three statements are true about these backups?(Choose three)A.The backups would be consistent.B.The backups would by inconsistent.C.The backups would be possible only if the database is running in ARCHIV
4、ELOG mode.D.The backups would be possible only if the database is running in NOARCHIVELOG mode.E.The backups need to be restored and the database has to be recovered in case of a media failure.RMAN 就是 Recovery MANanger, 是 Oracle 用来备份和恢复的，它有一套专门的语法和命令。Answer:BCE3.Which three statements are correct ab
5、out temporary tables?(Choose three)A.Indexes and views can be created on temporary tables.B.Both the data and the structure of temporary tables can be exported.C.Temporary tables are always created in as users temporary tablespace.D.The data inserted into a temporary table in a session is available
6、to other sessions.E.DML locks are never acquired on the data of temporary tables.Answer:ACE4.Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?A.It is the time period after which the undo data becomes obsolete.B.It is the time period after which the c
7、ommitted undo data would be transferred to a temporary tablespace.C.It is the minimum time period up to which the committed undo data would be retained if free undo space is available.D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consiste
8、ncy.Answer:C5.You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQLDROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about the effect of the command?(Choose two.)A.No flashback is possible to bring back the ITEM table
9、.B.The ORDERS table is dropped along with the ITEM table.C.The dependent referential integrity constraints in the ORDERS table are disabled.D.The dependent referential integrity constraints in the ORDERS table are removed.E.The table definition of the ITEM table and associated indexes are placed in
10、the recycle bin.Answer:AD6.Which three statements regarding the server parameter file(SPFILE) are true?(Choose three)A.An SPFILE is a binary file.B.An SPFILE cannot reside on a client.C.An SPFILE cannot contain static parameters.D.An SPFILE can store changes persistently across instance restarts.E.A
11、n SPFILE can be read by the database, but it is not written to by the server.F.An SPFILE must be created manually, before creating a database, even if you use the DBCA to create the DB.Answer:ABD7.You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct
12、 path load method to perform this task. The table in which you plan to load data is an important table having various integrity constraints defined on it. Which constraints will remain enabled by default during this operation?(Choose all that apply)A.CHECKB.UNIQUEC.NOT NULLD.PRIMARY KEYE.FOREIGN KEY
13、Answer:BCD8.Which three operations require undo data?(Choose three)A.Committing a transaction.B.Flashing back a transaction.C.Recovering a failed transaction.D.Running a read-consistent query.E.Changing a tablespace status from READ ONLY to READ WRITE.Answer:BCD9.In an OLTP system, the user SCOTT ha
14、s started a query on a table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:ORA-01555:snapshot too oldWhat could be the reason for this error?A.The query is unable to get a read-consistent image.B.There i
15、s not enough space in Flash Recovery Area.C.There is not enough free space in the flashback archive.D.The query is unable to place data blocks in undo tablespace.Answer:A10.You have issued a SHUTDOWN ABORT command to bring down you database instance. Consider the steps that will be performed later w
16、hen open the database:1.SGA is allocated.2.Control file is read.3.Redo log files are read.4.Instance recovery is started.5.Background processes are started.6.Data files are checked for consistency.7.Server parameter file or the initialization parameter file is read.Which option has the correct order in which these steps occur?A.7,1,5,2,3,6,4B.1,2,3,7,5,6,4C.7,1,4,5,2,3,6D.1,7,5,4,2,3,6Answer:A11.Your database instance is configured with automatic undo management and the UNDO_RETENTIO
