| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| 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 |
| What is a Lock and let me know Different types of locks? | | 1 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| i want table name basis on column name. | | 5 |
| How To delete duplicate record from a particular table? | eXensys | 10 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| What is transaction ? Give me one example. | Melstar | 7 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| what is difference between nchar and char in Sql server ?
| | 2 |
| How do you simulate a deadlock for testing purposes | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
