Hadoop Questions and Answers – Introduction to Sqoop

This set of Hadoop Multiple Choice Questions & Answers (MCQs) focuses on “Introduction to Sqoop”.

1. 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. 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. 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. __________ 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.

advertisement
advertisement

5. 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. _________ 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.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

7. 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. 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.

advertisement

9. 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.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.

advertisement

Sanfoundry Global Education & Learning Series – Hadoop.

Here’s the list of Best Books in Hadoop.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.