Tag: softskills

Questions Related to softskills

To cross a street at a place other than a regular crossing or in a heedless manner is known as
softskills communication

  1. Paedestrian walk

  2. Jaywalk

  3. Monkey crossing

  4. Zebra Crossing

Show answer
Correct Option: B

Sorted Input in aggregator transformation improves the session performance
softskills teamwork

  1. True

  2. False

Show answer
Correct Option: A

When we enable the dynamic lookup cache then the designer adds port "NewLookupRow"
softskills teamwork

  1. True

  2. False

Show answer
Correct Option: A

what are the $,$$,$$$ symbols in informatica?
softskills teamwork

  1. Session Parameter,mapping Parameter,System variable

  2. System variable,Session Parameter,mapping Parameter

  3. System variable,mapping Parameter,Session Parameter

  4. None of above

Show answer
Correct Option: A

what are the two modes of data movement in infomatica?
softskills teamwork

  1. Normal,Large

  2. Simple,Large

  3. Normal,Bulk

  4. none of above

Show answer
Correct Option: C

what are the lookup caches?
softskills teamwork

  1. Static Cache

  2. Dynamic Cache

  3. Persistant Cache

  4. Shared Cache

  5. All the Above

Show answer
Correct Option: E

when the source is file where can we set the file properties.
softskills teamwork

  1. session level

  2. mapping level

  3. worlflow level

  4. none of the above

Show answer
Correct Option: A

we can call the stored procedure in ports like :SP.Identifier(arguments)
softskills teamwork

  1. True

  2. False

Show answer
Correct Option: A

Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? (Choose two.)
softskills teamwork

  1. SUM(start_date)

  2. AVG(start_date)

  3. COUNT(start_date)

  4. AVG(start_date, end_date)

  5. MIN(start_date)

  6. MAXIMUM(start_date)

Show answer
Correct Option: C,E

You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?

softskills teamwork

  1. SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

  2. SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;

  3. SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

  4. SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

  5. SELECT TO_DATE (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

Show answer
Correct Option: C