Following quiz provides Multiple Choice Questions (MCQs) related to Hive. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - Each database created in hive is stored as
Each database becomes a directory and each table becomes a file in that directory
Q 2 - On dropping an external table
As the data is stored externally Hive only drops the schema.
Q 3 - The main advantage of creating table partition is
Partitioning creates subdirectories and only those subdirectories are read to fetch the query result, improving the performance.
Q 4 - The position of a specific column in a Hive table
It is up to the user to ensure the synchronization between schema and data
Q 5 - The CONCAT string function in Hive can concatenate
CONCAT function accepts any number of arguments
Q 6 - Which kind of keys(CONSTRAINTS) Hive can have?
Hive is schema on read and unlike RDBMS it does not have a way to enforce the existence of keys.
Q 7 - The identifiers in HiveQL are
Hive is case insensitive
Q 8 - Which of the following scenarios are not prevented by enabling strict mode in Hive?
The other three scenarios create long running job. So STRICT mode is applied to them.
Q 9 - A Table Generating Function is a Function that
Examples functions is Explode()
Q 10 - Hive supports row-level Inser/update and Delete using the ACID features only on which file format?
Except the ORC file all other files types do not support insert or update.