Databases & DBA Interview Questions

Recently Posted

Job Title

0

Answer

Alter a null column to set default value to 0 in SQL server.. In Production environment.

Esakki Muthu
6y Reply
1

Answer

What is Offline data warehouse, real time datawarehouse and Integrated data warehouse?

Debi Prasad Ratha
7y Reply
9

Answers

What is the difference between where clause and having Clause?

Vsd Vsd
8y Reply
2

Answers

What is the difference between mysql and mysqli?

Bhushan Singh
8y Reply
2

Answers

What is the difference between inner and outer join? Explain with example.

Vishal Prajapati
8y Reply
1

Answer

Write a code in such a way that my SQL connection should be always connected?

Rahul Chavan
8y Reply
16

Answers

What is the use of @@ROWCOUNT statement?

Rahul Chavan
8y Reply
10

Answers

Can we have trigger on DDL statements?

Rahul Chavan
8y Reply
4

Answers

What is use of NoLock?

Rahul Chavan
8y Reply
4

Answers

Write a simple stored procedure code with Parameter?

Rahul Chavan
8y Reply
8

Answers

Find 5th Highest salary in LinQ , SQL server, write code in C# 2.0. Is there any inbuilt function in C# which can give us direct output as Highest 5th Salary.?

Vivek Sheth
8y Reply
2

Answers

what is Packaging databases ?? what are benefit of it ?

Rupali Shinde
8y Reply
4

Answers

SQL View is formed by joins of two table. if we modify view by some query , can corresponding records from both table are getting updated ?

Rupali Shinde
8y Reply
13

Answers

What is sub-query ?

Sandeep Kumar
9y Reply
39

Answers

How many types of Temporary Tables.

ajeet verma
9y Reply

View More