FREE 1Z0-082 Database Maintenance Questions and Answers

Question 1

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

Accepted Answer

Oracle Enterprise Manager (OEM)

Answer

SQL*Loader

Answer

Oracle Text

Answer

Oracle Net Manager

Question 2

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

Accepted Answer

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

Answer

Rebuilding indexes

Answer

Creating user roles

Answer

Auditing user activities

Question 3

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

Accepted Answer

To update statistics for the optimizer

Answer

To create a new tablespace

Answer

To back up the database

Answer

To grant user privileges

Question 4

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

Accepted Answer

DBMS_REDEFINITION

Answer

SQL*Plus

Answer

Data Pump

Answer

Export/Import

Question 5

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

Accepted Answer

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

Answer

To recover lost data

Answer

To create a new user

Answer

To manage database connections