Tag: databases

Questions Related to databases

To maximize session performance by filter it should be?
technology databases

  1. Near to source

  2. Near to target

  3. Can be placed anywhere

  4. Session performance is not affected

Show answer
Correct Option: A

Which of the following transformation is passive and connected?
technology databases

  1. Aggregator

  2. Expression

  3. Joiner

  4. Filter

Show answer
Correct Option: B

Which of the following can be editable in mapping designer?
technology databases

  1. Source definition

  2. Target definition

  3. Source qualifier

  4. All of above

Show answer
Correct Option: C

Which transformation we will use if want to efficiently join two tables residing in same database?
technology databases

  1. Joiner

  2. Source Qualifier

  3. Both of above

  4. None of above

Show answer
Correct Option: B

When we group the data through aggregator it outputs which row of each group as default?
technology databases

  1. First

  2. Last

  3. Any

  4. None

Show answer
Correct Option: B

When we can use sorted input in aggregator?
technology databases

  1. When nested aggregate function are used in the aggregator expression

  2. Incremental aggregation is used in session

  3. In case of data driven source data

  4. None of above

Show answer
Correct Option: D

Which of the below transformation can be used as connected and unconnected both way?
technology databases

  1. Stored procedure, Look up

  2. Stored procedure, filter

  3. Look up , joiner

  4. Filter, Expression

Show answer
Correct Option: A

Which of the following task can be made reusable?
technology databases

  1. Session

  2. Command

  3. Email

  4. All of the above

Show answer
Correct Option: D

Which statement is true regarding sequence generator?
technology databases

  1. It is having two ports nextval and currval

  2. We can add ports in it

  3. It is active and connected

  4. All of the above

Show answer
Correct Option: A

Which of the following port is used only in unconnected look up not in connected look up?
technology databases

  1. Input

  2. Variable

  3. Return

  4. Output

Show answer
Correct Option: C