Explore topic-wise MCQs in Apache Hadoop.

This section includes 73 Mcqs, each offering curated multiple-choice questions to sharpen your Apache Hadoop knowledge and support exam preparation. Choose a topic below to get started.

1.

CompsciEdu is generating huge amount of data. They are generating huge amount of sensor data from different mcqs which was unstructured in form. They moved to Hadoop framework for storing and analyzing data. What technology in Hadoop framework, they can use to analyse this unstructured data?

A. MapReduce programming
B. Hive
C. RDBMS
D. None of the above
Answer» B. Hive
Discussion
2.

Which of the following is/are INCORRECT with respect to Hive?

A. Hive provides SQL interface to process large amount of data
B. Hive needs a relational database like oracle to perform query operations and store data.
C. Hive works well on all files stored in HDFS
D. both a and b
Answer» C. Hive works well on all files stored in HDFS
Discussion
3.

An ORC file contains groups of row data called __________

A. postscript
B. stripes
C. script
D. none of the mentioned
Answer» C. script
Discussion
4.

Correct and valid syntax for count command is ____________

A. count ‘<row number>’
B. count ‘<table name>’
C. count ‘<column name>’
D. none of the mentioned
Answer» C. count ‘<column name>’
Discussion
5.

Which of the following will prefix the query string with parameters?

A. SET hive.exec.compress.output=false
B. SET hive.compress.output=false
C. SET hive.exec.compress.output=true
D. All of the mentioned
Answer» B. SET hive.compress.output=false
Discussion
6.

Which of the following is not a Features of HiveQL?

A. Supports joins
B. Supports indexes
C. Support views
D. Support Transactions
Answer» E.
Discussion
7.

Which of the following statement will create a column with varchar datatype?

A. CREATE TABLE foo (bar CHAR(10))
B. CREATE TABLE foo (bar VARCHAR(10))
C. CREATE TABLE foo (bar CHARVARYING(10))
D. All of the mentioned
Answer» C. CREATE TABLE foo (bar CHARVARYING(10))
Discussion
8.

Apache HBase is a non-relational database modeled after Google's _________

A. BigTop
B. Bigtable
C. Scanner
D. FoundationDB
Answer» C. Scanner
Discussion
9.

Variable Substitution is disabled by using ___________

A. set hive.variable.substitute=false;
B. set hive.variable.substitutevalues=false;
C. set hive.variable.substitute=true;
D. all of the mentioned
Answer» B. set hive.variable.substitutevalues=false;
Discussion
10.

HCatalog is installed with Hive, starting with Hive release is ___________

A. 0.10.0
B. 0.9.0
C. 0.11.0
D. 0.12.0
Answer» D. 0.12.0
Discussion
11.

_________ command fetches the contents of a row or a cell.

A. select
B. get
C. put
D. none of the mentioned
Answer» C. put
Discussion
12.

hiveconf variables are set as normal by using the following statement?

A. set -v x=myvalue
B. set x=myvalue
C. reset x=myvalue
D. none of the mentioned
Answer» E.
Discussion
13.

When did HBase was first released?

A. April 2007
B. March 2007
C. February 2007
D. May 2007
Answer» D. May 2007
Discussion
14.

We need to store skill set of MCQs(which might have multiple values) in MCQs table, which of the following is the best way to store this information in case of Hive?

A. Create a column in MCQs table of STRUCT data type
B. Create a column in MCQs table of MAP data type
C. Create a column in MCQs table of ARRAY data type
D. As storing multiple values in a column of MCQs itself is a violation
Answer» D. As storing multiple values in a column of MCQs itself is a violation
Discussion
15.

One supported data type that deserves special mention are ____________

A. money
B. counters
C. smallint
D. tinyint
Answer» C. smallint
Discussion
16.

The minimum number of row versions to keep is configured per column family via _____________

A. HBaseDecriptor
B. HTabDescriptor
C. HColumnDescriptor
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
17.

Hive uses _____ style escaping within the strings.

A. C
B. Java
C. Python
D. Scala
Answer» B. Java
Discussion
18.

__________ command disables drops and recreates a table.

A. drop
B. truncate
C. delete
D. none of the mentioned
Answer» C. delete
Discussion
19.

Apache HBase is a non-relational database modeled after Google’s _________

A. BigTop
B. Bigtable
C. Scanner
D. FoundationDB
Answer» C. Scanner
Discussion
20.

HBase is ________ defines only column families.

A. Row Oriented
B. Schema-less
C. Fixed Schema
D. All of the mentioned
Answer» C. Fixed Schema
Discussion
21.

Which command is used to disable all the tables matching the given regex?

A. remove all
B. drop all
C. disable_all
D. all of the mentioned
Answer» D. all of the mentioned
Discussion
22.

Which of the following is not a feature of Hbase?

A. HBase is lateral scalable.
B. It has automatic failure support.
C. It provides consistent read and writes.
D. It has easy java API for client.
Answer» B. It has automatic failure support.
Discussion
23.

To force Hive to be more verbose, it can be started with ___________

A. *hive –hiveconf hive.root.logger=INFO,console*
B. *hive –hiveconf hive.subroot.logger=INFO,console*
C. *hive –hiveconf hive.root.logger=INFOVALUE,console*
D. All of the mentioned
Answer» B. *hive –hiveconf hive.subroot.logger=INFO,console*
Discussion
24.

The files that are written by the _______ job are valid Avro files.

