- 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 - Which of the following is not a complex data type in Hive?
Answer : A
Explanation
There is no Matrix data type in Hive.
Answer : A
Explanation
Copying data is done by OS commands and not Hive
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 - Partitioned can be prevented from being
Answer : A
Explanation
using the ALTER TABLE.. ENABLE NO_DROP & ENABLE OFFLINE clause.
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 LIMIT clause applied to a select query
A - Executes the entire query before the LIMIT clause
B - Hive fetches one row at a time until it gets the required limit.
C - Creates a temporary file and stores the query result their
Answer : A
Explanation
The query is run on complete data set and then the results are restricted using LIMIT clause.
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 - A standard user-defined function (UDF) refers to any 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 : A
Explanation
Examples functions are concat, reverse etc.
Q 10 - To add a new user defined Function permanently to Hive, we need to
A - Create a new version of HIve
B - Add the .class Java code to FunctionRegistry
Answer : B
Explanation
Functionregistry holds the list of all permanent functions