Databases & DBA Interview Questions

View All

Job Function

What is Domain Integrity in RDBMS?
Techspawn | Fresher on Apr 30, 2019
2
How to check Index Fragmentation and when to perform Index Rebuild OR Index Reorganize?
NA | Developer on Nov 17, 2018
2
What is a Heap?
tech | Developer on Sep 26, 2018
2
What are Interpreted Queries?
credo softwares | Sr. Programmer on Jan 27, 2018
Be the 1st to Answer
What do you understand by Logon Triggers in SQL Server (All Versions).
Truelogics Infotech Pvt.Ltd. | Project Lead on Jan 27, 2018
Be the 1st to Answer
Define Lead and Lag functions in SQL.
credo softwares | Sr. Programmer on Jan 27, 2018
1
Alter a null column to set default value to 0 in SQL server.. In Production environment.
Cognizant | Senior Management on Nov 30, 2017
6
What is Offline data warehouse, real time datawarehouse and Integrated data warehouse?
Capgemini | Fresher on Aug 22, 2017
1
What is the difference between where clause and having Clause?
NCORD Healthcard | DBA on Sep 10, 2016
9
What is the difference between mysql and mysqli?
HCL | DBA on Jul 05, 2016
2
What is the difference between inner and outer join? Explain with example.
Tatvasoft | DBA on May 03, 2016
7
Write a code in such a way that my SQL connection should be always connected?
excellonsoft | Sr. Developer on Apr 07, 2016
2
What is the use of @@ROWCOUNT statement?
excellonsoft | Sr. Developer on Apr 07, 2016
17
Can we have trigger on DDL statements?
excellonsoft | Sr. Developer on Apr 07, 2016
5
What is use of NoLock?
excellonsoft | Sr. Developer on Apr 07, 2016
4

View More

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS

Alter a null column to set default value to 0 in SQL server.. In Production environment. What are Interpreted Queries? What is a Heap? What is Offline data warehouse, real time datawarehouse and Integrated data warehouse? Define Lead and Lag functions in SQL. What do you understand by Logon Triggers in SQL Server (All Versions). What is Domain Integrity in RDBMS? select 2nd highest salary What is the difference between TRUNCATE and DROP? Write a code in such a way that my SQL connection should be always connected?