• databases Online Quiz - 41
Back
0

databases Online Quiz - 41

Description: databases Online Quiz - 41
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

How the monitor program should be written

technology databases

  1. A monitor program which dispatch the events to the callback of the one of the member

  2. Monitor object with it's own callback function

  3. A monitor program which dispatch the events to the callback of the member of

  4. None

Show answer
Correct Option: B

The maximum number of action tokens that a fault tolerance member callback function can receive
technology databases

  1. 1

  2. 2

  3. 3

  4. 5

Show answer
Correct Option: C

If CM Sender sends message to a ordinary listener which of the following will happen?
technology databases

  1. listener discards the labelled part of the message but process the data

  2. listener discards the Sequence no of the first message

  3. listener listens the labelled message and confirms it

  4. listener doesn't listen for the message at all

Show answer
Correct Option: A

Q1,Q2,Q3 are three diff Queues which are in a queue group with same pririty in each of the queue. there are two events in each of the queues. Whcih one of the following will happen?
technology databases

  1. Q1, Q2 will have one event each and Q3 don't have any events

  2. Q2, Q3 will have one events each and Q1 don't have any events

  3. Q1, Q2 won't have any events and Q3 will have 2 events

  4. the scenario is unpredictable

Show answer
Correct Option: D

The callback function of a timer with an interval of 5 seconds, sleeps for a period of 20 seconds. The timer events are dispatched in three threads .A statement at the start of the callback function prints out a message to the screen. What is the time difference between two consecutive messages output to the screen ?
technology databases

  1. 5s

  2. 20s

  3. 25s

  4. 10s

Show answer
Correct Option: A

The callback function of a timer with an interval of 5 seconds, sleeps for a period of 20 seconds. The timer events are dispatched in a single thread .A statement at the start of the callback function prints out a message to the screen. What is the time difference between two consecutive messages output to the screen ?
technology databases

  1. 5s

  2. 25s

  3. 10s

  4. 20s

Show answer
Correct Option: D

What are the parameters for creating a timer event object ? Choose 3.

technology databases

  1. queue

  2. callback

  3. interval

  4. transport

Show answer
Correct Option: A,B,C

Choose the two similar scenarios out of the following :

technology databases

  1. poll and timed dispatch of 0

  2. dispatch and timed dispatch of –1

  3. poll and timed dispatch of –1

  4. dispatch and timed dispatch of 0

Show answer
Correct Option: A,B

The following are the fields of a message. Which field will be removed when you remove field by giving field name A and field instance 2 ? Field name Field value Field id A “default” 0 A “abc” 1 A “1,2,3,4” 2
technology databases

  1. All occurrences of field A

  2. 2nd occurrence of field A

  3. 2nd element of the array in the third occurrence

  4. None

Show answer
Correct Option: B

Which three statements are true about File Sets? (Choose three.)

technology databases

  1. File sets are partitioned.

  2. File sets are unpartitioned.

  3. File sets are stored as a single file.

  4. File sets are readable by external applications.

Show answer
Correct Option: A,D

Which three lookup types may be performed in the Lookup stage? (Choose three.)
technology databases

  1. Equality match

  2. Negative match

  3. Range on stream link

  4. Range on the reject link

Show answer
Correct Option: A,C,D

You are working on a job in which a sequential file cannot be read in parallel. In an attempt to improve job performance, you first define a single large string column for the non-parallel sequential file read. Which stage may be used to parse the large string in parallel?

technology databases

  1. The Column Import stage

  2. The Column Export stage

  3. The Make Vector stage

  4. The Split Vector stage

Show answer
Correct Option: A

What is the lowest CPU cost partitioning method for parallel stage to parallel stage?

technology databases

  1. Range

  2. Modulus

  3. Entire

  4. Same

Show answer
Correct Option: D

A DataStage job is sourcing a flat file which contains a VARCHAR field. This field needs to be mapped to a target field which is a date. Which will accomplish this?
technology databases

  1. Use a Column Exporter to perform the type conversion.

  2. DataStage handles the type conversion automatically

  3. Use the TimestampFromDateTime function in a Transformer.

  4. Use the Modify stage to perform the type conversion.

Show answer
Correct Option: D

Which Oracle Enterprise stage read property can be set using db options to tune job performance?
technology databases

  1. memsize

  2. arraysize

  3. partitionsize

  4. transactsize

Show answer
Correct Option: B

Which import option can be used to import metadata from a data modeling tool such as Erwin or Rational Data Architect?
technology databases

  1. Import using bridges.

  2. Import a table definition using the Connector wizard.

  3. Import DataStage components.

  4. Import a table definition using the Plug-In Meta Data facility.

Show answer
Correct Option: A

You need to invoke a job from the command line that is a multi-instance enabled. What is the correct syntax to start a multi-instance job?
technology databases

  1. dsjob -run -mode NORMAL -instance

  2. dsjob -run -mode NORMAL -wait -instance

  3. dsjob -run -mode NORMAL .

  4. dsjob -run -mode MULTI .

Show answer
Correct Option: C

Which three property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose three.)
technology databases

  1. Define the connection properties to an ODBC data source.

  2. Define columns for the output link.

  3. Specify properties for the input link.

  4. Define columns for the input link data.

Show answer
Correct Option: A,C,D

Which two system variables/techniques must be used in a parallel Transformer derivation to generate a unique sequence of integers across partitions? (Choose two.)

technology databases

  1. @INROWNUM+1

  2. @INROWNUM

  3. @PARTITIONNUM

  4. @NUMPARTITIONS

Show answer
Correct Option: C,D

Which action produces the most accurate Table Definitions for usage with the Oracle Enterprise stage?
technology databases

  1. Use import "Oracle Table Definitions" .

  2. Use import "Via bridges".

  3. Use import "Plug-in Meta Data Definitions".

  4. Use import "Orchestrate Schema Definitions" using orchdbutil.

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 physics
550 Quizzes
11687 Questions
 history
1132 Quizzes
13047 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions