Sail E0 Webinar

MCQs

Total Questions : 16 | Page 1 of 2 pages
Question 1. Which of the following is a command line option ?
  1.    -d,"“define
  2.    -e,"“define
  3.    -f,"“define
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> -d,"“define


Variable substitution to apply to hive commands. e.g. -d A=B or “define A=B.


Question 2. Use ________ and embed the schema in the create statement.
  1.    schema.literal
  2.    schema.lit
  3.    row.literal
  4.    All of the mentioned
 Discuss Question
Answer: Option A. -> schema.literal


You can embed the schema directly into the create statement.


Question 3. Integral literals are assumed to be _________ by default.
  1.    SMALL INT
  2.    INT
  3.    BIG INT
  4.    TINY INT
 Discuss Question
Answer: Option B. -> INT


Integral literals are assumed to be INT by default, unless the number exceeds the range of INT in which case it is interpreted as a BIGINT, or if one of the following postfixes is present on the number.


Question 4. Hive uses _____-style escaping within the strings.
  1.    C
  2.    Java
  3.    Python
  4.    Scala
 Discuss Question
Answer: Option A. -> C


String literals can be expressed with either single quotes (') or double quotes (").


Question 5. _______ is interpolated into the quotes to correctly handle spaces within the schema.
  1.    $SCHEMA
  2.    $ROW
  3.    $SCHEMASPACES
  4.    $NAMESPACES
 Discuss Question
Answer: Option A. -> $SCHEMA


Use none to ignore either avro.schema.literal or avro.schema.url.


Question 6. Point out the wrong statement :
  1.    There are four namespaces for variables in Hive
  2.    Custom variables can be created in a separate namespace with the define
  3.    Custom variables can also be created in a separate namespace with hivevar
  4.    None of the mentioned
 Discuss Question
Answer: Option D. -> None of the mentioned


Three namespaces for variables are hiveconf, system, and env.


Question 7. Point out the wrong statement :
  1.    HiveServer2 has a new JDBC driver
  2.    CSV and TSV output formats are maintained for forward compatibility
  3.    HiveServer2 supports both embedded and remote access to HiveServer2
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> CSV and TSV output formats are maintained for forward compatibility


CSV and TSV output formats are maintained for backward compatibility.


Question 8. hiveconf variables are set as normal by using the following statement :
  1.    set -v x=myvalue
  2.    set x=myvalue
  3.    reset x=myvalue
  4.    None of the mentioned
 Discuss Question
Answer: Option D. -> None of the mentioned


The hiveconf variables are set as normalby set x=myvalue.


Question 9. The ________ allows users to read or write Avro data as Hive tables.
  1.    AvroSerde
  2.    HiveSerde
  3.    SqlSerde
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> AvroSerde


AvroSerde understands compressed Avro files.


Question 10. HCatalog is installed with Hive, starting with Hive release
  1.    0.10.0
  2.    0.9.0
  3.    0.11.0
  4.    0.12.0
 Discuss Question
Answer: Option C. -> 0.11.0


hcat commands can be issued as hive commands, and vice versa.


Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0