| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| What are tasks? | Wipro | 1 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| What is an Index? | Yardi-Software | 3 |
| What is the order in which the SQL query is executed? list
them in order. | CTS | 1 |
| What is a stored procedure? | | 3 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| What is a Trace frag?Where can we use this? | | 1 |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| Can we create a clustered index on composite primary key. | | 2 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 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 is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
