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.
Q 1 - The partition of an Indexed table is dropped. then,
A - Corresponding partition from all indexes are dropped.
Answer : A
Explanation
As indexes are defined on a table, the removal of table partition also removes the respective index.
Q 2 - The 2 default TBLPROPERTIES added by hive when a hive table is created is
A - hive_version and last_modified by
B - last_modified_by and last_modified_time
Answer : B
Explanation
These are the 2 properties which are by default added by Hive
Q 3 - The partitioning of a table in Hive creates more
A - subdirectories under the database name
Answer : B
Explanation
Partitions of a table creates more subdirectories under it.
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 - The property set to run hive in local mode as true so that it runs without creating a mapreduce job is
B - hive.exec.mode.local.override
Answer : A
Explanation
In local mode hive will not trigger a mapreduce job.
Q 6 - A view in Hive can be seen by using
Answer : A
Explanation
There is no separate clause for viewing views. It is shown using show tables.
Q 7 - When importing data to using SerDe, if a row is found to have more columns than expected then
A - The extra columns are replaced with NULL
Answer : D
Explanation
Hive is schema on Read and It does not throw error for mismatch between schema and actual data.
Q 8 - The default limit to the number of rows returned by a query can be done using which of the following parameter?
A - hive.limit.optimize.enable
B - hive.limit.enable.optimize
Answer : A
Explanation
This parameter is configured to change the default value of the number of rows returned
Q 9 - Which file controls the logging of Mapreduce Tasks?
Answer : B
Explanation
This property controls the logging in Mapreduce tasks
Q 10 - Hive supports row-level Inser/update and Delete using the ACID features only on which file format?
Answer : C
Explanation
Except the ORC file all other files types do not support insert or update.
