Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-497

Free Oracle 1Z0-497 Exam Braindumps (page: 4)

Page 4 of 31
PDF with 150 Questions

Which two statements about ADDM are true?

  1. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
  2. Real-Time ADDM uses ASH recent activity from SGA data.
  3. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
  4. Regular ADDM uses AWR snapshots that are not yet purged.

Answer(s): B,D

Explanation:

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



Which two items are key for maintaining data consistency in Oracle Database 12c?

  1. undo data
  2. isolation level
  3. lock mechanism
  4. serializability

Answer(s): B,C


Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e25789/consist.htm#CNCPT88969 (overview of the oracle database locking mechanism)



You are about to install Oracle Database 12c Enterprise Edition.
Which statement is true?

  1. You should not install the Oracle Database software into an existing Oracle home from a different release.
  2. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
  3. Oracle recommends that you back up the root. sh script after you complete the installation.
  4. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
  5. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

Answer(s): C

Explanation:

https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1035 https://docs.oracle.com/database/121/LADBI/post_inst_task.htm#LADBI7749



Which logical storage relationship is correct?

  1. Tablespace< Segment < Extent < Oracle Datablock
  2. B) Segment < Extent < Oracle Datablock<Tablespace
  3. Tablespace< Extent < Segment < Oracle Datablock
  4. Data File <Tablespace< Segment < Extent < Oracle Datablock

Answer(s): A


Reference:

http://www.dummies.com/how-to/content/basics-of-logical-structures-in-oracle-12c.html



Which two statements about multitenant architecture are true?

  1. Multiple PDBs on a single server need multiple database instances and multiple sets of database files.
  2. Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.
  3. 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. It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.
  5. It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

Answer(s): B,D

Explanation:

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.


Reference:

Benefits of the Multitenant Architecture for Database Consolidation URL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239



Viewing page 4 of 31
Viewing questions 16 - 20 out of 150 questions



Post your Comments and Discuss Oracle 1Z0-497 exam prep with other Community members:

1Z0-497 Exam Discussions & Posts