Recent

  • Show all results for ""

🎧 New: AI-Generated Podcasts Turn your study notes into engaging audio conversations. Learn more

Oracle Database Administration II
15 Questions
0 Views

Oracle Database Administration II

Created by
@ProperHeliotrope5340

Podcast Beta

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

    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.</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.</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.</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.</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.</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</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.</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.</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.</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 Quizzes Like This

    Oracle Database Administration Quiz
    6 questions

    Oracle Database Administration Quiz

    HonoredTruth avatar
    HonoredTruth
    Oracle Net Services Architecture Quiz
    5 questions

    Oracle Net Services Architecture Quiz

    InspirationalStream avatar
    InspirationalStream
    Tareas de un Administrador de la Base de Datos Oracle
    20 questions

    Tareas de un Administrador de la Base de Datos Oracle

    DelectableSweetPea avatar
    DelectableSweetPea
    Using Single-Row Functions in Oracle Database
    11 questions

    SQL Single Row vs Multiple Row Functions: Key Differences

    QuaintKoto avatar
    QuaintKoto
    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser