Hive Test

Local File ✘ HDFS file ✘ Both the above ✘ Can not be stored ✔

RESTRICT ✘ OVERWRITE ✘ F DROP ✘ CASCADE ✔

SET SERDEPRPERTIES ✘ WITH SERDEPRPERTIES ✘ BY SERDEPRPERTIES ✘ CONFIG SERDEPRPERTIES ✔

hive.exec.mode.local.auto ✘ hive.exec.mode.local.override ✘ hive.exec.mode.local.settings ✘ hive.exec.mode.local.config ✔

Primary Keys ✘ Foreign Keys ✘ Unique Keys ✘ None of the above ✔

It slows down the namenode ✘ Storage space is wasted ✘ Join quires become slow ✘ All of the above ✔

\001' ✘ \oo2' ✘ \oo3' ✘ \oo4' ✔

The tables are also deleted ✘ The directory is deleted if there are no tables ✘ The HDFS blocks are formatted ✘ None of the above ✔

Effective storage memory utilization ✘ Faster query performance ✘ Less RAM required by namenode ✘ Simpler query syntax ✔

Automatically drops the file ✘ Automatically corrects the data ✘ Reports Null values for mismatched data ✘ Does not allow any query to run on the table ✔