[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation 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 :