Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Oracle 1Z0-447 Certification Online Quiz

Total questions: 5

Worksheet time: 3mins

Name
Class
Date
1.

What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

a)

a) KEYGEN file in the GoldenGate data location

b)

b) COBGEN file in the GoldenGate installation location

c)

c) GGSKEY file in the GoldenGate data location

d)

d) GGSKEY file in the GoldenGate installation location

e)

e) ENCKEYS file in the GoldenGate installation location

2.

Which GGSCI command(s) show all available information on both read and write checkpoint for an Extract?

Example: 1 INFO EXTRACT <group name>

Example: 2 INFO EXTRACT <group name>, DETAIL

Example: 3 INFO EXTRACT <group name>, SHOWCH

a)

a) Example 2 only

b)

b) Example 3 only

c)

c) Examples 1 and 3

d)

d) Examples 1 and 2

3.

When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture?

a)

a) The middle-tier capture server has the same endian order and bit width

b)

b) The middle-tier server must have a database installed on it

c)

c) GoldenGate only supports Windows or Linux on the middle-tier server

d)

d) GoldenGate only supports UNIX on the middle-tier server

4.

Which process(es) maintain a checkpoint file?

a)

a) Extract only

b)

b) Replicat only

c)

c) Both Extract and Replicat

d)

d) Server collector

5.

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)

a) Manager

b)

b) Extract

c)

c) Replicat

d)

d) Both Extract and Replicat