Free Oracle 1z1-481 Exam Dumps Questions & Answers

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.  New inserts will be processed without issue; updates and deletes will generate a "row not found" error.
• B.  Inserts will generate a primary key uniqueness violation; deletes will generate a 'no matching row' not found error; updates will continue forever.
• C.  Updates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation.
• D.  None: loop detection is on by default in Oracle.

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

• A.  SEND...CACHEMGR
• B.  SEND...REPORT
• C.  SEND...STATS
• D.  INFO...SHOWSTATS

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

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

When would you use the PASSTHRU parameter?

• A.  When Extract is processing database transaction logs where you have a remote database connection.
• B.  For a SPECIALRUN one-time processing task that is doing an initial load.
• C.  When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.
• D.  When using a data pump to distribute all of the trail data "as is" to a remote system.

Which parameter tells Extract the tables for which to capture changes?

• A.  Table
• B.  LOGTABLE
• C.  MAP C
• D.  LOG