- 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 - 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 drawback of managed tables in hive is
A - they are always stored under default directory
Answer : D
Explanation
As they are managed by Hive metadata, other applications cannot access it.
Q 3 - In Hive SerDe stands for
Answer : B
Explanation
It is a program to read and write files using Java Input and Output formats.
Q 4 - If we change the partition location of a hive table using ALTER TABLE option then the data for that partition in the table
A - also moves automatically to the new location
B - has to be dropped and recreated
Answer : D
Explanation
Data is independent of schema in Hive.
Q 5 - The CONCAT string function in Hive can concatenate
Answer : C
Explanation
CONCAT function accepts any number of arguments
Q 6 - Which kind of keys(CONSTRAINTS) Hive can have?
Answer : D
Explanation
Hive is schema on read and unlike RDBMS it does not have a way to enforce the existence of keys.
Q 7 - The clause " WITH DEFERRED REBUILD" while creating an index
A - creates index on a table which is yet to be created
B - creates index on a table which has no data
Answer : D
Explanation
It is about creating index on an empty table.
Q 8 - Intermediate compression in Hive is about
A - Compressing the data just before it is read by mapreduce task
B - Compressing the data just before it is output to the user
C - Compressing the data before it is stored by into the disk
D - Compressing the data shuffled between the map and reduce tasks
Answer : D
Explanation
Data compression between map and reduce task is called intermediate compression.
Q 9 - The reverse() function reverses a string passed to it in a Hive query. This is an example of
Answer : A
Explanation
reverse(‘abcd’) gives ‘dcba’. So it is a standard UDF.
Q 10 - Which of the following File Formats are supported by Hive?
Answer : D
Explanation
Hive supports all these three file formats as they are also supported by Hadoop in general