最新的Oracle 1z0-481免費考試真題

問題1

You have source table with PRODUCT-ID column and target table with PRODUCT_DESCRIPTION. On the target database is a lookup table containing product codes and corresponding description. What is good way for you to lookup the product description for each transaction?

A. DBLOOKUP ( )

B. SQLLOOKUP ( )

C. DBLOGIN ()

D. SQLEXEC ( )

正確答案: D

說明：（僅 Fast2test 成員可見）

問題2

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

A. //

B. /*

C. -

D. \\

正確答案: C

問題3

You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?

A. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

B. Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.

C. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.

D. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題4

What could you use to formal 123456789 to format of social security number 123-456-789?

A. @strext () and @ strcat ()

B. @STRFIND ( )

C. @STRCAT ()

D. @STEXT ()

正確答案: A

說明：（僅 Fast2test 成員可見）

問題5

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

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

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

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

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

正確答案: C

說明：（僅 Fast2test 成員可見）

問題6

What is GGSCI an acronym for?

A. GoldenGate secure command interface

B. GoldenGate software command interface

C. GoldenGate software connection interface

D. GoldenGate secure connection interface

正確答案: B

說明：（僅 Fast2test 成員可見）

問題7

Which three describe a valid OGG Event Action?

A. Purge old trail files

B. Stop the process

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

D. Run a shell command

正確答案: B,C,D

說明：（僅 Fast2test 成員可見）

問題8

Where is user token data stored?

A. Discord file

B. Trail file

C. Report file

D. Parameter file

正確答案: B

說明：（僅 Fast2test 成員可見）

最新的Oracle GoldenGate 11g Certified Implementation Exam Essentials - 1z0-481免費考試真題

聯系我們

站內鏈接

最新更新