| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the system function to get the current user's user
id? | HCL | 1 |
| What is a Trace frag?Where can we use this? | | 1 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| how to know Who Is Blocking Your SQL Server? | | 2 |
| What is de-normalization and when do you do it? | | 3 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| When do you use SQL Profiler? | | 2 |
| write the query for taking database restore in sql? | | 2 |
| How the data stores in a page? | | 1 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 18 |
| how do u do Performance tunning ?
| Satyam | 1 |
| how to update a null value field in sql server
eg
a table contains 3 fields id,name,salary
and 3 records
salary of 1 record is null
i want update the nullfield
111 arun 300
112 ddd 200
113 ttt null
i want to update table with add 100 to every record include null
after updation
the recrds should be
111 arun 400
112 ddd 300
113 ttt 100
| HCL | 6 |
| syntax for deleting the database in T SQL | | 4 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| |
| For more SQL Server Interview Questions Click Here |