Database faqs, question answers



Click the following link(s) to view/answer Database faqs, question answers.
What is a NOLOCK in Sql Server?
1 answer(s) | 1066 Views | Tags: Sql Server Interview, Database | Asked By: manish

What are different normalization forms in Sql?
1 answer(s) | 1067 Views | Tags: Sql Interview, Database | Asked By: jack

What is sub-query? Explain properties of sub-query.
1 answer(s) | 914 Views | Tags: Sql Server Interview, Database | Asked By: jack

What is data integrity? Explain constraints?
1 answer(s) | 933 Views | Tags: Sql Server Interview, Database, Sql Server Constraints | Asked By: jack

Main classes/Components of ADO.NET?
1 answer(s) | 964 Views | Tags: ADO.NET, .Net Framework | Asked By: Rick

What are the difference between clustered and a non clustered index?
1 answer(s) | 565 Views | Tags: Sql Server Interview, Database, Sql Server Indexes | Asked By: kethlin

What are different Types of Join we use in Sql Server?
1 answer(s) | 1121 Views | Tags: Sql Server Interview, Database, Sql Server Joins | Asked By: kethlin

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
1 answer(s) | 931 Views | Tags: Sql Server Interview, Database | Asked By: Gourav

What is difference between DELETE & TRUNCATE commands?
1 answer(s) | 670 Views | Tags: Sql Server Interview, Database | Asked By: manish

What are the advantages of using Stored Procedures?
1 answer(s) | 508 Views | Tags: Sql Server Interview, Database | Asked By: manish

What is an execution plan? When would you use it?
1 answer(s) | 490 Views | Tags: Sql Server Interview, Database | Asked By: Gourav

What is schema in ORACLE? What are Schema Objects?
1 answer(s) | 266 Views | Tags: ORACLE Interview, Database Interview | Asked By: kevin

Difference between a FUNCTION, PROCEDURE and PACKAGE in ORACLE?
1 answer(s) | 1619 Views | Tags: ORACLE Interview, Database, SQL Interview | Asked By: Gurjinder Singh