Oracle Database 12c Essentials - 1z0-497 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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?

A. Peer-to-peer for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4 B. Uni-directional for 1 Peer-to-peer for 2 Bi-directional for 3 Consolidation for 4 C. Peer-to-peer for 1 Consolidation for 2 Broadcast for 3 Cascading for 4 D. Uni-directional for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which two statements about Automatic Data Optimization (ADO) are true?

A. ADO policies can automatically move segments when necessary. B. ADO is not dependent on Heat Map, and works even if Heat Map is disabled. C. ADO policies can automatically compress data when it qualifies. D. You cannot compress at block level, but you can compress at segment level. E. You can compress at row level only for QUERY LOW.

Discussion 0

Correct Answer: A,C Vote an answer

Question 3

Which is the default port number for Database Express?

A. 22 B. 7801 C. 2243 D. 1521 E. 5500

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B.
which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?

A. Oracle GoldenGate B. Oracle Advanced Replication C. Oracle Streams D. Oracle Active Data Guard

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

Which three operations can the PUBLIC user with the SYSOPER privilege perform?

A. SHUTDOWN B. STARTUP C. CREATE DATABASE D. DROP DATABASE E. ALTER DATABASE RECOVER

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

What must you do to an application for it to take advantage of partitioning?

A. rework the applications schema B. recompile it C. relink D. rewrite its SQL queries E. nothing; it is transparent

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

Which two statements correctly distinguish between undo and redo data?

A. Undo reverses a change, whereas redo re-creates a change. B. Redo protects against inconsistent reads, whereas undo protects against data loss. C. Undo protects against inconsistent reads, whereas redo protects against data loss. D. Redo reverses a change, whereas undo re-creates a change.

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

Which two statements are true about shared server sessions?

A. Private SQL Area is allocated from Library Cache. B. Large Pool is used for SQL work areas. C. Shared SQL Area is allocated from Program Global Area (PGA). D. User Global Area is stored in System Global Area (SGA). E. No Program Global Area (PGA) is allocated for shared server processes.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).