Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-481

Oracle 1z0-481 Exam Practice Questions (P. 4)

  • Full Access (79 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
How do you control the size of the buffer that contains data extracted from?
  1. A
    TRANLOGOPTIONS ASMBUFSIZE
  2. B
    DBOPTIONS ASMBUFSIZE
  3. C
    TRANLOGOPTIONS BUFSIZE
  4. D
    DBOPTIONS BUFSIZE

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

Question #17
What three are valid responsibilities of the OGG Manager?
  1. A
    Cleaning up GoldenGate trails.
  2. B
    Starting dynamic processes, such as Server Collectors, extracts, replicates.
  3. C
    Error and lag reporting.
  4. D
    Communicating with other GoldenGate Manager processes

Correct Answer:
ABC
References:

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

Correct Answer:
B

Question #19
What three types of information are reported in discard file?
  1. A
    The details of the discarded records
  2. B
    The database error message
  3. C
    The trial file sequence number
  4. D
    Runtime statistics

Correct Answer:
ABC
References:

Question #20
Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?
  1. A
    ALTER EXTTRAIL <trail name>, NEXTSEQNO
  2. B
    ALTER EXTTRAIL <trail name>, ROLLOVER
  3. C
    SEND EXTRACT <group>, ETROLLOVER
  4. D
    SEND EXTRACT <group>, ROLLOVER

Correct Answer:
D
In reference guide, page 36:Syntax SEND EXTRACT <group name>, {CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |
FORCETRANS <ID> [THREAD <n>] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER |SHOWTRANS [<ID>] [THREAD <n>] [COUNT <n>]
[DURATION <duration><unit>] [TABULAR][FILE <name> [DETAIL]] |SKIPTRANS <ID> [THREAD <n>] [FORCE]STATUS |STOP |TLTRACE {DEBUG | OFF |
<level>} [DDLINCLUDE | DDL[ONLY]] [FILE] <file name> |TRACE[2] <tracefile> |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS
{PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS} |TRANLOGOPTIONS TRANSCLEANUPFREQUENCY <minutes> |
VAMMESSAGE "<Teradata command>" |VAMMESSAGE {"ARSTATS" | "INCLUDELIST [filter]" | "EXCLUDELIST [filter]"} |VAMMESSAGE "OPENTRANS"}

Previous Questions Next Questions

All Pages