Take FREE!! Online Cocubes Mock Test to Crack various Companies Written Exams.
Practice List of Paytm Coding Questions !!!
Take 30+ FREE!! Online Arithmetic Aptitude Mock test to crack any Exams.

Technical Interview Questions and Answers :: SQL

    11 / 108

    How you can use Cursor under Procedure?
    Answer:

    1. Declare a

    Please Login First :

    12 / 108

    What is commit, savepoint and Rollback?
    Answer:

    To delete the data permanently we use 'commit' statement, to roll the transaction back to a certain point, without rolling back the entire transaction we use 'savepoint', to get deleted data rollback is used.

    Please Login First :

    13 / 108

    What is difference between Procedure and Function?
    Answer:

    Procedure are used as a script



    function are used as a method



    procedure can returned zero , single or multiple values



    function can returned one value which is mandatory



    procedure have input/output parameters



    function have input parameter only



    procedure can not be used in select statement



    function can be used in a select statement

    Please Login First :

    14 / 108

    What is correlated subquery?
    Answer:

    A

    Please Login First :
    Answer:

    USED TO CONVERT HIERACHICAL STRUCTURE TO THE FLAT STRUCTURE. IT IS USED TO JOIN A TABLE ITSELF AS LIKE IF THAT IS THE SECOND TABLE

    Please Login First :

    16 / 108

    What is Mutation of Tables?
    Answer:

    Mutation happens in case of triggers. A 'Mutating table' is a table which is being updated by Insert , update or delete triggers.It can also be a table which is being updated when delete cascade is run. Mutation occurs when a trigger is trying to update a row which it is using currently

    Please Login First :

    17 / 108

    What is Collection? And how many types of Collections are there?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    18 / 108

    What is FORALL statement?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    19 / 108

    What is RANK and DENS_RANK?
    Answer:

    Rank () :

    200,300,300,400

    rank o/p : 1,2,4


    Dense_Rank () :

    200,300,300,400

    Dense_rank o/p : 1,2,3

    Please Login First :

    20 / 108

    What is INDEX and how many types of INDEX are there?
    Answer:

    No Discussion on this question yet!

    Please Login First :


Looking to grab a job as a Database Developer or Administrator? You can easily find SQL technical interview questions and answers on this page. All the questions have been previously asked during the technical rounds in IT companies. You can test your SQL database knowledge by solving these questions and compare your chances of fetching the job with a top IT company.

Are you targeting a specific IT company like Adobe? You can filter the question set by the company name easily. If you are not sure about a specific answer, you can easily click and read the answer along with the explanation. So, check these SQL technical interview questions and answers to prepare for your dream job.