Hive Online Quiz

Q 1 - The partition of an Indexed table is dropped. then,

A - Corresponding partition from all indexes are dropped.

B - No indexes are dropped

C - Indexes refresh themselves automatically

D - Error is shown asking to first drop the indexes

Q 2 - In Hive you can copy

A - The schema without the data

B - The data without the schema

C - Both schema and it's data

D - neither the schema nor its data

Q 3 - SerDe

A - parses records to columns while reading and columns to records when writing

B - parses records to columns while writing and columns to records when reading

C - creates partitions from columns using each of the records

D - applies only to files of type TEXTFILE

Q 4 - While querying a hive table for a Array type column, if the array index is nonexistent then

A - NULL is returned

B - Error is reported.

C - Partial results are returned

D - "NA" is returned

Q 5 - Consider the query SELECT explode(city_locality) from ALL_LOCALITIES , where city_locality is a ARRAY dat atype. This will return

A - all th array elements as one row for each input array

B - zero or more rows, for each element for each input array

C - Each of the array element as one column for each input array

D - zero ormore columns for each element for each input array

Q 6 - A view in Hive can be seen by using

A - SHOW TABLES

B - SHOW VIEWS

C - DESCRIBE VIEWS

D - VIEW VIEWS

Q 7 - Indexes can be created

A - only on managed tables

B - only on views

C - Only on external tables

D - only on views with partitions

Q 8 - The default limit to the number of rows returned by a query can be done using which of the following parameter?

A - hive.limit.optimize.enable

B - hive.limit.enable.optimize

C - hive.optimize.enable.limit

D - hive.enable.limit.optimize

Q 9 - The command to list the functions currently loaded in a Hive Session is

A - LIST FUNCTIONS

B - SHOW FUNCTIONS

C - DECSRIBE FUNCTIONS

D - FIND FUNCTIONS

Q 10 - To add a new user defined Function permanently to Hive, we need to

A - Create a new version of HIve

B - Add the .class Java code to FunctionRegistry

C - Add the .jar Java code to FunctionRegistry

D - Add the .jar java code to $HOME/.hiverc