Hive Quiz 1 | Englishfreetest.com

  • Do test 20 minutes
  • Number Questions: 10 questions
  • By: englishfreetest.com
Do test

Here's the exercise 'Hive Quiz 1 | Englishfreetest.com' about Technical Quiz - Technical Tests.


Put your knowledge about all things technology to the test Because everything tech, from computers and the internet to software and big data, changes rapidly on a day-to-day basis, it’s now a must to stay up to date with the technology that dominates our modern day lives. Are you up to speed on what’s going on in the tech industry today? Take our quiz to find out. Test how much you know about technology

You can find more to the lesson and more exercises. Technical Quiz - Technical Tests in here.

Finally, click here to "Test" for start practice exercise .

  • Test content
    Question 1: Which of the following is not a complex data type in Hive?
    A. Matrix
    B. array
    C. struct
    D. none of the above
    Question 2: Each database created in hive is stored as
    A. a directory
    B. a file
    C. a hdfs block
    D. a jar file
    Question 3: Point out the correct statement :
    A. Hive Commands are non-SQL statement such as setting a property or adding a resource
    B. Set -v prints a list of configuration variables that are overridden by the user or Hive
    C. Set sets a list of variables that are overridden by the user or Hive
    D. None of the mentioned
    Question 4: Which of the following command sets the value of a particular configuration variable (key)?
    A. set -v
    B. set =
    C. set
    D. reset
    Question 5: If the schema of the table does not match with the data types present in the file containing the table then Hive
    A. Automatically drops the file
    B. Automatically corrects the data
    C. Reports Null values for mismatched data
    D. Does not allow any query to run on the table
    Question 6: In ______ mode HiveServer2 only accepts valid Thrift calls
    A. Remote
    B. HTTP
    C. Embedded
    D. Interactive
    Question 7: In Hive SerDe stands for
    A. serialize and Deserialize
    B. serializer and Deserializer
    C. Serialize and Destruct
    D. serve and destruct
    Question 8: Point out the wrong statement:
    A. bfs executes a dfs command from the Hive shell
    B. source FILE executes a script file inside the CLI
    C. hive is Query language similar to SQL
    D. none of the mentioned
    Question 9: Which of the following is a command line option?
    A. -d,–define
    B. -e,–define
    C. -f,–define
    D. None of the mentioned
    Question 10: 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