Tag: technology

Questions Related to technology

Which assembler routine used to obtain a formatted form of the SQLCA and a text message based on the SQLCODE field of SQLCA
technology mainframe

  1. SQLCA

  2. DCLGEN

  3. DSNTIAR

  4. SQLSTATE

Show answer
Correct Option: C

To allow DB2 to close a cursor after a commit or a rollback operation, we use the WITH HOLD option of the DECLARE CURSOR statement.

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

In the segemented table space each segment contain.
technology mainframe

  1. Can contain only one table but rows from different tables are mixed

  2. Can contain only one table but rows from different tables are not mixed

  3. Can contain more than one table but rows from different tables are mixed

  4. None of these

Show answer
Correct Option: D

Which DB2 Utility is used to declare Tables in cobol/DB2 programs
technology mainframe

  1. DCLGEN

  2. SQLCA

  3. SQLSTATE

  4. SQLCODE

Show answer
Correct Option: A

The performance of static SQL is better than dynamic SQL, because for static SQL the binding is done only once and the program can be executed many times

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

The SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time.
technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

You need to read data from three oracle tables that store sales data from three regions to load into a single oracle table. These three tables are having the same table definitions and the only difference is that each table contains data for a particular region. Which of the following will do the required task?
technology platforms and products

  1. Create a task with single oracle enterprise stage that executes a custom SQL statement with FETCH ALL, that outputs to an Oracle enterprise stage.

  2. Create a job with three Oracle Enterprise stages to read from the tables and output to a collector stage which in turn outputs the data to an Oracle Enterprise stage.

  3. Create a job with a single Oracle Enterprise stage that executes a custom SQL statement with UNION ALL that outputs the data to an oracle enterprise stage.

  4. Create a job with three Oracle Enterprise stages to read from the tables and output to a Funnel stage which in turn outputs the data to an oracle enterprise stage.

Show answer
Correct Option: C,D

How could repetition element identified on an XML input stage, which is processing an XML file?
technology platforms and products

  1. Auto detect by XML stage.

  2. Check the "Repetition Element Required" box on the output link tab.

  3. Set the key property for the column on the output link to 'Yes'

  4. Set the 'Nullable' property for the column on the output link to 'Yes'

Show answer
Correct Option: C

What can be used to derive values for the column 'JobName' that is to contain the name of the job that is running.
technology platforms and products

  1. Datastaage function

  2. Datastage Macro

  3. A system variable

  4. a link variable

Show answer
Correct Option: B

Which of the following is true to abort a job from within the Transformer stage?
technology platforms and products

  1. Call the DSLoggFatal function from a stage variable derivation

  2. Call the DSStopJob function from a stage or column derivation

  3. Use the SETENV function to set the environmental variable APT_PM_KILL_NOWAIT

  4. Create a dummy output link with a constraint that tests for the condition to abort on; set the 'Abort After rows' property to 1

Show answer
Correct Option: D