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!
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.