Hive Quiz 1

Hive Quiz 1

Hi One and all welcome to hive practice session ..
add your mail Id in Comment and score so we can help you directional working, learn hive and be a expert.

1. The partition of an Indexed table is dropped. then,
Corresponding partition from all indexes are dropped.
No indexes are dropped
Indexes refresh themselves automatically
Error is shown asking to first drop the indexes

2. What Hive can not offer
storing data in tables and columns
Online transaction processing
Handling date time data
Partitioning stored data

3. The results of a hive query can be stored as
local file
hdfs file
both
can not be stored

4. Which of the following is not a complex data type in Hive?
Matrix
Array
Map
STRUCT

5. If the database contains some tables then it can be forced to drop without dropping the tables by using the keyword
RESTRICT
OVERWRITE
DROP
CASCADE

6. Using the ALTER DATABASE command in an database you can change the
database name
database creation time
directory where the database is stored
db properties

7. In Hive you can copy
The schema without the data
The data without the schema
Both schema and it's data
neither the schema nor its data

8. To see the data types details of only a column notthetable we should use the command
DESCRIBE EXTENDED
DESCRIBE FORMATTED
DESCRIBE COLUMN
DESCRIBE


Score =
Correct answers:


For more quiz Visit: Quiz Index

Tags: hive practice, learn hive through quiz, hive for all, hive quiz show