Testking provides all of the Oracle certification exam preparation materials. In the event you have passed the Oracle 1z0-481 exam right after using our products, youll be able to choose to have other certification exam dumps up coming time with a discounted price. Acquire your own Oracle 1z0-481 exam products today as well as pass the exam tomorrow! 99% passing rate as well as 100% money back if fail. Having Testkings Oracle 1z0-481 training study course is a one-stop solution to the Oracle certification. Join our training team and get certified soon together with the Oracle Oracle exam questions and answers. There is never a cheaper means like this specific to get through your Oracle 1z0-481 exam. Frequent updated Oracle Oracle practice exams can also be available at Testking.com. No a lot more charges, ever.

2016 Aug 1z0-481 test question

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

A. Replicat only

B. Extract only

C. Extract and Replicat

D. Extract, Replicat and Manager

Answer: C

Explanation: 

Reference :

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


Q2. If your system has a firewall controlling port access which parameter can be used to control ports used for GoldenGate processes?

A. CHILDPORTS

B. ALLOWEDPORTS

C. DYNAMICPORTLIST

D. GETPORTINFO

Answer: C


Q3. 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?

A. LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60

B. LAGREPORTMINUTES 60, LAGINFOHOURS 1

C. LAGREPOBT 1, I.AGCRITICALHOURS 1

D. LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I

Answer: B

Explanation: 

Reference :

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


Q4. Which three types of information are stored in the GoldenGate trial header?

A. Before or after image indicator

B. Data type (e.g. integer, alphanumeric)

C. Relative byte address of the commit record

D. Time of the transaction

Answer: ABC

Explanation:

Reference:

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


Q5. By default which type of operations are captured by extract?

A. Inserts, updates, deletes, and table operations such as CREATE TABLE

B. Inserts, compresses, and updates

C. Inserts, updates, deletes, and table operations such as ADD COLUMN

D. Inserts only

E. Inserts, updates, and deletes

Answer: E

Explanation:

Reference:

http://www.labo-oracle.com/Presentation-of-Oracle-GoldenGate


1z0-481  exam cram

Up to the immediate present 1z0-481 exam engine:

Q6. Select the commands that give statistics regarding OGG process and memory resource usage.

A. SEND…REPORT

B. SEND…STATS

C. SEND...CACHEMGR

D. INFO…SHOWSTATS

Answer: C


Q7. 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?

A. Inserts will generate a primary key uniqueness violation; deletes will generate a ‘no matching row’ not found error; updates will continue forever.

B. None: loop detection is on by default in Oracle.

C. New inserts will be processed without issue; updates and deletes will generate a “row not found” error.

D. Updates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation.

Answer: B


Q8. Where is user token data stored?

A. Trail file

B. Parameter file

C. Discord file

D. Report file

Answer: A

Explanation:

Reference:

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


Q9. 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.

Answer: D


Q10. What GoldenGate process writes to RMTTRAILS?

A. Server/Collector

B. Extract

C. Pump

D. Replicat

E. All of the above

Answer: B

Explanation:

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