1Z0-947問題集、Oracle実際の試験問題

質問 1

What is the key purpose of GoldenGate trail files?

A. They are database auditing logs in which GoldenGate registers changes.

B. They are a persistent storage area for captured transactions.

C. They are checkpoint files for the GoldenGate processes.

D. They are configuration files for the GoldenGate processes.

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 2

You are receiving data errors involving invalid column mappings. Which two types of files can you use to identify the issue?

A. Use the error log because it captures information on failed GoldenGate operations.

B. Use the discard file because it captures information on failed GoldenGate operations.

C. Use the STATS command in the GLOBALS file because it captures information on failed GoldenGate operations.

D. Use the DIST command in the GLOBALS file because it captures information on failed GoldenGate operations.

正解: A,B

質問 3

Which database setting for the Oracle 19c database is required to enable Oracle GoldenGate?

A. ENABLE_STREAMS_REPLICATION=true

B. ENABLE_GOLDENGATE_REPLICATION=true

C. Configure the STREAMS_POOL_SIZE database parameter

D. ENABLE_DATABASE_REPLICATION=true

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 4

Where are the Oracle GoldenGate parameters officially documented?

A. Oracle Fusion Middleware Reference for Oracle GoldenGate 19c

B. Oracle Database Concepts Guide

C. GoldenGate GGSCI Command Reference

D. Oracle GoldenGate AdminClient Manual

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 5

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

A. Use the command option ATCSN.

B. Use the command option AFTERCSN.

C. Use the command option RESUME.

D. Use the command option UNTIL CANCEL.

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 6

What is the purpose of the DiscardFile?

A. To store Replicat cache

B. To backup configuration changes

C. To log failed operations Replicat couldn't process

D. To discard unused trail files

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 7

To display SQL DML statements before execution using a classic Replicat, what should you do?

A. Execute Detail On

B. None of the above

C. Execute ScanForRBA

D. Enable the ShowSyntax parameter

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 8

You can connect to the Receiver Server to manage (start and stop) the configured data paths.

A. FALSE

B. TRUE

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 9

Cache and queue statistic drill-downs are available for both Extract and Replicat groups.

A. FALSE

B. TRUE

正解: A

解説: (PassTest メンバーにのみ表示されます)

Oracle GoldenGate 19c Implementation Professional - 1Z0-947 模擬練習