Querying with Hive MCQ question and answer with solution

Home

Competitive Exams MCQs

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer Fundatmental MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Python AI(Artificial Intelligence)

Engineering Subjects MCQs

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering MCQs

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering Metallurgical Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry

Computer Fundamentals MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Networking Database SQL MySQL

Programming MCQs

C Programming C++ Programming Java Python PHP JavaScript

Advanced Programming MCQs

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Agriculture Sociology Psychology Home Science Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

Exam Categories

SSC Exams Railway Exams All Exams

SSC Exams

SSC CGL SSC CHSL SSC MTS SSC CPO SSC GD SSC JHT SSC Selection Post SSC Stenographer SSC JE

Railway Exams

RRB ALP RRB Technician RRB Section Controller RRB JE RRB Paramedical RRB Group D

Popular Exams

SSC CGL SSC CHSL SSC MTS RRB NTPC (Graduate) RRB Group D RRB ALP RRB Technician RRB Section Controller

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

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

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

A) BigTop B) Bigtable C) Scanner D) FoundationDB

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

HBase supports a . . . . . . . . interface via Put and Result.

A) "bytes-in/bytes-out" B) "bytes-in" C) "bytes-out" D) none of the mentioned

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

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

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

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

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Point out the wrong statement.

A) HiveServer2 has a new JDBC driver B) CSV and TSV output formats are maintained for forward compatibility C) HiveServer2 supports both embedded and remote access to HiveServer2 D) None of the mentioned

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

Which of the following command does not operate on tables?

A) enabled B) disabled C) drop D) all of the mentioned

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

Point out the wrong statement.

A) There are four namespaces for variables in Hive B) Custom variables can be created in a separate namespace with the define C) Custom variables can also be created in a separate namespace with hivevar D) None of the mentioned

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Which of the following will remove the resource(s) from the distributed cache?

A) delete FILE[S] <filepath>* B) delete JAR[S] <filepath>* C) delete ARCHIVE[S] <filepath>* D) all of the mentioned

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

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

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

1 2 3 4 5 6 7

Querying with Hive MCQ question and answer with solution | Hadoop MCQs