Menu
Home / CSE MCQs / Sqoop ::

CSE MCQs :: Sqoop

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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. The export and import of data between sqoop and relational system happens through which of the following programs?
    5. 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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Point out the wrong statement:
    7. 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

  7. Mention the best features of Apache Sqoop.
    8. 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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. The tool that populates a Hive meta store with a definition for a table based on a database table previously imported to HDFS is
    11. 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

Java Programming Questions and Answers Interview Questions and Answers