1Z0-052 training materials

The advantage for 1Z0-052 training materials:
We provide the latest and the most effective questions and answers, under the premise of ensuring quality, we also offer the best price.

The most reliable Oracle Database 11g: Administration I training materials and learning information!
Regularly updated, and including the latest, most accurate examination dumps!
Senior IT lecturer Oracle 1Z0-052 Product Specialist collate the braindumps, guarantee the quality!
Any place can be easy to learn with pdf real questions and answers!

1. 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
2. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type o 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