Menu
Popular Courses
Search

MCQs


Total Questions : 10
Question 1. Point out the wrong statement:
  1.    There are four namespaces for variables in Hive
  2.    Custom variables can be created in a separate namespace with the define
  3.    Custom variables can also be created in a separate namespace with hivevar
  4.    None of the mentioned
 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
  1.    words containing both Chicago and Ontario
  2.    words containing either Chicago or Ontario
  3.    words Ending with Chicago or Ontario
  4.    words starting with Chicago or Ontario
 Discuss Question
Answer: Option B. -> words containing either Chicago or Ontario




Question 3. What is Hive?
  1.    An open source data warehouse system
  2.    relational database
  3.    OLTP
  4.    An langauge
 Discuss Question
Answer: Option A. -> An open source data warehouse system




Question 4. _______ supports a new command shell Beeline that works with HiveServer2
  1.    HiveServer2
  2.    HiveServer3
  3.    HiveServer4
  4.    None of the mentioned
 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
  1.    Aggregate Function
  2.    Generic Function
  3.    Standard UDF
  4.    Super Functions
 Discuss Question
Answer: Option B. -> Generic Function




Question 6. The clause used to limit the number of rows returned by a query is
  1.    Rownum
  2.    Restrict
  3.    Maxrow
  4.    Limit
 Discuss Question
Answer: Option D. -> Limit




Question 7. Which of the following scenarios are not prevented by enabling strict mode in Hive?
  1.    Scanning all the partitions
  2.    Generating random sample of data
  3.    Running a order by clause without a LIMIT clause
  4.    Cartesian product
 Discuss Question
Answer: Option B. -> Generating random sample of data




Question 8. The partitioning of a table in Hive creates more
  1.    subdirectories under the database name
  2.    subdirectories under the table name
  3.    files under database name
  4.    files under the table name
 Discuss Question
Answer: Option B. -> subdirectories under the table name




Question 9. In ______ mode HiveServer2 only accepts valid Thrift calls.
  1.    Remote
  2.    HTTP
  3.    Embedded
  4.    Interactive
 Discuss Question
Answer: Option A. -> Remote




Question 10. Calling a unix bash script inside a Hive Query is an example of
  1.    Hive Pipeline
  2.    Hive Caching
  3.    Hive forking
  4.    Hive Streaming
 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)
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