
- 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
- 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 - What Hive can not offer
A - storing data in tables and columns
Answer : B
Explanation
Hive is suited for effectively organizing and querying the store data and not inserting/updating data which is required for OLTP.
Q 2 - By default when a database is dropped in Hive
A - the tables are also deleted
B - the directory is deleted if there are no tables
Answer : B
Explanation
Hive does not recursively delete the directory. So tables must be dropped first.
Q 3 - Users can pass configuration information to the SerDe using
Answer : B
Explanation
This feature of SrrDe is used to customize Hive for a wide range of file formats
Q 4 - Creating a table an loading it with a select clause in one query applies to
Answer : A
Explanation
Only a internal table can be created and loaded with data using one query.
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 name of a view in Hive
A - can be same as the name of another table in the same database
B - cannot be same as the name of another table in the same database
Answer : B
Explanation
Views and tables are treated similarly in the hive metadata
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 - Hive.exec.compress.output controls
A - The output compression of map tasks
B - The output compression of reduce tasks
Answer : C
Explanation
This property controls the compression of the output generated by a query.
Q 9 - Which file controls the logging of commands put in CLI?
Answer : A
Explanation
This property controls the logging in command line Interface.
Q 10 - Calling a unix bash script inside a Hive Query is an example of
Answer : D
Explanation
In this type of streaming the code resides in the script being called and Hive is not aware of the code.