Oracle 1Z0-481 Online Practice Questions and Exam Preparation

Oracle 1Z0-481 Online Questions & Answers

• Question 21:

  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?

  A. No
  B. Yes, if the source and target Oracle versions and character sets are the same.
  C. Yes
  D. Yes, as long as the source table has a primary key define
  A. No

  ---

  In reference guide, page 119, when replicating from identical sources to targets, the param ASSUMETARGETDEFS must be used, and the only with being with columns in different orders, the answer is NO

• Question 22:

  Which parameters) would be used for one-time initial replicat?

  A. PASSTHRU
  B. SOURCEISFILE
  C. CHECKMINUTES
  D. SOURCEISTABLE
  E. SPECIALRUN
  E. SPECIALRUN

  ---

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

• Question 23:

  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?

  A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
  B. The Extract will revert to single-row fetch mode for all tables.
  C. The Extract will abend unless LOBMEMORY is increased.
  D. The Extract will perform poorly due to paging unless LOBMEMORY is increased.
  A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.

• Question 24:

  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?

  A. This feature is not supported in oracle goldenGate 10.
  B. DDL INCLUDE MAPPED in extra parameter file.
  C. DDL INCLUDE UNMAPPED in extra parameter file.
  D. DDL EXCLUDE MAPPED in extra parameter file.
  B. DDL INCLUDE MAPPED in extra parameter file.

  ---

  DDL INCLUDE MAPPED in extra parameter file. This means that DDL support is now enabled for all tables which have been mapped

  Reference : http://gjilevski.wordpress.com/2010/02/19/configuring-ddl-synchronization-with-oracle-goldengate/

• Question 25:

  What could you use to formal 123456789 to format of social security number 123-456-789?

  A. @STRCAT ()
  B. @STEXT ()
  C. @strext () and @ strcat ()
  D. @STRFIND ( )
  C. @strext () and @ strcat ()

  ---

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

• Question 26:

  Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

  A. ALTER EXTTRAIL , NEXTSEQNO
  B. ALTER EXTTRAIL , ROLLOVER
  C. SEND EXTRACT , ETROLLOVER
  D. SEND EXTRACT , ROLLOVER
  D. SEND EXTRACT , ROLLOVER

  ---

  In reference guide, page 36:Syntax SEND EXTRACT , {CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS [THREAD ] [FORCE] |GETLAG |GETTCPSTATS |LOGEND | REPORT |ROLLOVER |SHOWTRANS [] [THREAD ] [COUNT ][DURATION ] [TABULAR][FILE [DETAIL]] |SKIPTRANS [THREAD ] [FORCE]STATUS |STOP |TLTRACE {DEBUG | OFF | } [DDLINCLUDE | DDL[ONLY]] [FILE] |TRACE[2] |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS {PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS} |TRANLOGOPTIONS TRANSCLEANUPFREQUENCY |VAMMESSAGE "" |VAMMESSAGE {"ARSTATS" | "INCLUDELIST [filter]" | "EXCLUDELIST [filter]"} |VAMMESSAGE "OPENTRANS"}

• Question 27:

  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
  C. DYNAMICPORTLIST

• Question 28:

  Which could be used to map a value stored in a user token to a target column?

  A. @GETENV
  B. GGHEADER
  C. GGENVIRONMENT
  D. ㏕OKEN
  D. ㏕OKEN

  ---

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

• Question 29:

  In GoldenGate terms, what is the definition of Extract lag?

  A. The difference in time between when a change is made to source data and when that change is reflected in the target data.
  B. The difference in time between the current times at the target system.
  C. The difference in time between when a change record is received at the target system and when the change is reflected in the target data.
  D. The difference in time between when a change record is processed by the extract and the timestamp of the record in the data source.
  D. The difference in time between when a change record is processed by the extract and the timestamp of the record in the data source.

  ---

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

• Question 30:

  Which GGSCI command(s) show all available information on both read and write checkpoint for an Extract?

  Example: 1 INFO EXTRACT

  Example: 2 INFO EXTRACT , DETAIL

  Example: 3 INFO EXTRACT , SHOWCH

  A. Example 2 only
  B. Example 3 only
  C. Examples 1 and 3
  D. Examples 1 and 2
  B. Example 3 only

  ---

  Reference : http://jianmingli.com/wp/?p=1532