Question 1

Which of the following is not a task in Workflow Manager

technology programming languages

Email
Session
Workflow
Timer

Answer

Correct Option: C

Question 2

Which of the following is/are an Active transformation

technology programming languages

Sorter
Connected Lookup
Expression
Unconnected Lookup

Answer

Correct Option: A

Question 3

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

technology programming languages

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

Answer

Correct Option: D

Question 4

Which activities below can be performed using Designer

technology programming languages

Run the Debugger, validate mappings and mapplets, import source definitions
Run the debugger, create and delete folders, import source definitions
Create and delete folders, view object dependencies, import source definitions
Create and delete folders, create and edit mappings, create target tables

Answer

Correct Option: A

Question 5

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

technology programming languages

Expression
Router
Lookup
Aggregator

Answer

Correct Option: A

Question 6

When would you use Joiner transformation

technology programming languages

If you want to join two tables in same database
If the Order By clause needs to be changed
If you want to join two tables on different Oracle databases
If you want to join table and flat file

Answer

Correct Option: D

Question 7

How many sources can be joined using Joiner transformation

technology programming languages

1
2
3
Unlimited

Answer

Correct Option: B

Question 8

Which are the different Lookup cache types

technology programming languages

Persistent
Dynamic
Static
All of the above

Answer

Correct Option: D

Question 9

Which transformation is used to read data from Cobol files?

technology programming languages

Normalizer
Source Qualifier
Source Definition
Any transformation

Answer

Correct Option: A

Question 10

What are the types of lookup

technology programming languages

active
passive
connected
Connected and unconnected

Answer

Correct Option: D

Question 11

What are the views available in the Workflow Monitor

technology programming languages

Task View and Gnatt Chart View
Task View, Time View and Workflow View
Task View, Gnatt Chart View and workflow view
Gnatt View and Workflow view

Answer

Correct Option: A

Question 12

Which of the following are Informatica PowerCenter Server Components

technology programming languages

Informatica Server
Repository Server
Both A and B
Neither A nor B

Answer

Correct Option: C

Question 13

Which datatype cannot be converted to any other datatype

technology programming languages

Character
Date
Integer
RAW

Answer

Correct Option: D

Question 14

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

technology programming languages

Aggregator
Lookup
Joiner
Expression

Answer

Correct Option: D

Question 15

Repository Manager is used to

technology programming languages

Create user
Create folders
Assign privileges
All of the above

Answer

Correct Option: D

Question 16

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?

technology programming languages

input type for SEX is mismatched, as its is read as charaters but format is expecting numeric
other
no name is assigned for user-defined Format
format not included in dataset
complier is seriously crazy

Answer

Correct Option: B

Question 17

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

technology programming languages

0
1
compile error
10

Answer

Correct Option: B

Question 18

Which of the following are valid statements in IDEAL?

technology programming languages

ADDITION
ADD
SUB
SUBTRACT

Answer

Correct Option: B,D

Question 19

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

technology programming languages

0
1
compile error
10

Answer

Correct Option: B

Question 20

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

technology programming languages

compile error
2
1
10

Answer

Correct Option: B

Description: programming languages Online Quiz - 273
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: programming languages

programming languages Online Quiz - 273

Find more quizzes from top tags