Hive Online Quiz
Following quiz provides Multiple Choice Questions (MCQs) related to Hive. 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.
Answer : A
Explanation
The schema only refers to the data stored and data is not validated against schema when inserted or loaded.
Answer : A
Explanation
Copying data is done by OS commands and not Hive
Q 3 - To see the partitions keys present in a Hive table the command used is
Answer : C
Explanation
The DESCRIBE EXTENDED command gives all the details
Q 4 - When the result of the STRING data type is returned by querying array data type using index, the result have
Answer : A
Explanation
The STRINGS returned form ARRAYS will not contain the quotes.
Q 5 - When a Hive query joins 3 tables, How many mapreduce jobs will be started?
Answer : B
Explanation
Hive cerates one mapreduce job for the first pair of tables and second pair of tables with one table common between both the pairs.
Q 6 - what can be altered about a view
Answer : C
Explanation
TBLPROPERTIES stores some documentation about the table like created date time etc.
Q 7 - The identifiers in HiveQL are
Answer : A
Explanation
Hive is case insensitive
Q 8 - Hive can automatically decide to run local mode by setting which of the following parameters in hive-site.xml?
A - hive.exec.mode.local.enable
B - hive.exec.mode.cluster.disable
Answer : D
Explanation
This parameter is used to set local mode.
Q 9 - Aggregate functions in Hive are the function which
A - Takes one or more columns form a row and returns a single value
B - Takes one or more columns form many rows and returns a single value
C - Take zero or more inputs and produce multiple columns or rows of output
D - Detects the type of input programmatically and provides appropriate response
Answer : B
Explanation
Examples functions are − count, avarege etc.
Q 10 - The UDF can access files inside
Answer : D
Explanation
All the listed filesystem can be accessed using UDF
