Ab Initio
AB INITIO Quiz
- 1.
Select the list of departition components from the below
- A.
Gather
- B.
Merge
- C.
Filter by Expression
- D.
Roun Robin
- E.
Intereave
- F.
Concatenate
Correct Answer(s)
A. Gather
B. Merge
E. Intereave
F. Concatenate -
- 2.
Is it possible to increase the count vaue of reformat ?
- A.
True
- B.
False
Correct Answer
A. True -
- 3.
In memory sort is present in DeDup component
- A.
True
- B.
False
Correct Answer
B. False -
- 4.
Use of Generate component
- A.
To collect the junk data
- B.
Act as an inter mediate file
- C.
Generate random records
Correct Answer
C. Generate random records -
- 5.
Which is the key based component from the below
- A.
Concat
- B.
Merge
- C.
Interleave
- D.
Gather
Correct Answer(s)
B. Merge
C. Interleave -
- 6.
Adhoc Multifile is parallel file, but not stored in a multiple directory
- A.
True
- B.
False
Correct Answer
A. True -
- 7.
Usage of intermediate file do not increase the phase
- A.
True
- B.
False
Correct Answer
B. False -
- 8.
Which command is use to generate dml
- A.
M_db generate dml
- B.
M_db gendml
- C.
M_db gen
Correct Answer
B. M_db gendml -
- 9.
2 important keys used in sort within group
- A.
Major key
- B.
Minor Key
- C.
Both
- D.
None of the above
Correct Answer
C. Both -
- 10.
Is it possible to extract data from 2 different source or database using AB INITIO graphs
- A.
True
- B.
False
Correct Answer
A. True -
- 11.
Which is the command used in GDE to run unix commands
Correct Answer
F8 - 12.
Which departition component is best way to use, when the data is not in a sorted order
- A.
Concat
- B.
Merge
- C.
Gather
Correct Answer
C. Gather -
- 13.
When does the data format error occurs
- A.
When the input file is not given properly
- B.
When the layout is not specified properly
- C.
When the dml and data is not matching
Correct Answer
C. When the dml and data is not matching -
- 14.
When we use force_error, the parameter reject_threshold should be never abort
- A.
True
- B.
False
Correct Answer
A. True -
- 15.
Parameters involved in Run sql component
- A.
Num_error
- B.
SQLFile
- C.
DB Config File
Correct Answer(s)
A. Num_error
B. SQLFile
C. DB Config File -
- 16.
Which component is used to delete the data in table
- A.
Delete table component
- B.
Truncate table component
- C.
Run table component
Correct Answer
B. Truncate table component -
- 17.
Which is true about redefine
- A.
Change the value
- B.
Change the field name
- C.
Change the data type
Correct Answer(s)
B. Change the field name
C. Change the data type -
- 18.
Scenario : input file -> reformat -> output file1. 10 records in my input file2. In reformat , select i give the code next_in_sequence()==2What ll be the output this graph or how many records will be received in the output file
- A.
1
- B.
2
- C.
10
Correct Answer
A. 1 -
- 19.
Which is the correct in the below for MFS
- A.
((next_in =sequence()-1)*number_ofpartition()+this_partition())
- B.
((next_in =sequence()-1)*number_ofpartition()+this_partition())+1
- C.
((next_in =sequence()-1)+number_ofpartition()+this_partition())+1
Correct Answer
B. ((next_in =sequence()-1)*number_ofpartition()+this_partition())+1 -
- 20.
Which is correct syntax to create MFS file
- A.
M_mkfs
- B.
M_db_mkfs
- C.
M_mfs
Correct Answer
A. M_mkfs -
- 21.
Whats the manual command used to clean up the activity, before re-executing the graph
- A.
Rm rec_file
- B.
M_rm rec_file
- C.
M_rollback -d rec_file
Correct Answer
C. M_rollback -d rec_file -
- 22.
In conditional component, value 1 will pass the records, value 0 will disable the component or the subgraph
- A.
True
- B.
False
Correct Answer
A. True -
- 23.
Which parameter will help us to find the status of the exectued graph
- A.
$AB_GRAPH
- B.
$mp_graph
- C.
$mpjret
Correct Answer
C. $mpjret -
- 24.
By doing what the output file is changed into a lookup file
- A.
Using intermediate file
- B.
Click add to catlog in output file component
- C.
Using adhoc multifile
Correct Answer
B. Click add to catlog in output file component -
- 25.
Which component is used to run the shell script
- A.
Run SQL
- B.
Run Program
- C.
Join with DB
Correct Answer
B. Run Program -
- 26.
To take the data from 1st to specific record which component form the below i should use
- A.
Join with DB
- B.
Leading records
- C.
Trash
Correct Answer
B. Leading records -
- 27.
Which component from the below is used to capture the log information and used for analysis purpose
- A.
Intermediate file
- B.
Look file
- C.
Gather Log
Correct Answer
C. Gather Log -
- 28.
Replicate is a component which do not gather all the data records into one single flow.
- A.
True
- B.
False
Correct Answer
B. False -
- 29.
Which component break pipeline parallelism
- A.
Intermediate file
- B.
Look up file
- C.
Sort
- D.
All the above
Correct Answer
D. All the above -
- 30.
Which component in the below behaves like a where clause component
- A.
Replicate
- B.
Gather
- C.
Filter by Expression
- D.
Redefine
Correct Answer
C. Filter by Expression -
- 31.
Which component from the below do not have any parameter
- A.
Replicate
- B.
Redefine
- C.
Trash
- D.
All the above
Correct Answer
D. All the above -
- 32.
Select the list of partition component from the below list
- A.
Partition by Key
- B.
Partition by load balance
- C.
Partition by expression
- D.
All the above
Correct Answer
D. All the above -
- 33.
By default what is the count of reformat and multireformat
- A.
Reformat count 1, multireformat 2
- B.
Reformat count 1, multireformat 1
- C.
Reformat count 2, multireformat 1
Correct Answer
A. Reformat count 1, multireformat 2 -
- 34.
Co>Op is optional in AB INITIO
- A.
True
- B.
False
Correct Answer
B. False -
- 35.
EME is optional in AB INITIO
- A.
True
- B.
False
Correct Answer
A. True -
- 36.
Its not possible to run an AB INITIO graph without GDE
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
We can run the graph through unixRate this question:
-
- 37.
Is it possible to do a check in / check out using GDE ?
- A.
True
- B.
False
Correct Answer
A. True -
- 38.
Unix command to do check in
- A.
Air project import -basedir
- B.
Air project export -basedir
- C.
Air project -basedir
Correct Answer
A. Air project import -basedir -
- 39.
Which component from the below give the accumulated output
- A.
Partition by expression
- B.
Filter by expression
- C.
Scan
Correct Answer
C. Scan -
- 40.
Which command is used to remove the leading and trailing space
- A.
String_trunc()
- B.
String_lrtrim()
- C.
String_del()
Correct Answer
B. String_lrtrim() -
- 41.
What is the output of this expressiondecimal_strip("+ 26 abc ")
- A.
+26abc
- B.
+26abc
- C.
+26
Correct Answer
C. +26 -
- 42.
Whats the output of this excpressionis_define(NULL)
- A.
1
- B.
0
- C.
NULL
Correct Answer
B. 0 -
- 43.
Whats is the output of this expressionis_null(NULL)
- A.
1
- B.
0
- C.
" "
Correct Answer
A. 1 -
- 44.
Join types in AB INITIO
- A.
Inner,full outer, explicit
- B.
Semi join, left outer, right outer
- C.
Inner, left outer, right outer
Correct Answer
A. Inner,full outer, explicit -
- 45.
While doing a join, key form one flow is id and from other flow is emp_id.Using which from the below i can use this 2 keys to join
- A.
Driving port
- B.
Overriding
- C.
Dedup
Correct Answer
B. Overriding -
- 46.
How to touch a multifile
- A.
Touch filename
- B.
M_touch filename
- C.
Both
Correct Answer
B. M_touch filename -
- 47.
What happens when the data for join is not in sorted order
- A.
Graph fails
- B.
Graph executed
- C.
Get struck
Correct Answer
A. Graph fails -
- 48.
What happens when data for merge is not in a sorted order
- A.
Grpah fails
- B.
Graph does not fail, not correct output
- C.
None of the above
Correct Answer
B. Graph does not fail, not correct output -
- 49.
Trash component cannot store any output data
- A.
True
- B.
False
Correct Answer
A. True -
- 50.
What are the types of parallelism in AB INITIO
- A.
Data,component,pipeline
- B.
Component, process,data
- C.
Pipeline,connection,data
Correct Answer
A. Data,component,pipeline -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jul 30, 2011Quiz Edited by
ProProfs Editorial Team -
Mar 08, 2011Quiz Created by
Annegrace11
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
Back to top