Online Access Free 1Z0-052 Practice Test

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.Change the block space utilization parameters using the ALTER INDEX command
• B.Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command
• C.Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command
• D.Validate the index structure using the ANALYZE .... INDEX command

You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)

• A.Decrease the number of redo log members if there are more than one redo log members available in each redo log group
• B.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
• C.Disable automatic checkpoint tuning
• D.Check the size of the redo log file size and increase the size if it is small

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.
Which two statements are true in this scenario? (Choose two.)

• A.You must shut down the database instance to perform the backups.
• B.You can perform complete database backups without closing the database.
• C.All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.
• D.You must configure the Flash Recovery Area (FRA) for the database.

You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file:
ORA19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.
What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)

• A.Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.
• B.Decrease the retention time for the database backup and flashback log files.
• C.Manually delete all the expired backup sets from the Flash Recovery Area by using operating system (OS) commands.
• D.Back up the Flash Recovery Area.

You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:
ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;
Which statement is true about this command?

• A.The command succeeds only if the data file is offline.
• B.The command must be issued when the database is in the archivelog mode.
• C.The command succeeds if no extent in the tablespace is currently allocated above the
  150 MB boundary of the file.
• D.The command must be issued in MOUNT state.