oracle 1z0-497 practice test

Exam Title: Oracle Database 12c Essentials

Last update: Dec 25 ,2025
Question 1

Which two statements about ADDM are true?

  • A. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
  • B. Real-Time ADDM uses ASH recent activity from SGA data.
  • C. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
  • D. Regular ADDM uses AWR snapshots that are not yet purged.
Answer:

BD


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

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 2

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

  • A. undo data
  • B. isolation level
  • C. lock mechanism
  • D. serializability
Answer:

BC


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

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 3

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

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

C


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

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 4

Which logical storage relationship is correct?

  • A. Tablespace< Segment < Extent < Oracle Datablock
  • B. B) Segment < Extent < Oracle Datablock<Tablespace
  • C. Tablespace< Extent < Segment < Oracle Datablock
  • D. Data File <Tablespace< Segment < Extent < Oracle Datablock
Answer:

A


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

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 5

Which two statements about multitenant architecture are true?

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

BD


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.
Explanation:
Reference:
Benefits of the Multitenant Architecture for Database Consolidation
URL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 6

Which three statements represent the benefits of multitenant architecture for database
consolidation?

  • A. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
  • B. You can consolidate shared database memory by combining multiple PDBs in a single CDB.
  • C. Patching individual PDBs requires the same amount of time as patching individual databases.
  • D. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
  • E. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.
Answer:

ABE


Explanation:
By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this
PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the
transportable tablespace technique.
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.
Explanation:
Reference:
Benefits of the Multitenant Architecture for Database Consolidation
URL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 7

Which statement about the Oracle Advanced Security Data Redaction feature is true?

  • A. It transparently encrypts data at rest in Oracle databases.
  • B. It securely manages encryption keys.
  • C. It protects against theft or loss of disks and backups.
  • D. It prevents OS users from inspecting tablespace files.
  • E. It limits the exposure of sensitive data in applications.
  • F. It alters data in caches, buffers, and persistent storage.
  • G. It impacts operational activities such as backup & restore, upgrade & patch, and replication.
Answer:

E


Explanation:
Redacting Sensitive Data for Display
Data Redaction provides selective, on-the-fly redaction of sensitive data in query results prior
to display by applications so that unauthorized users cannot view the sensitive data. It enables
consistent redaction of database columns across application modules accessing the same data.
Data Redaction minimizes changes to applications because it does not alter actual data in
internal database buffers, caches, or storage, and it preserves the original data type and
formatting when transformed data is returned to the application. Data Redaction has no
impact on database operational activities such as backup and restore, upgrade and patch, and
high availability clusters.
Explanation:
Reference:
Oracle Advanced Security, 12c, Oracle Data Sheet

vote your answer:
A
B
C
D
E
F
G
A 0 B 0 C 0 D 0 E 0 F 0 G 0
Comments
Question 8

Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?

  • A. It requires the database to be open.
  • B. It analyzes the performance of specified objects.
  • C. It implements all recommendations automatically.
  • D. It recommends solutions and quantifies expected benefits.
  • E. It retains snapshots in the SYSAUX tablespace until the database is restarted.
  • F. It analyzes the snapshots stored in the Automatic Workload Repository (AWR).
Answer:

A, D, F


Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/server.102/b14211/diagnsis.htm

vote your answer:
A
B
C
D
E
F
A 0 B 0 C 0 D 0 E 0 F 0
Comments
Question 9

Which is the default port number for Database Express?

  • A. 7801
  • B. 5500
  • C. 2243
  • D. 1521
  • E. 22
Answer:

B


Explanation:
Reference:
http://dbasolved.com/2013/07/05/em-express-12c-edition/

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 10

Your customer is looking for a solution to address these downtime needs:
- Online addition and removal of disks should automatically rebalance data across new storage
configurations while storage, database, and applications remain online.
- Dynamically add or remove clustered nodes without disrupting the database or applications.
- Automate the sizing and distribution of shared memory.
- Add a column with a default value without disrupting the database or applications.
- Perform rolling patch upgrades.
Which four would you recommend to address those needs?

  • A. Automatic Storage Management (ASM)
  • B. Online Data and Application change
  • C. Global Data Services (GDS)
  • D. Real Application Clusters (RAC)
  • E. Oracle Streams
  • F. Online Table Redefinition
  • G. Oracle Database Vault
Answer:

A, B, D, F

vote your answer:
A
B
C
D
E
F
G
A 0 B 0 C 0 D 0 E 0 F 0 G 0
Comments
Page 1 out of 14
Viewing questions 1-10 out of 150
Go To
page 2