Oracle Database Administration II
15 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which two are true about gathering optimizer statistics?

  • System statistics can be gathered only while the CDB is in MOUNT state.
  • Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB. (correct)
  • Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.
  • Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).
  • Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT. (correct)

    • Choose the minimum required steps in the correct order to recover the database.

  • 1,3, 5, 6, 10
  • 1,2, 5, 7, 4, 10
  • 1,3,5, 6, 9
  • 1,3, 5, 7, 10 (correct)
  • 1,3, 5, 6, 10
  • 1,3, 5, 8, 6, 10

    • By default, AWR snapshots are retained for 7 days.

    True (A)

    Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive __________ activity, thereby degrading performance.

    <p>hard parse</p> Signup and view all the answers

    Match the following flashback technologies with their purpose:

    <p>FLASHBACK TABLE customers TO TIMESTAMP = Revert the table to a specific point in time SELECT * FROM customers AS OF SCN = View the table as of a specific system change number FLASHBACK TABLE customers TO BEFORE DROP = Recover the table before it was dropped</p> Signup and view all the answers

    Which three are true about RMAN archival backups with the RESTORE POINT clause?

    <p>Use of a recovery catalog is always required to support the creation and use of archival backups. (B), Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored. (F), The SPFILE is included in the archival backup. (G)</p> Signup and view all the answers

    Which three are true about backing up the control file?

    <p>It can be backed up manually as a trace file containing SQL statements for control file recreation. (B), It can be backed up manually as a binary copy. (C), It can get backed up automatically as a binary copy. (D)</p> Signup and view all the answers

    Which two are true about gathering optimizer statistics?

    <p>Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT. (D), Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB. (E)</p> Signup and view all the answers

    Which two are true about Recovery Manager (RMAN) diagnostic message output?

    <p>The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only. (D), RMAN error stacks should be read from the top down as that is the order in which errors are generated. (E)</p> Signup and view all the answers

    Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted. To recover from this critical failure, you execute these commands: What will be the outcome?

    <p>It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'</p> Signup and view all the answers

    You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

    <p>The recovery catalog is synchronized from the target database control file with a full resync at the next backup. (B)</p> Signup and view all the answers

    You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

    <p>Cloning the non-CDB as a PDB (D), The DBMS_PDB package (E), Data Pump full database export and import (F)</p> Signup and view all the answers

    Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

    <p>Tables or table partitions can be recovered by using an auxiliary instance only. (A), Tables or table partitions from the system and sysaux tablespaces cannot be recovered. (D)</p> Signup and view all the answers

    Which three are true about an application seed pluggable database (PDB)?

    <p>A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes. (A), A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes. (E)</p> Signup and view all the answers

    When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

    <p>Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used. (B), If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck. (C)</p> Signup and view all the answers

    Study Notes

    Oracle Database Administration II

    Exam 1Z0-083

    • Topics: Oracle Database Administration II, Oracle 19c, Oracle Multitenant, Recovery Manager (RMAN), Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Manageability Monitor (MMON)

    Passing-sure 1Z0-083 Study Materials

    • Exam dumps for Oracle Database Administration II
    • IT Certification Guaranteed

    Key Features

    • Oracle Database 19c
    • Container database (CDB) and pluggable database (PDB)
    • Common table, FIN.REVENUE, in two PDBs

    Gathering Optimizer Statistics

    • Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs
    • Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB

    Threshold Server-Generated Alerts

    • Used to diagnose and fix problems
    • Situations include:
      • When free space in a dictionary managed tablespace falls below a specified percentage
      • When free space in a locally managed tablespace falls below a specified percentage
      • When the number of logons per second exceeds a specific value

    Creating an Application PDB

    • Two methods:
      • Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB
      • Create the PDB1 application PDB and synchronize it with HR_ROOT

    Automatic Execution of Operating System Scripts

    • During silent mode installation starting from Oracle Database 19c
    • The response file can specify the path of the sudo program
    • Silent install always runs operating scripts automatically

    Recovery Operations

    • Without using Recovery Manager (RMAN)
    • Situations include:
      • A lost PFILE can be re-created from alert.log using SQL*PLUS
      • A lost index tablespace can be re-created without performing any recovery
      • A lost password file can be manually re-created with the orapwd utility

    Automatic Workload Repository (AWR)

    • By default, AWR snapshots are taken every 60 minutes
    • Its collection level is determined by the value of the STATISTICS_LEVEL database parameter
    • By default, AWR snapshots are retained for 7 days
    • The taking of AWR snapshots can be disabled

    Transparent Data Encryption (TDE)

    • Uses a single master key for a database
    • Stores the current and all past master keys in the keystore
    • Master encryption keys are managed by Oracle Database Vault
    • Can encrypt data at the column level

    Backup-Based Duplicate Database

    • Two prerequisites:
      • Connecting to an auxiliary instance
      • Creating a password file for an auxiliary instance

    Diagnosing Oracle Database Failure Situations

    • Using Data Recovery Advisor
    • Two true statements:
      • Data Recovery Advisor can proactively check for failures
      • Data Recovery Advisor can be used if a database is closed

    Flashback Technologies

    • Depend on the availability of relevant undo data in the undo tablespace
    • Statements include:
      • FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
      • SELECT * FROM customers AS OF SCN 123456;
      • FLASHBACK TABLE customers TO BEFORE DROP;

    SYSBACKUP Privilege

    • Three true statements:
      • They can view data from any data dictionary view or dynamic performance view
      • They can view data from any user-defined tables
      • They can create any table

    RMAN Archival Backups

    • Three true statements:
      • All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database
      • The SPFILE is included in the archival backup
      • Use of a recovery catalog is always required to support the creation and use of archival backups

    Creating a Test Database

    • Method:

      • Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location### Diagnosing and Tuning Performance Bottlenecks in RMAN Backup

    • Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

    • If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

    • Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

    Note: The other options (B and D) are not true regarding diagnosing and tuning performance bottlenecks in RMAN backup.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    1z0-083.pdf

    Description

    Pass Oracle certification exam with study materials and dumps. Get guaranteed IT certification with ExamsLabs.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser