MCQGeeks
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Hadoop
Hive Interview
Quiz 1
Solution
Q.1.
Avro-backed tables can simply be created by using _________ in a DDL statement.
a) “STORED AS AVRO”
b) “STORED AS HIVE”
c) “STORED AS AVROHIVE”
d) “STORED AS SERDE”
Q.2.
Point out the correct statement.
a) Avro Fixed type should be defined in Hive as lists of tiny ints
b) Avro Bytes type should be defined in Hive as lists of tiny ints
c) Avro Enum type should be defined in Hive as strings
d) All of the mentioned
Q.3.
Types that may be null must be defined as a ______ of that type and Null within Avro.
a) Union
b) Intersection
c) Set
d) All of the mentioned
Q.4.
The files that are written by the _______ job are valid Avro files.
a) Avro
b) Map Reduce
c) Hive
d) All of the mentioned
Q.5.
Point out the wrong statement.
a) To create an Avro-backed table, specify the serde as org.apache.hadoop.hive.serde2.avro.AvroSerDe
b) Avro-backed tables can be created in Hive using AvroSerDe
c) The AvroSerde cannot serialize any Hive table to Avro files
d) None of the mentioned
Q.6.
Use ________ and embed the schema in the create statement.
a) schema.literal
b) schema.lit
c) row.literal
d) all of the mentioned
Q.7.
_______ is interpolated into the quotes to correctly handle spaces within the schema.
a) $SCHEMA
b) $ROW
c) $SCHEMASPACES
d) $NAMESPACES
Q.8.
To force Hive to be more verbose, it can be started with ___________
a) *hive –hiveconf hive.root.logger=INFO,console*
b) *hive –hiveconf hive.subroot.logger=INFO,console*
c) *hive –hiveconf hive.root.logger=INFOVALUE,console*
d) All of the mentioned
Q.9.
________ was designed to overcome limitations of the other Hive file formats.
a) ORC
b) OPC
c) ODC
d) None of the mentioned
Q.10.
An ORC file contains groups of row data called __________
a) postscript
b) stripes
c) script
d) none of the mentioned
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page