Databases & DBA Interview Questions

Recently Posted

Job Title

4

Answers

What is Domain Integrity in RDBMS?

Shital Pawar
5y Reply
1

Answer

What is the difference between Top 1 and Top 1 1 in SQL Query

Jenith Thakkar
6y Reply
2

Answers

How to deal with dirty read update? multiple user read same data at same time and update back.

Arvind Singh
6y Reply
2

Answers

How to check Index Fragmentation and when to perform Index Rebuild OR Index Reorganize?

Rohit Kainth
6y Reply
4

Answers

What is a Heap?

Rohit Kainth
6y Reply
2

Answers

What is Database Cloning?

Gajendra Jangid
7y Reply
1

Answer

What are Interpreted Queries?

Gajendra Jangid
7y Reply
1

Answer

Define Lead and Lag functions in SQL.

Gajendra Jangid
7y Reply
2

Answers

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

Debi Prasad Ratha
7y Reply
10

Answers

What is the difference between where clause and having Clause?

Vishal Dusane
8y Reply
2

Answers

What is the difference between mysql and mysqli?

Bhushan Singh
8y Reply
7

Answers

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

Vishal Prajapati
8y Reply
2

Answers

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

Rahul Chavan
8y Reply
17

Answers

What is the use of @@ROWCOUNT statement?

Rahul Chavan
8y Reply
5

Answers

Can we have trigger on DDL statements?

Rahul Chavan
8y Reply

1
2
3
4
5

16 - 30 of 221