- Sqoop Tutorial
- Sqoop - Home
- Sqoop - Introduction
- Sqoop - Installation
- Sqoop - Import
- Sqoop - Import-All-Tables
- Sqoop - Export
- Sqoop - Sqoop Job
- Sqoop - Codegen
- Sqoop - Eval
- Sqoop - List Databases
- Sqoop - List Tables
- Sqoop Useful Resources
- Sqoop - Questions and Answers
- Sqoop - Quick Guide
- Sqoop - Useful Resources
- Sqoop - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Sqoop Online Quiz
Following quiz provides Multiple Choice Questions (MCQs) related to Sqoop. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - By default the records from databases imported to HDFS by sqoop are
Answer : D
Explanation
The default record separator is comm.
Answer : C
Explanation
You can do both full and partial data import from tables but not a subset of columns from a table.
Q 3 - The parameter to give a custom name to the mapreduce job running a sqoop import command is −
Answer : C
Explanation
The --mapreduce-job-name is used to give a user chosen job name to the sqoop command so that it can be easliy distinguished from other jobs in the jobtracker UI.
Q 4 - While importing data into Hadoop using sqoop the SQL SELCT clause is used. Similarly while exporting data form Hadoop the SQL clause used is
Answer : D
Explanation
The INSERT statements are generated by sqoop to insert data into the relational tables.
Q 5 - The parameter which decided How many rows will be inserted per transaction in sqoop is
A - Dsqoop.export.rows.per.transaction
B - Dsqoop.export.records.per.transaction
Answer : D
Explanation
The parameter
Dsqoop.export.statements.per.transaction decides how many rows will be inserted for transaction.
Q 6 - Can the upsert feature of sqoop delete some data form the exported table?
Answer : A
Explanation
Sqoop will never delete data as part of upsert statement.
Q 7 - For Text based columns the parameter used for substituting null values is
Answer : A
Explanation
The –input- null-string is used to substitute null values for text based columns.
Q 8 - To overwrite data present in hive table while importing data using sqoop, the sqoop parameter is
Answer : B
Explanation
The --hive-overwrite parameter truncates the hive table before loading the data.
Q 9 - The purpose of --hive-delims-replacement parameter in sqoop is to
A - Replace any hive delimiters with special string
B - Replace all the hive delimiters with null
C - replace \n, \t, and \01 characters with any other string
Answer : C
Explanation
As the characters \n, \t, and \01 may interfere with the data giving incorrect result, these can be replaced with a suitable string using this parameter.
Q 10 - The parameters in sqoop command can be passed in to Oozie by using which tags?
Answer : B
Explanation
The <args> tag can contain the parameters of a sqoop command when scheduling with Oozie.