Mock-Test Window

1 :-

Which Replicat MAP parameter and syntax should be used to detect an update conflict on the EURO.SEAT_RESV table and resolve the conflict by determining which record has the oldest LAST_UDATE value?

2 :-

Which syntax would you use in an OBEY script to stop a process without waiting for user input?

Stop * Noinput Stop Immediate * Stop * ! Stop Force *

3 :-

What is a valid net result for an Extract configured with the following parameters in this order: getinserts, getupdatebefores, ignoredeletes, ignoreupdates?

Inserts Updates And Deletes Will Be Captured. Before And After Images Of Updates Will Be Ignored. Inserts And Deletes Will Be Captured. Before And After Images Of Updates Will Be Captured.

4 :-

You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this?

5 :-

You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts. How should you accomplish this?

Use The Compcols With The Getupdatebefores Option Of The Map Parameter In The Replicat Parameter File To Specify Columns That Are To Be Used With Before Values In The Replicat Where Clause. Use The Comparecols Option Of The Map Parameter In The Replicat Parameter File To Specify Columns That Are To Be Used With Before Values In The Replicat Where Clause. Use The Getupdatebefores Option Of The Map Parameter In The Replicat Parameter File To Specify Columns That Are To Be Used With Before Values In The Replicat Where Clause. Use The Getbeforecols Option Of The Map Parameter In The Replicat Parameter File To Specify Columns That Are To Be Used With Before Values In The Replicat Where Clause.

6 :-

Which transactions are captured if you ADD EXTRACT with BEGIN NOW at 1:00 PM, START EXTRACT at 2:00 PM?

Transactions That Started At Or After 1:00 Pm Transactions That Started Before 1:00 Pm And Committed After 2:00 Pm Only Transactions That Started Before 1:00 Pm And Committed After 1:00 Pm Only Transactions That Started At Or After 2:00 Pm

7 :-

You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft?

Implement Trail File Encryption. Ensure That Passwords Are Encrypted Ensure That Network Communications Are Encrypted Ensure That Table-level Transparent Data Encryption Is Implemented.

8 :-

If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

Manager Replicat Extract Extract And Replicat

9 :-

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

Oracle Goldengate For Big Data Oracle Goldengate Application Adapters Oracle Goldengate Veridata Oracle Data Integrator Adapters

10 :-

You want to reduce an Integrated Extract’s startup time by using an existing data dictionary. How should you accomplish this?

Set The Shared Memory Realm Of An Integrated Extract With Other Integrated Extracts. Use The Share Option Of The Register Extract Command. Share The Registration Id With Other Integrated Extracts. Begin The Extract Processing At The Earliest Scn Of The Log Stream.

11 :-

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

Oracle Gateway Software Configured For That Particular Database Platform Jdbc Drivers Into The Goldengate Home Directory Microsoft Visual C++ 2010 Sp1 Redistributable Package Nothing Configure Goldengate Jagent For That Particular Database Platform.

12 :-

You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?

Start The Extract Task. Start The Extract Task Wait For It To Stop And Then Start The Replicat Task. Start The Extract Task And Then Start The Replicat Task Start The Replicat Task.

13 :-

Which other character, besides the COMMENT parameter, can you use to enter remarks in a parameter file?

\\ // - - \*

14 :-

You need to manually patch Oracle GoldenGate source and targets. How should you proceed?

Stop Access To The Source Database. Allow Extract To Finish Capturing The Transaction Data That Remains In The Transaction Log And Stop Extract. Start Applying The Patch On The Source. Wait Until The Data Pump (if Used) And Replicat Are Finished Processing The Data In Their Respective Trails. Stop The Data Pump And Replicat. Apply The Patch On The Target. If The Patches Changed Table Definitions Run Defgen For The Source Tables To Generate Updated Source Definitions And Then Replace The Old Definitions With The New Ones In The Existing Source Definitions File On The Target System. Start The Oracle Goldengate Processes Whenever You Are Ready To Begin Capturing User Activity Again. Stop Access To The Source Database. Allow Extract To Finish Capturing The Transaction Data That Remains In The Transaction Log And Stop Extract. Start Applying The Patch On The Source And On The Target. Start The Oracle Goldengate Processes Whenever You Are Ready To Begin Capturing User Activity Again. Stop Access To The Source And Target Databases. Allow Extract To Finish Capturing The Transaction Data That Remains In The Transaction Log And Stop Extract. Start Applying The Patch On The Source. Wait Until The Data Pump (if Used) And Replicat Are Finished Processing The Data In Their Respective Trails. Stop The Data Pump And Replicat. Apply The Patch On The Target. Start The Oracle Goldengate Processes Whenever You Are Ready To Begin Capturing User Activity Again Stop Access To The Source And Target Databases. Start Applying The Patch On The Source. Stop The Data Pump And Replicat. Apply The Patch On The Target. Start The Oracle Goldengate Processes Whenever You Are Ready To Begin Capturing User Activity Again.

15 :-

Which two statements, if either were true, would make the code compile? (Choose two.)

Motorcycle Is An Interface That Implements The Cycle Class. Cycle Is An Interface That Is Implemented By The Motorcycle Class. Cycle Is An Abstract Superclass Of Motorcycle. Cycle And Motorcycle Both Extend The Transportation Superclass. Cycle And Motorcycle Both Implement The Transportation Interface. Motorcycle Is A Superclass Of Cycle.

16 :-

You have a source table with a PRODUCT_ID column and a target table with PRODUCT_DESCRIPTION column. On the target database, there is a lookup table containing product codes and corresponding descriptions.What should you use to look up the PRODUCT_DESCRIPTION for each transaction?

Sqlexec ( ) Dblookup ( ) Dblogin ( ) Sqllookup ( )

17 :-

Identify the correct statement regarding Trails.

Extract And Pump Are Different Os Level Executable Binary Files. Extracts Cannot Perform Filtering Mapping And Transformations. Rmttrail Is For Remote Trails And Exttrail Is For Local Trails. Extract Is Typically Used To Produce Local Trail Files Over A Tcp/ip Connection.

18 :-

Your GoldenGate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version. How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key?

Goldengate Deployments Cannot Use A Shared Wallet. View The Goldengate Log Files To Monitor Replicat Report Files To Verify That The Scn Was Applied By All Replicat Groups. View The Report File Of The Newest Extract After Renewing The Master Key To Confirm The Last Scn That Was Mined With Old Key View The Report File Of Each Extract Immediately After Renewing The Master Key To Confirm The Last Scn That Was Mined With The Old Key. Then Monitor The Replicat Report Files To Verify That This Scn Was Applied By All Replicat Groups.

19 :-

You want to eliminate the reporting output from processing a Macro. How should you proceed?

Use The Optional Parameter Nolist. Use The Optional Parameter Unlist. Use The Optional Parameter Noreport. Use The Optional Parameter Nomacrooutput.

20 :-

Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?

View The Maybe Out-of-sync (moos) Queue. View The Veridata Log File. View The Veridata Log File. View The Confirm-out-of-sync (coos) Queue. View The Veridata Agent Repository.

Oracle golden gate 12c implementation essentials Quiz

🏅