1Z0-481 - Oracle GoldenGate 11g Certified Implementation Exam Essentials
Go back to Oracle
What three types of information are reported in discard file?
The details of the discarded records
The database error message
The trial file sequence number
Which parameters) would be used for one-time initial replicat?
What command is issued to alter Replicat to start processing trail number 10 at relative byte address 100345?
Alter <group>, extseqno 10, extrba 100345
Which three are required to correctly configure an OGG?
An extract process
A trail file identifier
Designation as local or remote
Ideally which process should be configured purge old trial files?
By default, which option is evaluated first, SQLEXEC or filter statement?
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?
Start the Extract task.
What is the default threshold for message compression in OGG?
Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?
SEND EXTRACT <group>, ROLLOVER
What parameter provides options for compression and encryption?
Where are GoldenGate macros defined?
Macros can be defined in the parameter file or included in a macro file
What file must be configured in order to use custom encryption keys?
Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete?
The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key.
Which statement correctly describes GoldenGate Extract and Replicat process reports?
Process reports take the name set by the required report file parameters and up to 10 old reports will be saved.
Which translations are captured if you ADD EXTRACT BEGIN now 1:00 p.m., but START EXTRACT at 2:00 p.m.?
Transactions started before 1:00 p.m and committed after 2:00 p.m.
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?
From the first Extract process
Which parameter tells Extract the tables for which to capture changes?
What is the GoldenGate command line interface?
In addition to using the parameter comment to enter remarks in parameter file(s) can be used?
Select the commands that give statistics regarding OGG process and memory resource usage.
Where can you find a list of the parameters being used by a Replicat process?
Which three are types of encryption supported by OGG?
Parameter file encryption
Trial file encryption
When would you use the PASSTHRU parameter?
When using a data pump to distribute all of the trail data "as is" to a remote system.
Which best describes the function of OGG user tokens?
Which utility is responsible for generating source data definitions files?
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
Will the sequence of operations be affected by changing transaction boundaries?
By default which type of operations are captured by extract?
Inserts, updates, and deletes
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?
The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
What GoldenGate facility allows for custom processing in response to a data value?
You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate manage process is running on port 7809. Your requirements include using a custom encryption key and advanced encryption standard (AES), and you have created an ENCKEYS file What parameters should you use?
RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY
You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?
Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.
Where is user token data stored?
You want to configure replication of CREATE TABLE statements from oracle to Teradata, so that only new table created in your mapped source schema is Replicated. Which should be the part of solution?
DDL INCLUDE MAPPED in extra parameter file.
When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture?
The middle-tier server must have a database installed on it
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?
You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (....), the best solution is______.
Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping
How do you control the size of the buffer that contains data extracted from an ASM instance?
What us expected behavior of CHEKPARMS parameter?
The process checks the parameter syntax and then stops.
What three are valid responsibilities of the OGG Manager?
Cleaning up GoldenGate trails.
Starting dynamic processes, such as Server Collectors, extracts, replicates.
Error and lag reporting.
What process is the recommended method to purge old GoldenGate trials?
You have source table with PRODUCT-ID column and target table with PRODUCT_DESCRIPTION. On the target database is a lookup table containing product codes and corresponding description. What is good way for you to lookup the product description for each transaction?
SQLEXEC ( )
Which parameter could you use to start an Extract when Manager starts?
When implementing GoldenGate on a 11gR2 Oracle database and after running the GoldenGate Database profiling script, you discover that certain objects are compressed, what should you do?
Configure OGG with Integrated Capture
What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?
ENCKEYS file in the GoldenGate installation location
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
Example 3 only
Which process (es) maintain a checkpoint file?
Both Extract and Replicat
What is GGSCI an acronym for?
GoldenGate software command interface
Which database platform does GoldenGate not natively support?
What Oracle GoldenGate feature provides recoverability without loss of transactions?
Which argument is used to set the maximum size of the EXTTRAIL or RMTTRAL.