OCA OCP Oracle Certification Exam Braindumps

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

High quality and Value for the1Z0-052Exam.
 

Killtest Practice Exams for Oracle Database 11g: Administrator I : 1z1-052 Exam 1Z0-052 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 11g exam and get your 11g Certification.

We guarantee your success in the first attempt. If you do not pass the 1Z0-052 exam (Oracle Database 11g: Administrator I : 1z1-052 Exam) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free. Killtest  will help you to pass the 1Z0-052 exam. TestPassport 1Z0-052 contains 188 questions, multiple choice answers.

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.
Answer: B