- 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
- Hive Useful Resources
- Hive - Questions and Answers
- Hive - Quick Guide
- Hive - Useful Resources
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 query "SHOW DATABASE LIKE 'h.*' ; gives the output with database name
Answer : B
Explanation
Hive support regular expressions which are derived from regex capabilities of Java language.
Answer : A
Explanation
Copying data is done by OS commands and not Hive
Q 3 - The main advantage of creating table partition is
A - Effective storage memory utilization
Answer : B
Explanation
Partitioning creates subdirectories and only those subdirectories are read to fetch the query result, improving the performance.
Q 4 - Partitioned can be prevented from being
Answer : A
Explanation
using the ALTER TABLE.. ENABLE NO_DROP & ENABLE OFFLINE clause.
Q 5 - When a Hive query joins 3 tables, How many mapreduce jobs will be started?
Answer : B
Explanation
Hive cerates one mapreduce job for the first pair of tables and second pair of tables with one table common between both the pairs.
Q 6 - The Index in Hive can be seen by
Answer : B
Explanation
Similar to show tables, Indexes can be queried by SHOW Index.
Q 7 - Indexes can be created
Answer : A
Explanation
As external table data is managed by other applications hive does not create index on them.
Q 8 - If a hive query produces unexpected result then its cause can be investigated by using
Answer : B
Explanation
Virtual columns give the complete path and name of data block from where the error is arising.
Q 9 - Which of the below is not a type compression option for Sequence file
Answer : C
Explanation
There is no COLUMN compression type for a sequence file
Q 10 - Hive can be accessed remotely by using programs written in C++, Ruby etc, over a single port. This is achieved by using
Answer : A
Explanation
HiveServer or Hive Thrift service is used to access Hive remotely.