| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| What is a trigger? | | 3 |
| Explain Different types of Projects? | | 1 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| Differnce between sel server 2000 and 2005 | | 3 |
| What are the authentication modes in SQL Server? | | 2 |
| What is a stored procedure? | | 3 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 5 |
| Why we need a group by clause? | | 3 |
| how to generate XML out of QUERY? | McAfee | 1 |
| Explain the architecture of SQL Server? | | 2 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| About Indexed Views? with example?
plz reply... | | 2 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| What are the types of model in sql server and explain | TCS | 1 |
| What is a job? | | 3 |
| i want table name basis on column name. | | 5 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| |
| For more SQL Server Interview Questions Click Here |