- 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 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 - Using the ALTER DATABASE command in an database you can change the
Answer : C
Explanation
only dbproperties are changed through this command
Q 3 - To see the data types details of only a column (not the table) we should use the command
Answer : A
Q 4 - If the schema of the table does not match with the data types present in the file containing the table then HIve
A - Automatically drops the file
B - Automatically corrects the data
Answer : C
Explanation
Hive always tries to read the data as it is Schema on Read.
Q 5 - The below expression in the where clause
RLIKE '.*(Chicago|Ontario).*';
gives the result which match
A - words containing both Chicago and Ontario
B - words containing either Chicago or Ontario
Answer : B
Explanation
Hive supports java based regular expression for querying.
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 - The identifiers in HiveQL are
Answer : A
Explanation
Hive is case insensitive
Q 8 - Which of the following scenarios are not prevented by enabling strict mode in Hive?
A - Scanning all the partitions
B - Generating random sample of data
Answer : B
Explanation
The other three scenarios create long running job. So STRICT mode is applied to them.
Q 9 - The command to list the functions currently loaded in a Hive Session is
Answer : B
Explanation
SHOW FUNCTIONS produces list of all the functions currently available in hive session
Q 10 - The MACRO created in Hive has the ability to
A - Run multiple functions on same set of data automatically
Answer : B
Explanation
Macros are created for the purpose of calling other functiuons
To Continue Learning Please Login