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.
The schema only refers to the data stored and data is not validated against schema when inserted or loaded.
Q 2 - The drawback of managed tables in hive is
A - they are always stored under default directory
As they are managed by Hive metadata, other applications cannot access it.
Q 3 - If the directory for a partition does not exist, and a query is executed for this partition then
B - mapreduce job is not triggered
The map reduce job is triggered but no result will be returned.
Q 4 - The position of a specific column in a Hive table
A - can be anywhere in the table creation clause
B - must match the position of the corresponding data in the data file
C - Must match the position only for date time data type in the data file
It is up to the user to ensure the synchronization between schema and data
STRUCT elements are key-value pairs and the elements are accessed by dot notation.
Q 6 - The DISTRIBUTED by clause is used to ensure that
A - similar values go to the same reducer
B - similar values go to same mapper
C - similar values are distributed evenly across all the reducers
D - similar values are distributed evenly across all the mapers
The DISTRIBUTED BY clause send a range of values to the same reducer.
Q 7 - If an Index is dropped then
A - The underlying table is also dropped
B - The underlying table is not dropped
AN index can be dropped only after dropping the table on which index is created.
Q 8 - Setting the local mode execution to true causes
A - All tasks are executed on data available closet to the namenode
B - All tasks are executed only on a single machine
C - All the data files are cached on a datanode before query execution
Local mode avoid creating mapreduce job while running the job in a single machine.
Q 9 - Which file controls the logging of Mapreduce Tasks?
This property controls the logging in Mapreduce tasks
Q 10 - Which of the following File Formats are supported by Hive?
Hive supports all these three file formats as they are also supported by Hadoop in general