| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is database normalization? | Digicel | 5 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| What are mdf,ndf,ldf files and how to see the data in those
files? | Accenture | 5 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| Advantages and Disadvantages of Cursor? | Zenith | 10 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 7 |
| How do we rollback the table data in SQL Server | | 3 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| Explain Trigger with an example?
| | 1 |
| Explain the storage models of OLAP? | | 1 |
| how do u do Performance tunning ?
| Satyam | 1 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |