| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Differnce between sel server 2000 and 2005 | | 3 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come. | | 2 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 4 |
| What are primary keys and foreign keys? | | 3 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| Why we need a group by clause? | | 3 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| From where can you change the default port? | | 3 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
