nerdexam
Oracle

1Z0-497 · Question #93

Which three DBA operations can be performed by using Oracle SQL Developer?

The correct answer is A. database backup and recovery using RMAN B. performance tuning operations such as generation of AWR, ADDM, and ASH reports E. database status view and Data Pump export and import jobs. ASH and AWR reports The ASH and AWR reports list information provided by the Active Session History (ASH) and Automated Workload Repository (AWR) features, which require special licensing. RMAN Backup/Recovery Includes options related to database backup and recovery. The…

Managing the Database Instance

Question

Which three DBA operations can be performed by using Oracle SQL Developer?

Options

  • Adatabase backup and recovery using RMAN
  • Bperformance tuning operations such as generation of AWR, ADDM, and ASH reports
  • Cstorage configuration for archive logs and control files
  • Dstorage configuration for data files and redo log groups
  • Edatabase status view and Data Pump export and import jobs

How the community answered

(32 responses)
  • A
    78% (25)
  • C
    6% (2)
  • D
    16% (5)

Explanation

ASH and AWR reports The ASH and AWR reports list information provided by the Active Session History (ASH) and Automated Workload Repository (AWR) features, which require special licensing. RMAN Backup/Recovery Includes options related to database backup and recovery. The options use the Oracle Database Recovery Manager (RMAN) feature, which is described in detail in Oracle Database Backup and Recovery User's Guide. You should be familiar with RMAN concepts and techniques before using In any dialog box or wizard for RMAN operations, you can click the SQL or Summary tab to see the statements that will be used to implement the specified options. Includes options for displaying status information about the database. Includes options for using the Oracle Data Pump Export and Import utilities, which are described in detail in Oracle Database Utilities.

Topics

#SQL Developer#RMAN#AWR#Data Pump

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice