Oracle 1Z0-481 Online Practice Questions and Exam Preparation

Oracle 1Z0-481 Online Questions & Answers

• Question 31:

  What GoldenGate process writes to RMTTRAILS?

  A. Server/Collector
  B. Extract
  C. Pump
  D. Replicat
  E. All of the above
  B. Extract

  ---

  Reference: http://hi.baidu.com/nich4/blog/item/19a3e81cad1ff7bb4bedbc50.html

• Question 32:

  Which database platform does GoldenGate not natively support?

  A. Sybase
  B. FoxPro
  C. DB2
  D. Teradata
  B. FoxPro

• Question 33:

  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?

  A. From the first Extract process
  B. From the Data Pump process
  C. From replicate process
  D. This feature is not supported in GoldenGate 10.
  A. From the first Extract process

  ---

  Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_upgrade_v104.pdf

• Question 34:

  You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (....), the best solution is______.

  A. Include the tranlogoptions (exclude user) parameter in each Extract parameter file
  B. Use the add FILTERTABLE command at the GGSCI prompt
  C. Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping
  D. This feature is not supported in GoldenGate 10.
  C. Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping

  ---

  Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 35:

  Which statement correctly describes GoldenGate Extract and Replicat process reports?

  A. By default process reports are named for the Extract or Replicat group and up to 99 old reports can be saved depending on the REPORTUM parameter.
  B. By default process reports are named for the Extract or Replicat group and up to 10 old reports are kept.
  C. Process reports take the name set by the optional report parameter of the ADD extract replicat command and up to 99 old reports can be saved depending on the REPORTNUM parameter.
  D. Process reports take the name set by the required report file parameters and up to 10 old reports will be saved.
  D. Process reports take the name set by the required report file parameters and up to 10 old reports will be saved.

  ---

  http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 36:

  How do you control the size of the buffer that contains data extracted from an ASM instance?

  A. TRANLOGOPTIONS ASMBUFSIZ
  B. DBOPTIONS ASMBUFSIZE
  C. TRANLOGOPTIONS BUFSIZE
  D. DBOPTIONS BUFSIZE
  A. TRANLOGOPTIONS ASMBUFSIZ

  ---

  Reference : http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 37:

  Which utility is responsible for generating source data definitions files?

  A. EMSCLNT
  B. COBGEN
  C. DDLGEN
  D. DEFGEN
  D. DEFGEN

  ---

  Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 38:

  Which OGG process (es) can change data in database?

  A. Replicat only
  B. Extract only
  C. Extract and Replicat
  D. Extract, Replicat and Manager
  C. Extract and Replicat

  ---

  Reference : http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 39:

  Where can you find a list of the parameters being used by a Replicat process?

  A. System logs
  B. Discard file
  C. Event log
  D. Process report
  D. Process report

  ---

  http://gjilevski.wordpress.com/2010/02/27/monitoring-processes-and-processing- status-in-oracle-goldengate/

• Question 40:

  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?

  A. Oracle GoldenGate Director
  B. Oracle GoldenGate Transactional Data Management
  C. Oracle GoldenGate veridata
  D. Oracle GoldenGate Monitor
  A. Oracle GoldenGate Director

  ---

  Oracle GoldenGate Director is the only tool for the job.

  Incorrect answer:

  There isn't a GoldenGate Monitor application