| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the cursor life span? | Evalueserve | 5 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| Which is best Subquery (or) joins in sql server? explain why | | 2 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| Can we create a clustered index on composite primary key. | | 2 |
| How to link up the text file to a Database table? | Allianz | 1 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| What is an extended Stored Procedure? | | 1 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005 | | 2 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 7 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| what are file groups? | Evalueserve | 3 |
| How many types of cursors are there in SQL Server? | 247Customer | 3 |
| What is Peer to peer Replication? | HCL | 1 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? | Techno-Solutions | 1 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |