Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1036What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
1073What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
1192What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
1167How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
1105
Explain contrast amongst grouped and non-bunched records?
What is a DBMS, query, SQL?
How to get the definition of a trigger back?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is a subquery in a select query statement in ms sql server?
Give an example of SQL injection attack ?
where can you add custom error messages to sql server? : Sql server administration
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is nonclustered index on computed columns?
Do you know what is difference between index seek vs. Index scan?
What are alternate keys?
What is sql server locking?
why would you use sql agent? : Sql server database administration
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is a cube? : sql server analysis services, ssas
