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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum