Popular Courses
Sail E0 Package
Valid Till Next Exam
Fast Math Tricks
165 videos
Quantitative Aptitude
645 Videos
Reasoning Aptitude
161 Videos
CLASS 8 MATHS(CBSE)
417 Videos
CLASS 9 MATHS(CBSE)
40 hours, 647 questions
Check All Courses
Resources
Store
Blog
More
About Us
Contact Us
Register / Login
Menu
Home
Blog
Store
About Us
Contact Us
Profile Settings
Attempted Tests
My Purchases
Popular Courses
Sail E0 Package
Valid Till Next Exam
Fast Math Tricks
165 videos
Quantitative Aptitude
645 Videos
Reasoning Aptitude
161 Videos
CLASS 8 MATHS(CBSE)
417 Videos
CLASS 9 MATHS(CBSE)
40 hours, 647 questions
Check All Courses
Search
Search
Home
Topics
MCQs
Total Questions : 10
Question 1.
Point out the wrong statement:
There are four namespaces for variables in Hive
Custom variables can be created in a separate namespace with the define
Custom variables can also be created in a separate namespace with hivevar
None of the mentioned
See Solution
Discuss Question
Answer: Option A. ->
There are four namespaces for variables in Hive
Question 2.
The below expression in the where clause
RLIKE '.*(Chicago|Ontario).*';
gives the result which match
words containing both Chicago and Ontario
words containing either Chicago or Ontario
words Ending with Chicago or Ontario
words starting with Chicago or Ontario
See Solution
Discuss Question
Answer: Option B. ->
words containing either Chicago or Ontario
Question 3.
What is Hive?
An open source data warehouse system
relational database
OLTP
An langauge
See Solution
Discuss Question
Answer: Option A. ->
An open source data warehouse system
Question 4.
_______ supports a new command shell Beeline that works with HiveServer2
HiveServer2
HiveServer3
HiveServer4
None of the mentioned
See Solution
Discuss Question
Answer: Option A. ->
HiveServer2
Question 5.
A user creates a UDF which accepts arguments of different data types, each time it is run. It is an example of
Aggregate Function
Generic Function
Standard UDF
Super Functions
See Solution
Discuss Question
Answer: Option B. ->
Generic Function
Question 6.
The clause used to limit the number of rows returned by a query is
Rownum
Restrict
Maxrow
Limit
See Solution
Discuss Question
Answer: Option D. ->
Limit
Question 7.
Which of the following scenarios are not prevented by enabling strict mode in Hive?
Scanning all the partitions
Generating random sample of data
Running a order by clause without a LIMIT clause
Cartesian product
See Solution
Discuss Question
Answer: Option B. ->
Generating random sample of data
Question 8.
The partitioning of a table in Hive creates more
subdirectories under the database name
subdirectories under the table name
files under database name
files under the table name
See Solution
Discuss Question
Answer: Option B. ->
subdirectories under the table name
Question 9.
In ______ mode HiveServer2 only accepts valid Thrift calls.
Remote
HTTP
Embedded
Interactive
See Solution
Discuss Question
Answer: Option A. ->
Remote
Question 10.
Calling a unix bash script inside a Hive Query is an example of
Hive Pipeline
Hive Caching
Hive forking
Hive Streaming
See Solution
Discuss Question
Answer: Option D. ->
Hive Streaming
Share this page with your friends!
Share this page with your friends!
Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDI
Part 1 : (13-04-2024)
INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test
Part 1
Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP
Part 1 : (14-02-2024)
GPOE 2024
Cube & Cuboid
Part 1
Reasoning (Hindi)
Data Interpretation (DI)
Basic Concept
Reasoning (Hindi)
Counting Figures Part 1
Counting Of Straight Lines
Reasoning (Hindi)
Sail E0 free webinar
Webinars
Real Numbers
Part 7
Class 10 Maths
Real Numbers
Part 1
Class 10 Maths
Polynomials
Part 1
Class 10 Maths
Latest Test Papers
Chapter 1.1 : INTRODUCTION
Chapter 1 : Raw Material Handling Plant
GPOE/GPA 2024
Chapter 1.1 : Personnel Functions- An ov
Chapter 1 : Personnel Management
GFM 2024
Chapter 3.1 : INTRODUCTION
Chapter 3 : Sinter Plant
GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set
Chapter 2 : Coke Ovens and Coal Chemicals
GPOE/GPA 2024
Chapter 2.1 : Overview
Chapter 2 : Materials Management
GFM 2024