| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| WHAT IS UNIQUE IDENTIFIER DATA TYPE? | Sparsh | 2 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| How to find the last update record in SQL Server? | | 3 |
| Which virtual table does a trigger use? | | 3 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| Define candidate key, alternate key, composite key. | | 9 |
| What are tasks? | Wipro | 1 |
| What is a function? Give some example? | | 2 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| What is Schema? and why we use schemas? | | 1 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| can foreign key take role of primary key?
| TCS | 4 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| How m-m relationships are implemented? | | 1 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| how can i view structure of table in sql server? tell me
that query. | | 4 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| |
| For more SQL Server Interview Questions Click Here |