Tag: technology

Questions Related to technology

Which of the following is true for delete?
technology programming languages

  1. Delete statement can be given without writing where clause.

  2. We can delete two tables simultaneously

  3. Both a & b

  4. None of the above

Show answer
Correct Option: A

How do you rename a table ?

technology programming languages

  1. alter table table_name rename to new_table_name;

  2. RENAME table_name new_table_name;

  3. Dropping the table and creating once again

  4. None of the above.

Show answer
Correct Option: A

Cache files contains

technology web technology

  1. *.idx and *.bat

  2. *.idx and *.dat

  3. *.che and *.txt

  4. *.dat and *.err

Show answer
Correct Option: B

Name of the port created automatically while working with dynamic cache
technology web technology

  1. NewLkpRow

  2. NewRow

  3. NewLookupRow

  4. No ports were created

Show answer
Correct Option: C

A Router transformation has the following types of groups

technology web technology

  1. Input Group, Output Group

  2. Input Group,Output Group, Default Group

  3. Output Group, Default Group, User Defined Group

  4. No groups were created

Show answer
Correct Option: A

A Sorter Transformation is

technology web technology

  1. Active Transformation

  2. Passive Transformation

  3. None

  4. Both

Show answer
Correct Option: A

A UNION Transformation is
technology web technology

  1. Active Transformation

  2. Passive Transformation

  3. None

  4. Both

Show answer
Correct Option: A

A mapping is created with a flatfile Target. Options to change the flatfile delimiter
technology web technology

  1. Session

  2. Session/Mapping

  3. Target Definition/Session

  4. Not possible to change

Show answer
Correct Option: C

What is the out put of Joiner Transformation, if we use Detail Outer Join

technology web technology

  1. All the rows from master and detail table

  2. Matching rows from detail table and all rows from master table

  3. Matching rows from master table and all rows from detail table

  4. Only matching from master and detail table

Show answer
Correct Option: B

Informatica 8x is
technology web technology

  1. Server Oriented Architecture

  2. Service Oriented Architecture

  3. Application Oriented Architecture

  4. Web based Architecture

Show answer
Correct Option: B