| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is MSDE? | | 2 |
| What is the difference between UNION and UNIONALL? | CTS | 2 |
| can you any body tell me the how to decrease the logfile | | 4 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| event classes in sql server | Accenture | 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 |
| how many type of subquery? | | 2 |
| what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key? | | 2 |
| Differnce between sel server 2000 and 2005 | | 3 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| i want table name basis on column name. | | 5 |
| how to know description of a table in sqlserver 2000
| | 7 |
| What is the difference between constraints and triggers? | Wipro | 6 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 4 |
| Explain different isolation levels? | | 3 |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
