Home / CSE MCQs / Sqoop ::

CSE MCQs :: Sqoop

  1. The following tool imports a set of tables from an RDBMS to HDFS
  2. A.
    export-all-tables
    B.
    import-all-tables
    C.
    import-tables
    D.
    none of the mentioned

  3. _________ tool can list all the available database schemas.
  4. A.
    Sqoop-list-tables
    B.
    sqoop-list-databases
    C.
    sqoop-list-schema
    D.
    sqoop-list-columns

  5. The fields parsed by ____________ are backed by an internal buffer.
  6. A.
    LargeObjectLoader
    B.
    ProcessingException
    C.
    RecordParser
    D.
    None of the Mentioned

  7. The export and import of data between sqoop and relational system happens through which of the following programs?
  8. A.
    Sqoop client program
    B.
    Mapreduce job submitted by the sqoop command
    C.
    Database stores procedure
    D.
    Hdfs file management program

  9. ________ text is appropriate for most non-binary data types.
  10. A.
    Character
    B.
    Binary
    C.
    Delimited
    D.
    None of the mentioned

  11. Point out the wrong statement:
  12. A.
    Abstract base class that holds a reference to a Blob or a Clob
    B.
    ACCESSORTYPE is the type used to access this data in a streaming fashion
    C.
    CONTAINERTYPE is the type used to hold this data (e.g., BytesWritable)
    D.
    None of the mentioned

  13. Mention the best features of Apache Sqoop.
  14. A.
    Parallel import/export
    B.
    Connectors for all major RDBMS Databases
    C.
    Import results of SQL query
    D.
    All of these

  15. How can you avoid importing tables one-by-one when importing a large number of tables from a database?
  16. A.
    Connect
    B.
    Username
    C.
    Password
    D.
    All of these

  17. BigDecimal is comprised of a ________ with an integer 'scale' field.
  18. A.
    BigInt
    B.
    BigInteger
    C.
    MediumInt
    D.
    SmallInt

  19. The tool that populates a Hive meta store with a definition for a table based on a database table previously imported to HDFS is
  20. A.
    create-hive-table
    B.
    import-hive-meta store
    C.
    create-hive-metastore
    D.
    update-hive-meta store