1Z0-497 Online Practice Questions and Answers

Which two statements are true about shared server sessions?

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.

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

A. Automatic Storage Management (ASM)

B. OS file system

C. logical volume (LVM)

D. clustered file system

E. RAW

Which option represents a function of Global Data Services (GDS)?

A. performs data replication

B. performs database failovers

C. replaces the functionality of Oracle Clusterware and Oracle RAC

D. coordinates site failovers

E. works seamlessly with Oracle Site Guard

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?

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.

Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?

A. Oracle Data Guard

B. Oracle Streams

C. Oracle Real Application Clusters

D. Oracle GoldenGate

Which statement about Oracle patches is false?

A. Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.

B. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.

C. Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.

D. Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.

E. Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.

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

A.

Oracle GoldenGate

B.

Global Data Services

C.

Oracle Data Guard

D.

Data Recovery Advisor

E.

Oracle Flashback technology

F.

Oracle Advanced Queuing

Which four options would you recommend?

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

A. The DML operations re-create the bitmap index blocks.

B. The bitmap index is rebuilt automatically after a DML operation.

C. The smallest amount of a bitmap that can be locked is a bitmap segment.

D. Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

Which three statements about replication options are true?

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

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

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

D. Oracle Database Advanced Queuing is independent of Oracle Streams.

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

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

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.