Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle 1z0-497 Questions Answers

Page: 2 / 6
Total 150 questions

Oracle Database 12c Essentials Questions and Answers

Question 5

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.

Question 6

Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?

Options:

A.

615 MB

B.

2.5 GB

C.

4 GB

D.

12 GB

E.

22 GB

Question 7

Your customer is looking for a solution that meets these four needs:

1 - Replicate data from source to target for reporting purposes.

2 -Replicate data from one source to multiple targets.

3 - Replicate data between two databases for instant failover.

4 - Replicate data from multiple sources to a single target for a data warehouse.

Which GoldenGate-supported topology would you recommended?

Options:

A.

Uni-directional for 1

Peer-to-peer for 2

Bi-directional for 3

Consolidation for 4

B.

Peer-to-peer for 1

Broadcast for 2

Bi-directional for 3

Consolidation for 4

C.

Uni-directional for 1

Broadcast for 2

Bi-directional for 3

Consolidation for 4

D.

Peer-to-peer for 1

Consolidation for 2

Broadcast for 3

Cascading for 4

Question 8

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

Options:

A.

addition or removal of nodes, memory, or disks

B.

changing configuration parameters, upgrading, or patching Oracle software

C.

file deletion

D.

migrating to cluster architecture

E.

dropped database object

F.

table definition changes

G.

runaway processes that consume system resources

Page: 2 / 6
Total 150 questions