Select the function that stores environmental values.
AGGENVIRONMENT
B@COLGEN
C@GETENV
DETOKEN
Select the commands that give statistics regarding OGG process and memory resource usage.
ASEND…REPORT
BSEND…STATS
CSEND...CACHEMGR
DINFO…SHOWSTATS
Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicate with a lag over 60 minutes?
ALAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60
BLAGREPORTMINUTES 60, LAGINFOHOURS 1
CLAGREPOBT 1, I.AGCRITICALHOURS 1
DLAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I
What parameter provides options for compression and encryption?
ARMTHOST
BTARGET
CTCPIP
DTARGET DB
Question 6
Oracle GoldenGate Architecture and Components
0
Question 7
Monitoring and Managing Oracle GoldenGate Processes
Question 8
Installation and Configuration
Question 9
Troubleshooting and Tuning
Question 10
Oracle GoldenGate Architecture and Components
Question 11
Troubleshooting and Tuning
Question 13
Oracle GoldenGate Architecture and Components
Question 14
Conflict Detection and Resolution
Question 15
Troubleshooting and Tuning
Question 16
Monitoring and Managing Oracle GoldenGate Processes
Question 17
Data Synchronization
Question 18
Troubleshooting and Tuning
Question 19
Oracle GoldenGate Architecture and Components
Question 20
Oracle GoldenGate Architecture and Components
Question 21
Monitoring and Managing Oracle GoldenGate Processes
Question 22
Troubleshooting and Tuning
Question 23
Installation and Configuration
Question 24
Troubleshooting and Tuning
Question 25
Monitoring and Managing Oracle GoldenGate Processes
Question 26
Oracle GoldenGate Architecture and Components
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ad
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
What GoldenGate process is responsible for capturing changes in the source database?
AManager
BReplicate
CExtract
DServer Collector
You have configured and added the extract and Replicate tasks using the direct load method what do you need to do to get the processes up and running?
AStart the Extract task.
BStart the Extract task and then start the Replicat task.
CStart the Extract task; wait for it to stop and than start the Replicate task.
DStart the Replicate task
You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can you treat these as identical tables?
ANo
BYes, if the source and target Oracle versions and character sets are the same.
CYes
DYes, as long as the source table has a primary key define
What us expected behavior of CHEKPARMS parameter?
AThe process checks the parameter syntax and then starts running.
BThe process checks the parameter syntax and then stops.
CA report file is created listing all missing parameters.
DA report file is created listing all default values not specified in the parameter file.
What GoldenGate facility allows for custom processing in response to a data value?
ADDLGEN
BGGSExec
CUser Exits
DUser Tokens
How do you control the size of the buffer that contains data extracted from an ASM instance?
ATRANLOGOPTIONS ASMBUFSIZ
BDBOPTIONS ASMBUFSIZE
CTRANLOGOPTIONS BUFSIZE
DDBOPTIONS BUFSIZE
What three are valid responsibilities of the OGG Manager?
ACleaning up GoldenGate trails.
BStarting dynamic processes, such as Server Collectors, extracts, replicates.
CError and lag reporting.
DCommunicating with other GoldenGate Manager processes
You have implemented multi-master Oracle/Oracle replication without a provision to exclude transactions committed by a Replicat process. What errors are likely to occur?
AInserts will generate a primary key uniqueness violation; deletes will generate a ‘no matching row’ not found error; updates will continue forever.
BNone: loop detection is on by default in Oracle.
CNew inserts will be processed without issue; updates and deletes will generate a "row not found" error.
DUpdates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation.
What three types of information are reported in discard file?
AThe details of the discarded records
BThe database error message
CThe trial file sequence number
DRuntime statistics
Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?
AALTER EXTTRAIL <trail name>, NEXTSEQNO
BALTER EXTTRAIL <trail name>, ROLLOVER
CSEND EXTRACT <group>, ETROLLOVER
DSEND EXTRACT <group>, ROLLOVER
To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANSOPS what is the most important thing Carlos should consider before using MAXTRANSOPS
AWill business logic be lost if transaction boundaries are changed?
BWill a large number of small commits perform better than a smaller number of large commits?
CWill redo buffer size on the target database be adequate for the commit size?
DWill the sequence of operations be affected by changing transaction boundaries?
In GoldenGate terms, what is the definition of Extract lag?
AThe difference in time between when a change is made to source data and when that change is reflected in the target data.
BThe difference in time between the current times at the target system.
CThe difference in time between when a change record is received at the target system and when the change is reflected in the target data.
DThe difference in time between when a change record is processed by the extract and the timestamp of the record in the data source.
Which OGG process (es) can change data in database?
AReplicat only
BExtract only
CExtract and Replicat
DExtract, Replicat and Manager
You have a source installation of OGG l0 that includes an initial extract and datapump to provide a remote trail formatted for a GoldenGate 9.5 Replicat process to consume, which process should be use to convert the data to the earlier format?
AFrom the first Extract process
BFrom the Data Pump process
CFrom replicate process
DThis feature is not supported in GoldenGate 10.
You are responsible for replication between your central office and twelve regional nodes. What is the best product for you to use to actively monitor thirteen
GoldenGate TDM instances and configure email alerts based on process status?
AOracle GoldenGate Director
BOracle GoldenGate Transactional Data Management
COracle GoldenGate veridata
DOracle GoldenGate Monitor
Which GGSCI command(s) show all available information on both read and write checkpoint for an Extract?
Example: 1 INFO EXTRACT <group name>
Example: 2 INFO EXTRACT <group name>, DETAIL
Example: 3 INFO EXTRACT <group name>, SHOWCH
AExample 2 only
BExample 3 only
CExamples 1 and 3
DExamples 1 and 2
How would you specify the data source for a secondary Extract functioning as a data pump?
AEXTTRAILSOURCE
BSOURCEISTABLE
CSOURCEISTRAIL
DLOCTRAILSOURC
In order to add delete Replicat processes without specifying a checkpoint table, Gerald has edited the GLOBALS parameter file. To get the change to take effect,
Gerald exits from the GGSCI command line, but GGSCI fails to restart. Which solution Is most likely to solve Geralds problem
AUse a text editor to check the GLOBALS file for syntax errors and fix them
BUse the cleanup replicat command
CVerify that Oracle environment variables are set correctly
DAdd the Oracle GoldenGate Installation directory to the system PATH
Where can you find a list of the parameters being used by a Replicat process?