How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
If a stored procedure is taking a table data type, how it looks?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the steps you will take to improve performance of a poor performing query?
How to start SQL Server in minimal configuration mode?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is normalization? Explain different levels of normalization?
Where would you look for errors from the database engine?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Explain materialized views and how they are used.
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?