Sail E0 Webinar

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




Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY 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
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

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0