Un-Answered Questions { Databases }

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1613


If a stored procedure is taking a table data type, how it looks?

5771


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1826


What are statistics, under what circumstances they go out of date, how do you update them?

1791


What are the steps you will take to improve performance of a poor performing query?

2404


How to start SQL Server in minimal configuration mode?

6908


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?

1970


What is normalization? Explain different levels of normalization?

59655


Where would you look for errors from the database engine?

2327


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?

1979


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1824


Explain materialized views and how they are used.

1865


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 ...

1553


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?

2042


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2068