Engineering Questions with Answers - Multiple Choice Questions
MCQs on Introduction to Sqoop
1 - Question
BigDecimal is comprised of a ________ with an integer ‘scale’ field.
a) BigInt
b) BigInteger
c) MediumInt
d) SmallInt
View Answer
Answer: b
Explanation: The BigDecimal/BigInteger can also return itself as a ‘long’ value.
2 - Question
Point out the correct statement.
a) BooleanSerializer is used to parse string representations of boolean values into boolean scalar types
b) BlobRef is a wrapper that holds a BLOB either directly
c) BooleanParse is used to parse string representations of boolean values into boolean scalar types
d) All of the mentioned
View Answer
Answer: b
Explanation: BlobRef is used for reference to a file that holds the BLOB data.
3 - Question
ClobRef is a wrapper that holds a CLOB either directly or a reference to a file that holds the ______ data.
a) CLOB
b) BLOB
c) MLOB
d) All of the mentioned
View Answer
Answer: a
Explanation: Create a ClobRef based on parsed data from a line of text.
4 - Question
__________ encapsulates a set of delimiters used to encode a record.
a) LargeObjectLoader
b) FieldMapProcessor
c) DelimiterSet
d) LobSerializer
View Answer
Answer: c
Explanation: Delimiter set is created with the specified delimiters.
5 - Question
Point out the wrong statement.
a) Abstract base class that holds a reference to a Blob or a Clob
b) ACCESSORTYPE is the type used to access this data in a streaming fashion
c) CONTAINERTYPE is the type used to hold this data (e.g., BytesWritable)
d) None of the mentioned
View Answer
Answer: d
Explanation: DATATYPE is the type being held (e.g., a byte array).
6 - Question
_________ supports null values for all types.
a) SmallObjectLoader
b) FieldMapProcessor
c) DelimiterSet
d) JdbcWritableBridge
View Answer
Answer: d
Explanation: JdbcWritableBridge class contains a set of methods which can read db columns from a ResultSet into Java types.
7 - Question
Which of the following is a singleton instance class?
a) LargeObjectLoader
b) FieldMapProcessor
c) DelimiterSet
d) LobSerializer
View Answer
Answer: a
Explanation: Lifetime is limited to the current TaskInputOutputContext’s life.
8 - Question
Which of the following class is used for general processing of error?
a) LargeObjectLoader
b) ProcessingException
c) DelimiterSet
d) LobSerializer
View Answer
Answer: b
Explanation: General error occurs during the processing of a SqoopRecord.
9 - Question
Records are terminated by a __________ character.
a) RECORD_DELIMITER
b) FIELD_DELIMITER
c) FIELD_LIMITER
d) None of the mentioned
View Answer
Answer: a
Explanation: Class RecordParser parses a record containing one or more fields.
10 - Question
The fields parsed by ____________ are backed by an internal buffer.
a) LargeObjectLoader
b) ProcessingException
c) RecordParser
d) None of the Mentioned
View Answer
Answer: c
Explanation: Multiple threads must use separate instances of RecordParser.