Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-497

Oracle 1z0-497 Exam Practice Questions (P. 3)

  • Full Access (150 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
Which two statements about ADDM are true?
  1. A
    Real-Time ADDM uses AWR snapshots of the last 10 minutes.
  2. B
    Real-Time ADDM uses ASH recent activity from SGA data.
  3. C
    Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
  4. D
    Regular ADDM uses AWR snapshots that are not yet purged.

Correct Answer:
BD
http://www.dba-scripts.com/articles/ocp-flashcards/ocp-12c-emergency-monitoring-real-time-addm/

Question #12
Which two items are key for maintaining data consistency in Oracle Database 12c?
  1. A
    undo data
  2. B
    isolation level
  3. C
    lock mechanism
  4. D
    serializability

Correct Answer:
BC
References:

Question #13
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
  1. A
    You should not install the Oracle Database software into an existing Oracle home from a different release.
  2. B
    A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
  3. C
    Oracle recommends that you back up the root. sh script after you complete the installation.
  4. D
    Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
  5. E
    You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

Correct Answer:
A
https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1035

Question #14
Which logical storage relationship is correct?
  1. A
    Tablespace< Segment < Extent < Oracle Datablock
  2. B
    Segment < Extent < Oracle Datablock<Tablespace
  3. C
    Tablespace< Extent < Segment < Oracle Datablock
  4. D
    Data File <Tablespace< Segment < Extent < Oracle Datablock

Correct Answer:
A
References:

Question #15
Which two statements about multitenant architecture are true?
  1. A
    Multiple PDBs on a single server need multiple database instances and multiple sets of database files.
  2. B
    Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.
  3. C
    A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.
  4. D
    It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.
  5. E
    It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

Correct Answer:
BD
B: A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.

D: Ease of performance tuning -
It is easier to collect performance metrics for a single database than for multiple databases. It is easier to size one SGA than 100 SGAs.
References:

Previous Questions Next Questions

All Pages