0

programming languages Online Quiz - 273

Description: programming languages Online Quiz - 273
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0

Which of the following is not a task in Workflow Manager

  1. Email

  2. Session

  3. Workflow

  4. Timer


Correct Option: C

Which of the following is/are an Active transformation

  1. Sorter

  2. Connected Lookup

  3. Expression

  4. Unconnected Lookup


Correct Option: A

What types of data source(s) can be read with the source qualifier transformation?

  1. Relational Databases

  2. Relational Databases and flat files

  3. Relational Databases,lat files and cobol

  4. Relational Databases,lat files,cobol and certified ERP sources such as Peoplesoft and SAP R/3


Correct Option: D

Which activities below can be performed using Designer

  1. Run the Debugger, validate mappings and mapplets, import source definitions

  2. Run the debugger, create and delete folders, import source definitions

  3. Create and delete folders, view object dependencies, import source definitions

  4. Create and delete folders, create and edit mappings, create target tables


Correct Option: A

Choose the correct option - Transformations which have only Input/Output ports

  1. Expression

  2. Router

  3. Lookup

  4. Aggregator


Correct Option: A

When would you use Joiner transformation

  1. If you want to join two tables in same database

  2. If the Order By clause needs to be changed

  3. If you want to join two tables on different Oracle databases

  4. If you want to join table and flat file


Correct Option: D

How many sources can be joined using Joiner transformation

  1. 1

  2. 2

  3. 3

  4. Unlimited


Correct Option: B

Which are the different Lookup cache types

  1. Persistent

  2. Dynamic

  3. Static

  4. All of the above


Correct Option: D

Which transformation is used to read data from Cobol files?

  1. Normalizer

  2. Source Qualifier

  3. Source Definition

  4. Any transformation


Correct Option: A

What are the types of lookup

  1. active

  2. passive

  3. connected

  4. Connected and unconnected


Correct Option: D

What are the views available in the Workflow Monitor

  1. Task View and Gnatt Chart View

  2. Task View, Time View and Workflow View

  3. Task View, Gnatt Chart View and workflow view

  4. Gnatt View and Workflow view


Correct Option: A

Which of the following are Informatica PowerCenter Server Components

  1. Informatica Server

  2. Repository Server

  3. Both A and B

  4. Neither A nor B


Correct Option: C

Which datatype cannot be converted to any other datatype

  1. Character

  2. Date

  3. Integer

  4. RAW


Correct Option: D

Which one of the transformations below does not use index and data cache

  1. Aggregator

  2. Lookup

  3. Joiner

  4. Expression


Correct Option: D

Repository Manager is used to

  1. Create user

  2. Create folders

  3. Assign privileges

  4. All of the above


Correct Option: D

1 options linesize=80; 2 title 'Example 2. Test of proc freq'; 3 4 proc format; 5 value $fsex '1'='Male' 6 '2'='Female'; NOTE: Format $FSEX has been output. 7 run; NOTE: PROCEDURE FORMAT used: real time 0.28 seconds cpu time 0.04 seconds 8 9 data sample1; 10 infile 'example2.dat'; 11 input caseid 1-4 mathsat 6-8 score 10-11 sex $ 13 teach 15 12 format sex $fsex.; ______ ______ ______ 228 228 228 13 label caseid='Subject Number' 14 mathsat='SAT Math Score' 15 score='Final Calculus Score' 16 sex='Sex of Participant' 17 teach='Student Rated Teaching Ability'; 18 ERROR 228-185: Informat $FSEX is unknown. ERROR 228-185: Informat $FSEX is unknown. ERROR 228-185: Informat $FSEX is unknown. NOTE: The SAS System stopped processing this step because of errors. NOTE: SAS set option OBS=0 and will continue to check statements. This may cause NOTE: No observations in data set. WARNING: The data set WORK.SAMPLE1 may be incomplete. When this step was stopped there were 0 observations and 6 variables. What is the problem?

  1. input type for SEX is mismatched, as its is read as charaters but format is expecting numeric

  2. other

  3. no name is assigned for user-defined Format

  4. format not included in dataset

  5. complier is seriously crazy


Correct Option: B

void main() { int i = 10; int *p=&i; p++; printf("%d",(p-&i)); }

  1. 0

  2. 1

  3. compile error

  4. 10


Correct Option: B

Which of the following are valid statements in IDEAL?

  1. ADDITION

  2. ADD

  3. SUB

  4. SUBTRACT


Correct Option: B,D

void main() { int i = 10; long *p=&i; p++; printf("%d",(p-&i)); }

  1. 0

  2. 1

  3. compile error

  4. 10


Correct Option: B

void main() { int i = 10; long *p=&i; p++; printf("%d",abs(&i-p)); }

  1. compile error

  2. 2

  3. 1

  4. 10


Correct Option: B
- Hide questions