1z0-481 | Renovate Oracle 1z0-481 practice test

Q1. Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

A. ALTER EXTTRAIL <trail name>, NEXTSEQNO

B. ALTER EXTTRAIL <trail name>, ROLLOVER

C. SEND EXTRACT <group>, ETROLLOVER

D. SEND EXTRACT <group>, ROLLOVER

Answer: D

Explanation:

In reference guide, page 36:Syntax SEND EXTRACT <group name>, {CACHEMGR

{CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS <ID> [THREAD <n>] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER

|SHOWTRANS [<ID>] [THREAD <n>] [COUNT <n>][DURATION <duration><unit>] [TABULAR][FILE <name> [DETAIL]] |SKIPTRANS <ID> [THREAD <n>] [FORCE]STATUS

|STOP |TLTRACE {DEBUG | OFF | <level>} [DDLINCLUDE | DDL[ONLY]] [FILE] <file name> |TRACE[2] <tracefile> |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS

{PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS}

|TRANLOGOPTIONS TRANSCLEANUPFREQUENCY <minutes> |VAMMESSAGE

“<Teradata command>” |VAMMESSAGE {“ARSTATS” | “INCLUDELIST [filter]” | “EXCLUDELIST [filter]”} |VAMMESSAGE “OPENTRANS”}

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

A. ENCRYPT

B. ALTGLOBAL

C. CREATE ROLE

D. ALTDB

Answer: C

Q3. You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can you treat these as identical tables?

A. No

B. Yes, if the source and target Oracle versions and character sets are the same.

C. Yes

D. Yes, as long as the source table has a primary key define

Answer: A

Explanation:

In reference guide, page 119, when replicating from identical sources to targets, the param ASSUMETARGETDEFS must be used, and the only with being with columns in different orders, the answer is NO

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

Answer: ABC

Explanation:

In reference guide, page 312, Syntax EVENTACTIONS ([STOP | ABORT | FORCESTOP][IGNORE [TRANSACTION [INCLUDEVENT]][DISCARD][LOG [INFO | WARNING]][REPORT][ROLLOVER][SHELL <command>][TRACE <trace file> [TRANSACTION] [PURGE | APPEND]][CHECKPOINT [BEFORE | AFTER | BOTH]][, ...])

Q5. You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (….), the best solution is .

A. Include the tranlogoptions (exclude user) parameter in each Extract parameter file

B. Use the add FILTERTABLE command at the GGSCI prompt

C. Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping

D. This feature is not supported in GoldenGate 10.

Answer: C

Explanation:

Reference:

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

Q6. 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

Answer: E

Explanation:

Reference:

http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-8-filtering-and-mapping- data/

Q7. How would you specify the data source for a secondary Extract functioning as a data pump?

A. EXTTRAILSOURCE

B. SOURCEISTABLE

C. SOURCEISTRAIL

D. LOCTRAILSOURC

Answer: A

Explanation: On page 293 of reference guide, EXTTRAILSOURCE is the parameter to specify data pump

Q8. 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

Answer: A

Explanation:

In reference guide, page 256, and I quote "If multiple groups are reading the same set of trail files, one process could purge a file before another is finished with it. Instead, use the Manager version of PURGEOLDEXTRACTS, which is the preferred use of the parameter in all GoldenGate configurations because it allows you to manage trail files in a centralized fashion."

Q9. Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.

B. The Extract will revert to single-row fetch mode for all tables.

C. The Extract will abend unless LOBMEMORY is increased.

D. The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Answer: A

Q10. Which utility is responsible for generating source data definitions files?

A. EMSCLNT

B. COBGEN

C. DDLGEN

D. DEFGEN

Answer: D

Explanation:

Reference:

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf