Practice Test Geeks1Z0-082 - Oracle Database Administration I Practice Test
← All 1Z0-082 Flashcard Decks

Database Maintenance Flashcards

5 cards from real 1Z0-082 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 5 Database Maintenance flashcards as text

  1. Which Oracle tool is primarily used for performing database maintenance tasks such as backup and recovery?

    Answer: Oracle Enterprise Manager (OEM)

    Oracle Enterprise Manager (OEM) is a comprehensive suite of tools designed for managing and monitoring Oracle environments. It provides a graphical interface and robust capabilities for performing various database maintenance tasks, including backup and recovery, performance tuning, and security management. The other options are specialized tools for specific functions, not general maintenance.

  2. Which of the following is a proactive database maintenance task to prevent tablespace overflow?

    Answer: Increasing the size of datafiles or adding more datafiles to a tablespace

    Tablespace overflow occurs when a tablespace runs out of free space to store new data, leading to errors. Proactively increasing the size of existing datafiles (if they are autoextensible) or adding new datafiles to the tablespace ensures sufficient storage capacity. This prevents data insertion failures and maintains database availability, making it a key proactive maintenance task.

  3. What is the purpose of the ANALYZE command in Oracle Database maintenance?

    Answer: To update statistics for the optimizer

    The `ANALYZE` command (or more commonly, `DBMS_STATS` procedures) is used to collect statistics about database objects like tables, indexes, and columns. These statistics are vital for the Oracle optimizer to determine the most efficient execution plan for SQL queries. Accurate statistics help the optimizer choose the best access paths, leading to improved query performance.

  4. Which Oracle utility is used to reorganize tables and indexes to reclaim unused space?

    Answer: DBMS_REDEFINITION

    The `DBMS_REDEFINITION` package allows for online redefinition of tables, which can be used to reorganize tables and their associated indexes. This process helps reclaim unused space, improve storage efficiency, and enhance performance without requiring significant downtime. Other utilities like SQL*Plus are general interfaces, and Data Pump/Export/Import are for data movement, not online reorganization.

  5. What is the main purpose of running the DBMS_STATS.GATHER_SCHEMA_STATS procedure in Oracle?

    Answer: To optimize query performance by updating statistics for all objects in a schema

    The `DBMS_STATS.GATHER_SCHEMA_STATS` procedure is used to collect and update optimizer statistics for all tables, indexes, and columns within a specified schema. Accurate statistics are crucial for the Oracle optimizer to generate efficient execution plans for SQL queries. By keeping statistics up-to-date, this procedure significantly improves overall query performance.