Hi This is the first part of SQL server Interview quesitons and further Parts will be updated soon…….. SQL SERVER INTERVIEW QUESTIONS PART-1 MySQL interview questions 1  How can we create a database using PHP and mysql? We can create MySQL database with the use of mysql_create_db(“Database_Name”) or $sql = ‘CREATE DATABASE `database_name`’; if (mysql_query($sql, $link)) echo “Database my_db created successfully\n”; else echo ‘Error creating database: ‘ . mysql_error() . “\n”; 2              What are the [...]

1.1.   MS SQL Server Interview Questions with Expected Answers 1.1.1.                  Basics What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version? Ans. This question is generally asked to see how current your knowledge is. Generally there is a section in the beginning of the books online titled “What’s New”, [...]

1.1.   Constraints Constraints allow you to define the way Microsoft® SQL Server™ 2000 automatically enforces the integrity of a database. Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. Using constraints is preferred to using triggers, rules, and defaults. The query optimizer also uses constraint definitions to build high-performance query execution plans. 1.1.1.                  Classes of Constraints SQL Server 2000 supports five classes of constraints. NOT NULL specifies [...]

1.      SQL Server 2000 Reading Material This reading material is intended to provide basic knowledge in SQL Server 2000 for the testers. 1.1.   Database Normalization Basics If you’ve been working with databases for a while, chances are you’ve heard the term normalization. Perhaps someone’s asked you “Is that database normalized?” or “Is that in BCNF?” All too often, the reply is “Uh, yeah.” Normalization is often brushed aside as a luxury that only academics have [...]

Sql Interview Questions: Number: 31 Heading: SQL Server Question: What are the different types of temporary tables? Answer: SQL Server supports temporary tables. These tables have names that start with a number sign (#). If a temporary table is not dropped when a user disconnects, SQL Server automatically drops the temporary table. Temporary tables are not stored in the current database; they are stored in the tempdb system database. There are two types of temporary [...]

Sql Server Interview Questions : How to pass a table name, column name etc. to the stored procedure so that I can dynamically select from a table? Basically, SELECT and other commands like DROP TABLE won’t let you use a variable instead of a hardcoded table name. To overcome this problem, you have to use dynamic sql. But dynamic SQL has some disadvantages. It’s slow, as the dynamic SQL statement needs to be parsed everytime [...]

Sql Server Interview Questions Part-3: Number: 16 Heading: SQL Server Question: What are the steps you will take to improve performance of a poor performing query? Answer: This is a very open ended question and there could be a lot of reasons behind the poor performance of a query. But some general issues would be: No indexes, table scans, missing or out of date statistics, blocking, excess recompilations of stored procedures, procedures and triggers without [...]