SQL Server interview questions - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 04:58 PM

1. Full, Simple and Bulk Log Recovery Models

2. Transaction Isolation Level

3. What are DTS subroutines? What is their use and How do you write them?

4. What is DESCRIBE command in SQL Server?What is its purpose?How to use it?

5. General Functions in SQL

6. I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code?

7. Failed Trigger

8. How will you copy the structure of a table without copying the data?

9. What is the difference between "procedure" and "function"?

10. How to remove duplicate records from a table?

11. How many column maximum we can add in one table and how many foreign key maximum we can use in one table?

12. What is different between int and bint?

13. How do you optimize stored procedures ?

14. What is a "trigger"?

15. SQL Server Multiple null values

16. Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.

17. Data Reader or Dataset

18. Creating SQL Server GUID

19. How many types of system privileges are there, Can we add or delete privileges?

20. Efficient way of Committing transactions

21. What is XMLA in SQL Server 2005
22. SQL Server data in XML Format

23. What is the difference between User Identification and Authentication?

24. What are data objects?

25What is the difference among "dropping a tableâ€�,â€� truncating a table" and deleting all records" from a table?

26. What are "HINTS"? What is "index covering" of a query?

27. What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it

28. Explain real time situation where you would use clustered and Non-clustered Indexes?

29. Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?

30. Difference between a "where" clause and a "having" clause?
31. What are the new enhancements in SQL server 2005?

32. What is a dirty page and dirty report?

33. What is DYNAMIC SQL method ?

34. Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am SundayFile 1 backup : 8pm Monday eveningFile 2 backup : 8pm Tuesday eveningFile 3 backup : 8pm Wednesday eveningFile 1 backup : 8pm Thursday eveningFile 2 backup : 8pm Friday eveningFile 3 backup : 8pm Saturday eveningTransaction log backups : Hourly, every day.DB suffers critical fail

35. What is the query used to display all tables names in SQL Server (Query analyzer)?

36. How functional dependency is related to database table design?
37. What is the difference between "translate" and "replace"?

38. Give some examples of Analytical functions?

39. How do you change column names in SQL Server ?
40. What is table in SQL server? What is ##table in SQL server?
41. What is the difference between Inner join and full outer join in terms of the Number of rows returned?

42. What is the difference between Varchar and Varchar2?

43. Name of the class of SQL?
44. How we can make sure that the SQL query does not return NULL values?

45. Explain about Dead-locks in Sql Server database

46. What is the Disadvantage of StoredProcedure?

47. What is the use of database index (apart from fast searching of records);What is use of composite key ?
48. What is the difference between sql server,database server and oracle server?

49. How will backup database in access?

50. What is Extended Stored Procedure in SQL Server 2000?
51. Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy?

52. Advance features of sqlserver2005 over SQL server 2000?

53. Can we have multiple record set from stored procedure?

54. How to Increase, the size of Database in SQL server 2000, in terms of GB size?

55. How we can protect SQL Server Database?Tell me about Process?

56. How to run SQL script from a Unix Shell?

57. How can we use rollback in SQL server?

58. Give example for binary datatype non binary datatype?

59. Difference between "VARCHAR" and "VARCHAR2" datatypes?

60. Are there any Commands, can be used to calculate the performance of a Querry?
61. How to configure relational connection in workflow manager for MS SQL server?

62. How can we give default value to unique identifier field in table ?

63. What is fill factor, where it can be used?

64. 1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELEC

65. Why can a "group by" or "order by" clause be expensive to process?

66. How to find out duplicate records in sql server?

67. 1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name

68. What is merging?

69. Difference between Primary Key and Aggregate Key?

70. How to convert RAW data type into TEXT?
71. What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.
72. Difference between "ORACLE" and "MICROSOFT ACCESS" databases?

73. What is a "transaction"? Why are they necessary?

74. What is SQL*Loader?

75. I need to set up a named set within a cube selecting only 2 members, can anyone out there provide me with a simple piece of MDX that will achieve this?

76. When do you get constraint violation? What are the types of constraints?

77. What is a VIEW? How to get script for a view?

78. What's the use of SQL Profiler?

79. What cursor type do you use to retrieve multiple record sets?

80. Explain Normalization and Denormalization with examples?

81. What is the use of Analyzing the tables?

82. How to create a database link?

