Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Database 12c Certified Implementation Specialist
1z0-497
Oracle Database 12c Essentials Questions and Answers

Pass the Oracle Database 12c Certified Implementation Specialist 1z0-497 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-497 Premium Access

View all detail and faqs for the 1z0-497 exam

Go to Exam

666 Students Passed

85% Average Score

98% Same Questions

Viewing page 4 out of 5 pages

Viewing questions 31-40 out of questions

Questions # 31:

Which three are initialization parameters for backup and recovery?

Options:

CLONEDB

FILESYSTEMIO_OPTIONS

DB_CREATE_FILE_DEST

RECYCLEBIN

TAPE_ASYNCH_IO

Answer

A, D, E

Explanation

http://docs.oracle.com/database/121/REFRN/refrn00102.htm#REFRN00102

Questions # 32:

Which three background processes are mandatory in a database Instance started with a minimally configured Initialization parameter file?

Options:

Process Monitor Process (PMON)

Flashback Data Archive process (FBDA)

Space Management Coordinator process (SMCO)

Recoverer process (RECO)

Listener Registration process (LREG)

Checkpoint Process

Answer

D, E, F

Explanation

[Reference: Oracle Database Concepts 12c, Mandatory Background Processes, http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT008, ]

Questions # 33:

Which three statements about replication options are true?

Options:

The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

Oracle Streams is deprecated in Oracle Database 12c Release 1.

Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

Oracle Database Advanced Queuing is independent of Oracle Streams.

The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

Answer

B, C, E

Explanation

http://docs.oracle.com/cd/E11882_01/server.112/e10705/prep_rep.htm#STREP220

http://www.oracle.com/technetwork/database/multitenant/overview/index.ht ml

https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60159

http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf

Questions # 34:

Question # 34

Options:

Option A

Option B

Option C

Option D

Option E

Answer

A, C, E

Questions # 35:

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

Options:

SYSBKP

SYSBKPRMAN

SYSRMAN

SYSBACKUP

Answer

Explanation

[Reference: http://docs.oracle.com/cd/E16655_01/backup.121/e17631/release_changes.htm#RCMRF90521 (sys backup privilege), , ]

Questions # 36:

You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?

Options:

shared UNDO and default database temporary tablespace

Oracle-supplied metadata

shared Oracle-supplied data

CDB views providing information across PDBs

application tablespaces

local temporary tablespaces

local users and local roles

Answer

E, F, G, H

Questions # 37:

Which two statements about multitenant architecture are true?

Options:

Multiple PDBs on a single server need multiple database instances and multiple sets of database files.

Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.

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.

It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.

It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

Answer

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, , , ]

Questions # 38:

In which situation would you use static database registration for a listener?