A. Avro
B. Map Reduce
C. Hive
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
25.

What does the hive.rrot.logger specified in the following statement?

A. Log level
B. Log modes
C. Log source
D. All of the mentioned
Answer» B. Log modes
Discussion
26.

When $HIVE_HOME/bin/hive is run without either the -e or -f option, it enters _______ mode.

A. Batch
B. Interactive shell
C. Multiple
D. None of the mentioned
Answer» C. Multiple
Discussion
27.

The CLI when invoked without the -i option will attempt to load $HIVE_HOME/bin/.hiverc and $HOME/.hiverc as _______ files.

A. processing
B. termination
C. initialization
D. none of the mentioned
Answer» D. none of the mentioned
Discussion
28.

Which is the additional command line option is available in Hive 0.10.0?

A. –database <dbname>
B. –db <dbname>
C. –dbase <<dbname>
D. All of the mentioned
Answer» B. –db <dbname>
Discussion
29.

Which of the following is a command line option?

A. -d,–define <key=value>
B. -e,–define <key=value>
C. -f,–define <key=value>
D. None of the mentioned
Answer» B. -e,–define <key=value>
Discussion
30.

Hive specific commands can be run from Beeline, when the Hive _______ driver is used.

A. ODBC
B. JDBC
C. ODBC-JDBC
D. All of the Mentioned
Answer» C. ODBC-JDBC
Discussion
31.

Starting in Hive _______, the Avro schema can be inferred from the Hive table schema.

A. 0.14
B. 0.12
C. 0.13
D. 0.11
Answer» B. 0.12
Discussion
32.

The ________ allows users to read or write Avro data as Hive tables.

A. AvroSerde
B. HiveSerde
C. SqlSerde
D. None of the mentioned
Answer» B. HiveSerde
Discussion
33.

Avro-backed tables can simply be created by using _________ in a DDL statement.

A. “STORED AS AVRO”
B. “STORED AS HIVE”
C. “STORED AS AVROHIVE”
D. “STORED AS SERDE”
Answer» B. “STORED AS HIVE”
Discussion
34.

_________ reduce the amount of informational messages displayed (true) or not (false).

A. –silent=[true/false].
B. –autosave=[true/false].
C. –force=[true/false].
D. All of the mentioned
Answer» B. –autosave=[true/false].
Discussion
35.

The AvroSerde has been built and tested against Hive 0.9.1 and later, and uses Avro _______ as of Hive 0.13 and 0.14.

A. 1.7.4
B. 1.7.2
C. 1.7.3
D. None of the mentioned
Answer» E.
Discussion
36.

Which of the following data type is converted to Array prior to Hive 0.12.0 ?

A. map
B. long
C. float
D. bytes
Answer» E.
Discussion
37.

Which of the following data type is supported by Hive ?

A. map
B. record
C. string
D. enum
Answer» E.
Discussion
38.

Which of the following is used to set transaction isolation level ?

A. –incremental=[true/false].
B. –isolation=LEVEL
C. –force=[true/false].
D. –truncateTable=[true/false].
Answer» C. –force=[true/false].
Discussion
39.

Types that may be null must be defined as a ______ of that type and Null within Avro.

A. Union
B. Intersection
C. Set
D. All of the mentioned
Answer» B. Intersection
Discussion
40.

hiveconf variables are set as normal by using the following statement :

A. set -v x=myvalue
B. set x=myvalue
C. reset x=myvalue
D. none of the mentioned
Answer» E.
Discussion
41.

Variable Substitution is disabled by using :

A. set hive.variable.substitute=false;
B. set hive.variable.substitutevalues=false;
C. set hive.variable.substitute=true;
D. all of the mentioned
Answer» B. set hive.variable.substitutevalues=false;
Discussion
42.

HCatalog is installed with Hive, starting with Hive release

A. 0.10.0
B. 0.9.0
C. 0.11.0
D. 0.12.0
Answer» D. 0.12.0
Discussion
43.

HiveServer2 introduced in Hive 0.11 has a new CLI called __________

A. BeeLine
B. SqlLine
C. HiveLine
D. CLilLine
Answer» B. SqlLine
Discussion
44.

In ______ mode HiveServer2 only accepts valid Thrift calls.

A. Remote
B. HTTP
C. Embedded
D. Interactive
Answer» B. HTTP
Discussion
45.

_______ supports a new command shell Beeline that works with HiveServer2.

A. HiveServer2
B. HiveServer3
C. HiveServer4
D. None of the mentioned
Answer» B. HiveServer3
Discussion
46.

Hive uses _________ for logging.

A. logj4
B. log4l
C. log4i
D. log4j
Answer» E.
Discussion
47.

HBaseAdmin and ____________ are the two important classes in this package that provide DDL functionalities.

A. HTableDescriptor
B. HDescriptor
C. HTable
D. HTabDescriptor
Answer» B. HDescriptor
Discussion
48.

HBase supports a ____________ interface via Put and Result

A. “bytes-in/bytes-out”
B. “bytes-in”
C. “bytes-out”
D. none of the mentioned
Answer» B. “bytes-in”
Discussion
49.

_________ command fetches the contents of row or a cell.

A. select
B. get
C. put
D. none of the mentioned
Answer» C. put
Discussion
50.

The minimum number of row versions to keep is configured per column family via :

A. HBaseDecriptor
B. HTabDescriptor
C. HColumnDescriptor
D. All of the mentioned
Answer» D. All of the mentioned
Discussion