Hive Online Quiz

Q 1 - Each database created in hive is stored as

A - a directory

B - a file

C - a hdfs block

D - a jar file

Q 2 - On dropping an external table

A - The schema gets dropped without dropping the data

B - The data gets dropped without dropping the schema

C - An error is thrown

D - Both the schema and the data is dropped

Q 3 - The main advantage of creating table partition is

A - Effective storage memory utilization

B - faster query performance

C - Less RAM required by namenode

D - simpler query syntax

Q 4 - The position of a specific column in a Hive table

A - can be anywhere in the table creation clause

B - must match the position of the corresponding  data in the data file

C - Must match the position only for date time data type in the data file

D - Must be arranged alphabetically

Q 5 - The CONCAT string function in Hive can concatenate

A - only 2 strings

B - any number of paired strings

C - any number of strings

D - only strings of equal length

Q 6 - Which kind of keys(CONSTRAINTS)  Hive can have?

A - Primary Keys

B - Foreign Keys

C - Unique Keys

D - None

Q 7 - The identifiers in HiveQL are

A - case sensitive

B - case insensitive

C - sometimes case sensitive

D - Depends on the Hadoop environment

Q 8 - Which of the following scenarios are not prevented by enabling strict mode in Hive?

A - Scanning all the partitions

B - Generating random sample of data

C - Running a order by clause without a LIMIT clause

D - Cartesian product

Q 9 - A Table Generating Function is a Function that

A - Takes one or more columns form a row and returns a single value

B - Takes one or more columns form many rows and returns a single value

C - Take zero or more inputs and produce multiple columns or rows of output

D - Detects the type of input programmatically and provides appropriate response

Q 10 - Hive supports row-level Inser/update and Delete using the ACID features only on which file format?

A - SequenceFile

B - Text File

C - ORC file

D - RC file