Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    IBM Data Analyst

    Uploaded by

    shankar das
    Interview questions

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    IBM Data Analyst

    Uploaded by

    shankar das
    19 views2 pages
    Interview questions

    Original Title

    IBM Data Analyst.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Interview questions

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    19 views2 pages

    IBM Data Analyst

    Uploaded by

    shankar das
    Interview questions

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Question set 1

    1. What is a Self-Join?

    A self-join is a type of join that can be used to connect two tables. As a result, it is a unary relationship.
    Each row of the table is attached to itself and all other rows of the same table in a self-join. As a result, a
    self-join is mostly used to combine and compare rows from the same database table.

    2. What is OLTP?

    OLTP, or online transactional processing, allows huge groups of people to execute massive amounts of
    database transactions in real time, usually via the internet. A database transaction occurs when data in a
    database is changed, inserted, deleted, or queried.

    3. What is the difference between joining and blending in Tableau?

    Joining term is used when you are combining data from the same source, for example, worksheet in an
    Excel file or tables in Oracle databaseWhile blending requires two completely defined data sources in
    your report.

    4. How to prevent someone from copying the cell from your worksheet in excel?

    If you want to protect your worksheet from being copied, go into Menu bar > Review > Protect sheet >
    Password.

    By entering password you can prevent your worksheet from getting copied.

    Question set 2

    1. What is Density-based Clustering?


    Density-Based Clustering is an unsupervised machine learning method that identifies different groups or
    clusters in the data space. These clustering techniques are based on the concept that a cluster in the data
    space is a contiguous region of high point density, separated from other such clusters by contiguous
    regions of low point density.
    Partition-based(K-means) and Hierarchical clustering techniques are highly efficient with normal-shaped
    clusters while density-based techniques are efficient in arbitrary-shaped clusters or detecting outliers.

    2. How to create empty tables with the same structure as another table?
    To create empty tables:
    Using the INTO operator to fetch the records of one table into a new table while setting a WHERE clause
    to false for all entries, it is possible to create empty tables with the same structure. As a result, SQL
    creates a new table with a duplicate structure to accept the fetched entries, but nothing is stored into the
    new table since the WHERE clause is active.

    3. What is a Parameter in Tableau? Give an Example.

    A parameter is a dynamic value that a customer could select, and you can use it to replace
    constant values in calculations, filters, and reference lines.

    For example, when creating a filter to show the top 10 products based on total profit instead of
    the fixed value, you can update the filter to show the top 10, 20, or 30 products using a
    parameter.

    4. How will you write the formula for the following in Excel? - Multiply the value in cell A1 by 10,
    add the result by 5, and divide it by 2.

    To write a formula for the above-stated question, we have to follow the PEDMAS Precedence.
    The correct answer is ((A1*10)+5)/2.

    Answers such as =A1*10+5/2 and =(A1*10)+5/2 are not correct. We must put parentheses
    brackets after a particular operation.

    You might also like