1. Home
  2. Oracle
  3. Oracle Database 12c Certified Implementation Specialist
  4. 1z0-497
  5. Oracle Database 12c Essentials Questions and Answers

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

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 2 out of 5 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which two statements about Global Data Services (GDS) are correct?

Options:
A.

GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).

B.

GDS helps in performing data replication.

C.

GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.

D.

GDS helps to perform database failovers, and does not require Data Guard Broker.

E.

The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.

Questions # 12:

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

Options:
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.

Questions # 13:

Your database instance is down because there was a user-initiated shutdown. Which option represents the actions performed, in the correct order, if you start up the instance?

a - The control file is read.

b - Memory is allocated.

c - Background processes pre started.

d -The initialization parameter file is read,

e- Redo log files and data files are opened.

Options:
A.

b, c, a

B.

d, a, e

C.

a, e, d, b

D.

d, b, c, a, e

E.

c, b, d, a, e

Questions # 14:

Which two statements are true about shared server sessions?

Options:
A.

No Program Global Area (PGA) is allocated for shared server processes.

B.

User Global Area is stored in System Global Area (SGA).

C.

Shared SQL Area is allocated from Program Global Area (PGA).

D.

Private SQL Area is allocated from Library Cache.

E.

Large Pool is used for SQL work areas.

Questions # 15:

Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs.

Consider these options:

- Instance, site recovery, and heterogeneous setup

- Inter-region and intra-region load balancing across replicated databases

- Fine-grained error investigation of incorrect results

- Integrated client and application failover

- Fastest and simplest database replication

Which four options would you recommend?

Options:
A.

Oracle GoldenGate

B.

Global Data Services

C.

Oracle Data Guard

D.

Data Recovery Advisor

E.

Oracle Flashback technology

F.

Oracle Advanced Queuing

Questions # 16:

Which statement about the Queryable Patch inventory feature is false?

Options:
A.

It is used to retrieve installed patch information from a SQL prompt.

B.

It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

C.

DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

D.

It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

Questions # 17:

You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

Options:
A.

You can drop the PDB only if it is closed.

B.

You can drop the seed PDB, but you cannot create any other PDB within the CDB.

C.

You can drop the PDB and keep the data files to be reused by another PDB.

D.

When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.

Questions # 18:

Which two statements are true about listeners?

Options:
A.

Listeners use only the TCP/IP protocol.

B.

Multiple listener processes can run simultaneously on a host.

C.

Multiple database instances can be registered with a single listener,

D.

Listener-related errors can be traced only at the administrative level.

E.

Only one database instance can be registered with a single listener at any time.

Questions # 19:

Which two statements are true when you execute an invoker's rights procedure?

Options:
A.

The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.

B.

Invoking users can control who can access their privileges when they run an invoker's rights procedure.

C.

The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

D.

The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

Questions # 20:

You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the product-specific prerequisite checks has failed:

Checking available swap space requirements...

Expected result: 1512MB

Actual Result: 1018MB

Check complete. The overall result of this check is: failed ««

Problem: The system does not have the required swap space.

What happens to the installation in this situation?

Options:
A.

It can be continued.

B.

It resizes the swap space automatically when you proceed further.

C.

It can be continued, but the instance cannot be started without increasing swap space.

D.

It shows a message saying one or more prerequisite checks have failed and the installation aborts.

Viewing page 2 out of 5 pages
Viewing questions 11-20 out of questions