Tag: softskills

Quizzes (0) Questions (7131)

Questions Related to softskills

Multiple choice softskills communication

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

  1. Paedestrian walk

  2. Jaywalk

  3. Monkey crossing

  4. Zebra Crossing
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Jaywalking specifically means crossing a street at a place other than a marked crosswalk or in a careless, reckless manner that violates traffic rules. The term originates from 'jay' meaning a foolish or inexperienced person. Options A, C, and D all refer to proper, legal crossing methods or designated pedestrian areas.

Multiple choice softskills teamwork

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

  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
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Informatica, the number of dollar signs denotes the scope: $ represents session parameters, $$ represents mapping parameters/variables, and $$$ represents system variables (like $$$SessStartTime). The correct option accurately maps these symbols to their respective technical categories.

Multiple choice softskills teamwork

what are the two modes of data movement in infomatica?

  1. Normal,Large

  2. Simple,Large

  3. Normal,Bulk

  4. none of above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Informatica PowerCenter supports two primary data movement modes: Normal and Bulk. Normal mode logs every row, while Bulk mode bypasses the database log to increase performance during large data loads. 'Large' and 'Simple' are not standard technical terms for these modes.

Multiple choice softskills teamwork

what are the lookup caches?

  1. Static Cache

  2. Dynamic Cache

  3. Persistant Cache

  4. Shared Cache

  5. All the Above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Informatica Lookup transformations support various cache types including Static (fixed data), Dynamic (updates during session), Persistent (saved across sessions), and Shared (used by multiple transformations). Therefore, 'All the Above' is the comprehensive and correct classification.

Multiple choice softskills teamwork

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

  1. session level

  2. mapping level

  3. worlflow level

  4. none of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Informatica PowerCenter, when the source is a file, file properties like source file name, directory path, and file type can be configured at the session level. Session properties override source qualifier settings and provide the most granular control for source file connections. Mapping and workflow levels don't handle these specific file properties.

Multiple choice softskills teamwork

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.)

  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)
Reveal answer Fill a bubble to check yourself
C,E Correct answer
Explanation

For DATE columns in Oracle, only COUNT, MIN, and MAX are valid aggregate functions because they work with ordered data and counting. SUM and AVG require numeric values to calculate totals and averages, which cannot be performed on dates. MAXIMUM (option F) is incorrect Oracle syntax - it must be MAX.

Multiple choice softskills teamwork

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

  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;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

TO_CHAR is used to format dates into strings. 'FMDay' ensures the day is capitalized and removes extra padding, while 'DD Month, YYYY' provides the day number, full month name, and year. TO_DATE is incorrect because it converts a string to a date, not a date to a formatted string.