1Z1-947 by Oracle Actual Free Exam Questions And Answers

Question 1

What command is used to create the checkpoint table on the target database?

A. CREATE TABLE CHECKPOINT

B. INIT CHECKPOINTTABLE

C. ADD CHECKPOINTTABLE

D. CONFIGURE CHECKPOINT TABLE

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

User exits can be used for tables processed by a data pump Extract in passthru mode.

A. FALSE

B. TRUE

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

Where can you view Oracle GoldenGate command syntax?

A. Command Line Interface Reference

B. Data Dictionary Views

C. SQL*Plus Guide

D. AWR Report

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

You must provide credentials, like a username and password, to access the database credentials store where the actual user credentials are stored. The credential store is preferable to using the database username and password in the commands or the parameter file. What may you use rather than a user ID and password, in the parameter file, for the Extract or Replicat to provide credentials for access to the source or target database?

A. UserIDAlias

B. UserReplicationUser

C. Oracle SID

D. Single Sign On

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

Where can Oracle GoldenGate software be downloaded officially?

A. Oracle Cloud Marketplace

B. Oracle Database Utilities

C. OTN or http://edelivery.oracle.com

D. My Oracle Support

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which formats can extract trails be written in?

A. Only Canonical and SQL

B. Canonical, LCR, Text (ASCII/UTF), SQL, XML

C. Binary, CSV, JSON

D. LOB, RAW, JSON

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

You are concerned that the process report generation in your production environment will become too large and not contain useful statistics.

A. GoldenGate automatically generates a new report when the processes start.

B. Use the ADD EXTTRAIL command option MEGABYTES.

C. Use the parameter REPORTROLLOVER.

D. Use the parameter REPORT.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

What is GGSCI in Oracle GoldenGate?

A. GUI-based replicat monitor

B. Extract checkpoint viewer

C. Command interpreter for managing GG processes

D. Report generation engine

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

Identify the scenario in which you cannot configure GoldenGate.

A. Real-time Change Data Capture from transaction logs

B. Snapshot database backups

C. Batch Data Transfer from table data

D. Initial Load synchronization

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle GoldenGate 19c Implementation Professional - 1Z1-947 Exam Practice Test

Contact Us

Useful Links

Latest Updated