09-12-08, 04:58 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	SQL Server interview questions 1. Full, Simple and Bulk Log Recovery Models 2. Transaction Isolation Level 3. What are DTS subroutines? What is their use and How do you write them? 4. What is DESCRIBE command in SQL Server?What is its purpose?How to use it? 5. General Functions in SQL 6. I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code? 7. Failed Trigger 8. How will you copy the structure of a table without copying the data? 9. What is the difference between "procedure" and "function"? 10. How to remove duplicate records from a table? 11. How many column maximum we can add in one table and how many foreign key maximum we can use in one table? 12. What is different between int and bint? 13. How do you optimize stored procedures ? 14. What is a "trigger"? 15. SQL Server Multiple null values 16. Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no. 17. Data Reader or Dataset 18. Creating SQL Server GUID 19. How many types of system privileges are there, Can we add or delete privileges? 20. Efficient way of Committing transactions 21. What is XMLA in SQL Server 2005 22. SQL Server data in XML Format 23. What is the difference between User Identification and Authentication? 24. What are data objects? 25What is the difference among "dropping a tableâ€�,â€� truncating a table" and deleting all records" from a table? 26. What are "HINTS"? What is "index covering" of a query? 27. What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it 28. Explain real time situation where you would use clustered and Non-clustered Indexes? 29. Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause? 30. Difference between a "where" clause and a "having" clause? 31. What are the new enhancements in SQL server 2005? 32. What is a dirty page and dirty report? 33. What is DYNAMIC SQL method ? 34. Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am SundayFile 1 backup : 8pm Monday eveningFile 2 backup : 8pm Tuesday eveningFile 3 backup : 8pm Wednesday eveningFile 1 backup : 8pm Thursday eveningFile 2 backup : 8pm Friday eveningFile 3 backup : 8pm Saturday eveningTransaction log backups : Hourly, every day.DB suffers critical fail 35. What is the query used to display all tables names in SQL Server (Query analyzer)? 36. How functional dependency is related to database table design? 37. What is the difference between "translate" and "replace"? 38. Give some examples of Analytical functions? 39. How do you change column names in SQL Server ? 40. What is table in SQL server? What is ##table in SQL server? 41. What is the difference between Inner join and full outer join in terms of the Number of rows returned? 42. What is the difference between Varchar and Varchar2? 43. Name of the class of SQL? 44. How we can make sure that the SQL query does not return NULL values? 45. Explain about Dead-locks in Sql Server database 46. What is the Disadvantage of StoredProcedure? 47. What is the use of database index (apart from fast searching of records);What is use of composite key ? 48. What is the difference between sql server,database server and oracle server? 49. How will backup database in access? 50. What is Extended Stored Procedure in SQL Server 2000? 51. Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy? 52. Advance features of sqlserver2005 over SQL server 2000? 53. Can we have multiple record set from stored procedure? 54. How to Increase, the size of Database in SQL server 2000, in terms of GB size? 55. How we can protect SQL Server Database?Tell me about Process? 56. How to run SQL script from a Unix Shell? 57. How can we use rollback in SQL server? 58. Give example for binary datatype non binary datatype? 59. Difference between "VARCHAR" and "VARCHAR2" datatypes? 60. Are there any Commands, can be used to calculate the performance of a Querry? 61. How to configure relational connection in workflow manager for MS SQL server? 62. How can we give default value to unique identifier field in table ? 63. What is fill factor, where it can be used? 64. 1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELEC 65. Why can a "group by" or "order by" clause be expensive to process? 66. How to find out duplicate records in sql server? 67. 1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name 68. What is merging? 69. Difference between Primary Key and Aggregate Key? 70. How to convert RAW data type into TEXT? 71. What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date. 72. Difference between "ORACLE" and "MICROSOFT ACCESS" databases? 73. What is a "transaction"? Why are they necessary? 74. What is SQLLoader? 75. I need to set up a named set within a cube selecting only 2 members, can anyone out there provide me with a simple piece of MDX that will achieve this? 76. When do you get constraint violation? What are the types of constraints? 77. What is a VIEW? How to get script for a view? 78. What's the use of SQL Profiler? 79. What cursor type do you use to retrieve multiple record sets? 80. Explain Normalization and Denormalization with examples? 81. What is the use of Analyzing the tables? 82. How to create a database link? __________________ Sai Prepaid Mobile Recharge Online* - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.