Databases & DBA Interview Questions

Job Function

What is Domain Integrity in RDBMS?
Apr 30, 2019
3
How to check Index Fragmentation and when to perform Index Rebuild OR Index Reorganize?
Nov 17, 2018
2
What is a Heap?
Sep 26, 2018
2
What is Database Cloning?
Jan 29, 2018
Be the 1st to Answer
What are Interpreted Queries?
Jan 27, 2018
Be the 1st to Answer
What do you understand by Logon Triggers in SQL Server (All Versions).
Jan 27, 2018
Be the 1st to Answer
Define Lead and Lag functions in SQL.
Jan 27, 2018
1
Alter a null column to set default value to 0 in SQL server.. In Production environment.
Nov 30, 2017
7
What is Offline data warehouse, real time datawarehouse and Integrated data warehouse?
Aug 22, 2017
1
What is the difference between where clause and having Clause?
Sep 10, 2016
9
What is the difference between mysql and mysqli?
Jul 05, 2016
2
What is the difference between inner and outer join? Explain with example.
May 03, 2016
7
Write a code in such a way that my SQL connection should be always connected?
Apr 07, 2016
2
What is the use of @@ROWCOUNT statement?
Apr 07, 2016
17
Can we have trigger on DDL statements?
Apr 07, 2016
5

View More