Technical Interview Questions and Answers :: SQL
- Declare a
11 / 108
12 / 108
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.
13 / 108
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
14 / 108
A
15 / 108
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
16 / 108
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
17 / 108
No Discussion on this question yet!
18 / 108
No Discussion on this question yet!
19 / 108
Rank () :
200,300,300,400
rank o/p : 1,2,4
Dense_Rank () :
200,300,300,400
Dense_rank o/p : 1,2,3
20 / 108
No Discussion on this question yet!