The Secret of Oracle 1z0-481 vce

Q1. In addition to using the parameter comment to enter remarks in parameter file(s) can be used?

A. - -

B. //

C. \

D. /*

View Answer

Q2. How does Replicat know the structure of the source tables when the target has a different layout?

A. GoldenGate trail file contains the metadata of incoming data

B. Replicat uses an ODBC connection to connect to the source system tables

C. Parameter file contains table layouts

D. Discard file contains table layouts

E. Source Definitions file contains table layouts

View Answer

Q3. Which three can GoldenGate encrypt?

A. Extract to Server messages

B. Trails

C. Passwords

D. Redo logs

View Answer

Q4. Which three describe a valid OGG Event Action?

A. Stop the process

B. Write a checkpoint before and/or after writing the record to the trail.

C. Run a shell command

D. Purge old trail files

View Answer

Q5. Select the statement that is supported by OGG DDL Replication.

A. ENCRYPT

B. ALTGLOBAL

C. CREATE ROLE

D. ALTDB

View Answer

Q6. Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete?

A. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key.

B. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes.

C. The first column, excluding virtual columns and nullable columns, will be treated as the pr key.

D. The combination of all fields up to the first thirty-two will be treated as a compound primary key

View Answer

Q7. By default which type of operations are captured by extract?

A. Inserts, updates, deletes, and table operations such as CREATE TABLE

B. Inserts, compresses, and updates

C. Inserts, updates, deletes, and table operations such as ADD COLUMN

D. Inserts only

E. Inserts, updates, and deletes

View Answer

Q8. What command is issued to alter Replicat to start processing trail number 10 at relative byte address 100345?

A. Alter <group>, extseqno 10, extrba 100345

B. Alter Replicat *, exttrail <trail prefix>, extseqno 10, extrba 100345

C. Alter Replicat <group>, sequence lO, rba 100345

D. Alter <group>, sequence 10, rba 100345

View Answer

Q9. What is the default threshold for message compression in OGG?

A. 1000

B. 100

C. O

D. By default, messages are not compressed.

View Answer

Q10. If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

A. Manager

B. Extract

C. Replicat

D. Both Extract and Replicat

View Answer