Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. The following tool imports a set of tables from an RDBMS to HDFS
  1.    export-all-tables
  2.    import-all-tables
  3.    import-tables
  4.    none of the mentioned
 Discuss Question
Answer: Option C. -> import-tables




Question 2. ________ text is appropriate for most non-binary data types.
  1.    Character
  2.    Binary
  3.    Delimited
  4.    None of the mentioned
 Discuss Question
Answer: Option C. -> Delimited




Question 3. _________ tool can list all the available database schemas.
  1.    Sqoop-list-tables
  2.    sqoop-list-databases
  3.    sqoop-list-schema
  4.    sqoop-list-columns
 Discuss Question
Answer: Option B. -> sqoop-list-databases




Question 4. The fields parsed by ____________ are backed by an internal buffer.
  1.    LargeObjectLoader
  2.    ProcessingException
  3.    RecordParser
  4.    None of the Mentioned
 Discuss Question
Answer: Option C. -> RecordParser




Question 5. The export and import of data between sqoop and relational system happens through which of the following programs?
  1.    Sqoop client program
  2.    Mapreduce job submitted by the sqoop command
  3.    Database stores procedure
  4.    Hdfs file management program
 Discuss Question
Answer: Option B. -> Mapreduce job submitted by the sqoop command




Question 6. Point out the wrong statement:
  1.    Abstract base class that holds a reference to a Blob or a Clob
  2.    ACCESSORTYPE is the type used to access this data in a streaming fashion
  3.    CONTAINERTYPE is the type used to hold this data (e.g., BytesWritable)
  4.    None of the mentioned
 Discuss Question
Answer: Option D. -> None of the mentioned




Question 7. The tool that populates a Hive meta store with a definition for a table based on a database table previously imported to HDFS is
  1.    create-hive-table
  2.    import-hive-meta store
  3.    create-hive-metastore
  4.    update-hive-meta store
 Discuss Question
Answer: Option B. -> import-hive-meta store




Question 8. How can you avoid importing tables one-by-one when importing a large number of tables from a database?
  1.    Connect
  2.    Username
  3.    Password
  4.    All of these
 Discuss Question
Answer: Option D. -> All of these




Question 9. Mention the best features of Apache Sqoop.
  1.    Parallel import/export
  2.    Connectors for all major RDBMS Databases
  3.    Import results of SQL query
  4.    All of these
 Discuss Question
Answer: Option D. -> All of these




Question 10. BigDecimal is comprised of a ________ with an integer 'scale' field.
  1.    BigInt
  2.    BigInteger
  3.    MediumInt
  4.    SmallInt
 Discuss Question
Answer: Option B. -> BigInteger




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