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

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 dictionaryviews.
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 highlyfragmented, thereby resulting in poor database performance. Which option wouldyou 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

Oracle Database 11g: Administrator I

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