| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How m-m relationships are implemented? | | 1 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| what is a stored procedure and trigger? | | 1 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| how to replace double quotes by single quotes in sql server | CAC | 2 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| How do you load large data to the SQL server database? | | 2 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| What is a Trace frag?Where can we use this? | | 1 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX | L&T | 2 |
| 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 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| About DTS usage ? | Cognizent | 2 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |