- Hive Tutorial
- Hive - Home
- Hive - Introduction
- Hive - Installation
- Hive - Data Types
- Hive - Create Database
- Hive - Drop Database
- Hive - Create Table
- Hive - Alter Table
- Hive - Drop Table
- Hive - Partitioning
- Hive - Built-In Operators
- Hive - Built-In Functions
- Hive - Views And Indexes
- HiveQL
- HiveQL - Select Where
- HiveQL - Select Order By
- HiveQL - Select Group By
- HiveQL - Select Joins
- Hive Useful Resources
- Hive - Questions and Answers
- Hive - Quick Guide
- Hive - Useful Resources
- Hive - 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
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 default delimiter in hive to separate the element in STRUCT is
Answer : B
Explanation
The four default delimiters are − \n for record separator,
001\ for field separator
002\ for element separator in ARRAY or STRUCT
003\ for element separator in MAP
Answer : A
Explanation
Copying data is done by OS commands and not Hive
Q 3 - To see the partitions present in a Hive table the command used is
Answer : B
Explanation
SHOW PARTTIONS table_name
Q 4 - While loading data into managed tables, If the LOCAL clause is mentioned, it
A - Moves the data from local filesystem to the target files system
B - Copies the data from local filesystem to target final file system
Answer : B
Explanation
The LOCAL clause only copies without moving the files.
Q 5 - For optimizing join of three tables, the largest sized tables should be placed as
A - the first table in the join clause
B - second table in the join clause
Answer : C
Explanation
Hive reads the tables from left to right. Small tables should be read first and if possible cached into the memory.
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
Answer : A
Explanation
The DISTRIBUTED BY clause send a range of values to the same reducer.
Q 7 - If the data on the table on which an index is defined changes then,
B - The index rebuilds automatically
Answer : C
Explanation
Hive does not manage the Index like RDBMS. SO it has to be built manually.
Q 8 - The disadvantage of compressing files in HDFS is
Answer : C
Explanation
When files are not splitable , querying them becomes inefficient.
Q 9 - A GenericUDF is a Function that
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 : D
Explanation
These functions are created as java programs.
Q 10 - When one of the join tables is small enough to fit into memory, The type of join used by Hive is
Answer : B
Explanation
As one of the tables already fits into the memory each row of the big table is quickly compared with each row of small table using Map Join.