Real Time Ab Initio Online Quiz Questions and Answers
=> Also Read Ab Initio Interview Questions
Q.1) Select the list of departition components from the below
A. Gather
B. Merge
C. Intereave
D. Concatenate
E. All of the above
Ans: E
Q.2) Is it possible to increase the count vaue of reformat ?
A. True
B. False
Ans: A
Q.3) In memory sort is present in DeDup component
A. True
B. False
Ans: B
Q.4) Use of Generate component
A. To collect the junk data
B. Act as an inter mediate file
C. Generate random records
Ans: C
Q.5) Which is the key based component from the below
A. Concat
B. Merge
C. Interleave
D. Gather
Ans: B,C
Q.6) Adhoc Multifile is parallel file, but not stored in a multiple directory
A. True
B. False
Ans: A
Q.7) Usage of intermediate file do not increase the phase
A. True
B. False
Ans: B
Q.8) Which command is use to generate dml
A. M_db generate dml
B. M_db gendml
C. M_db gen
Ans: B
Q.9) 2 important keys used in sort within group
A. Major key
B. Minor Key
C. Both
D. None of the above
Ans: c
Q.10) Is it possible to extract data from 2 different source or database using AB INITIO graphs
A. True
B. False
Ans: A
Q.12) Which departition component is best way to use, when the data is not in a sorted order
A. Concat
B. Merge
C. Gather
Ans: C
Q.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
Ans: C
Q.14) When we use force_error, the parameter reject_threshold should be never abort
A. True
B. False
Ans: A
Q.15) Parameters involved in Run sql component
A. Num_error
B. SQLFile
C. DB Config File
Ans: B,C
Q.16) Which component is used to delete the data in table
A. Delete table component
B. Truncate table component
C. Run table component
Ans: B
Q.17) Which is true about redefine
A. Change the value
B. Change the field name
C. Change the data type
Ans: C
Q.18) Scenario : input file -> reformat -> output file
1. 10 records in my input file
2. In reformat , select i give the code next_in_sequence()==2
What ll be the output this graph or how many records will be received in the output file
A. 1
B. 2
C. 10
Ans: A
Q.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
Ans: B
Q.20) Which is correct syntax to create MFS file
A. M_mkfs
B. M_db_mkfs
C. M_mfs
Ans: A
Q.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
Ans: C
Q.22) In conditional component, value 1 will pass the records, value 0 will disable the component or the subgraph
A. True
B. False
Ans: A
Q.23) Which parameter will help us to find the status of the exectued graph
A. $AB_GRAPH
B. $mp_graph
C. $mpjret
Ans: C
.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
Ans: B
Q.25) Which component is used to run the shell script
A. Run SQL
B. Run Program
C. Join with DB
Ans: B
Q.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
Ans: B
Q.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
Ans: C
Q.28) Replicate is a component which do not gather all the data records into one single flow.
A. True
B. False
Ans: B
Q.29) Which component break pipeline parallelism
A. Intermediate file
B. Look up file
C. Sort
D. All the above
Ans: D
Q.30) Which component in the below behaves like a where clause component
A. Replicate
B. Gather
C. Filter by Expression
D. Redefine
Ans: C
Q.31) Which component from the below do not have any parameter
A. Replicate
B. Redefine
C. Trash
D. All the above
Ans: D
Q.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
Ans: D
Q.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
Ans: A
Q.34) Co>Op is optional in AB INITIO
A. True
B. False
Ans: B
Q.35) EME is optional in AB INITIO
A. True
B. False
Ans: A
Q.36) Its not possible to run an AB INITIO graph without GDE
A. True
B. False
Ans: B
Q.37) Is it possible to do a check in / check out using GDE ?
A. True
B. False
Ans: A
Q.38) Unix command to do check in
A. Air project import -basedir
B. Air project export -basedir
C. Air project -basedir
Ans: A
Q.39) Which component from the below give the accumulated output
A. Partition by expression
B. Filter by expression
C. Scan
Ans: C
Q.40) Which command is used to remove the leading and trailing space
A. String_trunc()
B. String_lrtrim()
C. String_del()
Ans: B
Q.41) What is the output of this expression decimal_strip("+ 26 abc ")
A. +26abc
B. +26abc
C. +26
Ans: C
Q.42) Whats the output of this excpression
is_define(NULL)
A. 1
B. 0
C. NULL
Ans: B
Q.43) Whats is the output of this expression is_null(NULL)
A. 1
B. 0
C. " "
Ans: A
Q.44) Join types in AB INITIO
A. Inner,full outer, explicit
B. Semi join, left outer, right outer
C. Inner, left outer, right outer
Ans: A
Q.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
Ans: B
Q.46) how to touch a multifile
A. Touch filename
B. M_touch filename
C. Both
Ans: B
Q.47) What happens when the data for join is not in sorted order
A. Graph fails
B. Graph executed
C. Get struck
Ans: A
Q.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
Ans: B
Q.49) Trash component cannot store any output data
A. True
B. False
Ans: A
Q.50) What are the types of parallelism in AB INITIO
A. Data,component,pipeline
B. Component, process,data
C. Pipeline,connection,data
Ans: A
Q.1) Select the list of departition components from the below
A. Gather
B. Merge
C. Intereave
D. Concatenate
E. All of the above
Ans: E
Q.2) Is it possible to increase the count vaue of reformat ?
A. True
B. False
Ans: A
Q.3) In memory sort is present in DeDup component
A. True
B. False
Ans: B
Q.4) Use of Generate component
A. To collect the junk data
B. Act as an inter mediate file
C. Generate random records
Ans: C
Q.5) Which is the key based component from the below
A. Concat
B. Merge
C. Interleave
D. Gather
Ans: B,C
Q.6) Adhoc Multifile is parallel file, but not stored in a multiple directory
A. True
B. False
Ans: A
Q.7) Usage of intermediate file do not increase the phase
A. True
B. False
Ans: B
Q.8) Which command is use to generate dml
A. M_db generate dml
B. M_db gendml
C. M_db gen
Ans: B
Q.9) 2 important keys used in sort within group
A. Major key
B. Minor Key
C. Both
D. None of the above
Ans: c
Q.10) Is it possible to extract data from 2 different source or database using AB INITIO graphs
A. True
B. False
Ans: A
Q.12) Which departition component is best way to use, when the data is not in a sorted order
A. Concat
B. Merge
C. Gather
Ans: C
Q.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
Ans: C
Q.14) When we use force_error, the parameter reject_threshold should be never abort
A. True
B. False
Ans: A
Q.15) Parameters involved in Run sql component
A. Num_error
B. SQLFile
C. DB Config File
Ans: B,C
Q.16) Which component is used to delete the data in table
A. Delete table component
B. Truncate table component
C. Run table component
Ans: B
Q.17) Which is true about redefine
A. Change the value
B. Change the field name
C. Change the data type
Ans: C
Q.18) Scenario : input file -> reformat -> output file
1. 10 records in my input file
2. In reformat , select i give the code next_in_sequence()==2
What ll be the output this graph or how many records will be received in the output file
A. 1
B. 2
C. 10
Ans: A
Q.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
Ans: B
Q.20) Which is correct syntax to create MFS file
A. M_mkfs
B. M_db_mkfs
C. M_mfs
Ans: A
Q.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
Ans: C
Q.22) In conditional component, value 1 will pass the records, value 0 will disable the component or the subgraph
A. True
B. False
Ans: A
Q.23) Which parameter will help us to find the status of the exectued graph
A. $AB_GRAPH
B. $mp_graph
C. $mpjret
Ans: C
.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
Ans: B
Q.25) Which component is used to run the shell script
A. Run SQL
B. Run Program
C. Join with DB
Ans: B
Q.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
Ans: B
Q.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
Ans: C
Q.28) Replicate is a component which do not gather all the data records into one single flow.
A. True
B. False
Ans: B
Q.29) Which component break pipeline parallelism
A. Intermediate file
B. Look up file
C. Sort
D. All the above
Ans: D
Q.30) Which component in the below behaves like a where clause component
A. Replicate
B. Gather
C. Filter by Expression
D. Redefine
Ans: C
Q.31) Which component from the below do not have any parameter
A. Replicate
B. Redefine
C. Trash
D. All the above
Ans: D
Q.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
Ans: D
Q.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
Ans: A
Q.34) Co>Op is optional in AB INITIO
A. True
B. False
Ans: B
Q.35) EME is optional in AB INITIO
A. True
B. False
Ans: A
Q.36) Its not possible to run an AB INITIO graph without GDE
A. True
B. False
Ans: B
Q.37) Is it possible to do a check in / check out using GDE ?
A. True
B. False
Ans: A
Q.38) Unix command to do check in
A. Air project import -basedir
B. Air project export -basedir
C. Air project -basedir
Ans: A
Q.39) Which component from the below give the accumulated output
A. Partition by expression
B. Filter by expression
C. Scan
Ans: C
Q.40) Which command is used to remove the leading and trailing space
A. String_trunc()
B. String_lrtrim()
C. String_del()
Ans: B
Q.41) What is the output of this expression decimal_strip("+ 26 abc ")
A. +26abc
B. +26abc
C. +26
Ans: C
Q.42) Whats the output of this excpression
is_define(NULL)
A. 1
B. 0
C. NULL
Ans: B
Q.43) Whats is the output of this expression is_null(NULL)
A. 1
B. 0
C. " "
Ans: A
Q.44) Join types in AB INITIO
A. Inner,full outer, explicit
B. Semi join, left outer, right outer
C. Inner, left outer, right outer
Ans: A
Q.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
Ans: B
Q.46) how to touch a multifile
A. Touch filename
B. M_touch filename
C. Both
Ans: B
Q.47) What happens when the data for join is not in sorted order
A. Graph fails
B. Graph executed
C. Get struck
Ans: A
Q.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
Ans: B
Q.49) Trash component cannot store any output data
A. True
B. False
Ans: A
Q.50) What are the types of parallelism in AB INITIO
A. Data,component,pipeline
B. Component, process,data
C. Pipeline,connection,data
Ans: A
No comments:
Post a Comment