Hive(Engineering > Computer Science And Engineering ) Questions and Answers

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
Explanation:-
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
Explanation:-
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
Explanation:-
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
Explanation:-
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
Explanation:-
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
Explanation:-
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
Explanation:-
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
Explanation:-
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
Explanation:-
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
Explanation:-
Answer: Option D. -> Hive Streaming




© Lakshya_Education.com, All Right Reserved.
Contact Us services