+1-315-636-4485
+91 98151-74050 
This set of MCQs helps students to learn about various Hive which is a data warehouse system built on top of Hadoop, and HBase which is a NoSQL key/value on top of HDFS or Alluxio.
Which of the following operator executes a shell command from the Hive shell?
_________ is a shell utility which can be used to run Hive queries in either interactive or batch mode.
Which of the following is a command line option?
Which is the additional command line option is available in Hive 0.10.0?
When $HIVE_HOME/bin/hive is run without either the -e or -f option, it enters _______ mode.
Avro-backed tables can simply be created by using _________ in a DDL statement.
Types that may be null must be defined as a ______ of that type and Null within Avro.
_______ is interpolated into the quotes to correctly handle spaces within the schema.
________ was designed to overcome limitations of the other Hive file formats.
Which of the following command sets the value of a particular configuration variable (key)?
Set -v
Set =
Set
Reset
Which of the following will remove the resource(s) from the distributed cache?
Delete FILE[S] *
Delete JAR[S] *
Delete ARCHIVE[S] *
All of the mentioned
The CLI when invoked without the -i option will attempt to load $HIVE_HOME/bin/.hiverc and $HOME/.hiverc as _______ files.
Processing
Termination
Initialization
None of the mentioned
Use ________ and embed the schema in the create statement.
schema.literal
schema.lit
row.literal
All of the mentioned
To force Hive to be more verbose, it can be started with ___________.
*hive –hiveconf hive.root.logger=INFO,console*
*hive –hiveconf hive.subroot.logger=INFO,console*
*hive –hiveconf hive.root.logger=INFOVALUE,console*
All of the mentioned
An ORC file contains groups of row data called __________.
Postscript
Stripes
Script
None of the mentioned
