Sql Interview Questions | Glassdoor.co.in

Sql Interview Questions

406

sql interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

SQL - Trigger, Stored Procedure, SQL Basics, truncate & delete HR - Joins, Multirow functions

4 Answers

Trigger is a kind of special stored procedure which will execute automatically when a when an event occures in database server.

Stored procedure is a prepared SQL code which is saved for reusing.

Truncate is similar to the delete command but it removes entire table. Delete is the command Which is used to remove some data by using where clause.

1. Aptitude, reasoning, English, C, C++ 2. Project 3. WAP for bubble sort. 4. WAQ for having clause 5. Multiple inheritance 6. OOPs concept

2 Answers

Different types of joins.

2 Answers

Delete duplicate records from a table

2 Answers

Security

2 Answers

Puzzle: A coin is in one of the inverted bags. First bag says 'Coin is in third bag', second says: 'There is no coin here' and third says: 'There is no coin here'. Considering one statement is true while two are false, where is the coin?

2 Answers

I have weight machine, I put 100 KG gold on one side and 100 KG cotton on another side, which weight is heavier??

2 Answers

find top 10 employee by using DENSE RANK.? SELECT 10 FROM DUAL MINUS SELECT 5 FROM DUAL.? Query for deleting duplicate rows. Write a procedure to store all the data from a table to a collection table.

2 Answers

Q1: What are triggers? Q2: what are joins and state its types? Q3: What is View?Can we insert, update, delete on view? Q4: What are Aggregate functions?

2 Answers

Calculate the no of exp of the employees from the joining date from table?

2 Answers
110 of 406 Interview Questions