1z0-447: Oracle GoldenGate 12c Implementation Essentials Extract Practice Questions
The free 1z0-447: Oracle GoldenGate 12c Implementation Essentials questions that deal with extract, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #5
Which parameter could you use to start an Extract when Manager starts?
Correct answer: C
Explanation
AUTOSTART in the Manager parameter file tells Manager to start the named Extract or Replicat groups automatically whenever Manager starts.
Question #6
For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?
Correct answer: C
Explanation
For Sybase, Oracle GoldenGate Extract manages both the primary and the secondary truncation points on the source database. Teradata, Informix and DB2 do not use this mechanism.
Question #8
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?
Correct answer: A
Explanation
When an array fetch meets a table containing LOB data, Extract silently drops to single-row fetch for those rows and returns to batch fetching afterwards, so the load still completes without an abend.
Continue with 1z0-447: Oracle GoldenGate 12c Implementation Essentials
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in 1z0-447: Oracle GoldenGate 12c Implementation Essentials, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
All 1z0-447: Oracle GoldenGate 12c Implementation Essentials practice questions →