当前位置:我的异常网» IT认证 » Oracle 2010题库大全之1Z0-052 (由testpassport特别
Oracle 2010题库大全之1Z0-052 (由testpassport特别提供)解决思路
www.myexceptions.net 网友分享于:2013-02-27 浏览:89次
Oracle 2010题库大全之1Z0-052 (由testpassport特别提供)
Testpassport Oracle 1Z0-052 题库
Testpassport 11g 1Z0-052题库由资深IT认证讲师和11g产品专家结合PROMETRIC的真实考试环境最新原题倾心打造..,题库覆盖了当前最新的真实考题,并且全部附有正确答案。
不多说,直接上题
认证编号: Oracle Database 11g: Administrator I : 1z1-052 Exam
考题数量: 188 Q&As
更新: Jan-15-2010
1. View the Exhibit and examine the attributes of an undo tablespace.
In an OLTP system, the user SCOTT has started a query on a large 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 old
What could be the reason for this error?
A.The query is unable to get a read-consistent image.
B.There is 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: A
2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
C.The snapshots collected by the AWR are accessible through data dictionary views.
D.The snapshots collected by the AWR are used by self-tuning components in the database.
Answer: CD
3. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in
poor database performance. Which option would you use to reduce fragmentation without affecting the
users who are currently using the index?
A.Validate the index structure using the ANALYZE...INDEX command.
B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.
C.Change the block space utilization parameters using the ALTER INDEX command.
D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.
The safer , easier way to help you pass any IT exams.
3 / 10
Answer: B
4. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of
backups that can be performed on the database?
A.You can perform online whole database backups.
B.You can perform offline whole database backups.
C.You cannot perform schema-level export/import operations.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.
Answer: B
5. The database instance is currently using SPFILE. View the Exhibit and examine the error that you
received while running the DB Structure Integrity check.
Given below are the steps to recover from the error in random order:
1: Shut down the instance, if not already done.
2: Copy one of the remaining control files to a new location.
3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of
the control files.
4: Start up the database instance to the NOMOUNT stage.
5: Recover the database to the point of failure of the control file.
6: Open the database.
Identify the correct sequence of steps?
A.1, 2, 4, 3, 5, 6
B.2, 4, 3, 5, 6; 1 not required
C.4, 5, 6, 2, 3; 1 not required
D.5, 2, 3, 4; 1 and 6 not required
Answer: A
6. Note the following points describing various utilities in Oracle Database 11g:
The safer , easier way to help you pass any IT exams.
4 / 10
1: It enables the high-speed transfer of data from one database to another.
2: It provides a complete solution for the backup, restoration, and recovery needs of the entire database.
3: It enables the loading of data from an external file into an Oracle database.
4: It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup?
A.1
B.2
C.3
D.4
E.1, 2, and 4
F.1, 2, 3, and 4
Answer: D
需要完整版的请登录www.testpassport.cn 获取
希望对大家有帮助!大家帮我顶起来啊!!!!!!!!!!!!!!!!
------解决方案--------------------
文章评论