What are the new data types are introduced in sql 2000?
List some of the rules that apply to creating and using a ‘view’
Explain active/passive and active/active cluster configurations?
Can a database be shrunk with users active?
How you can change a cross join into an inner join?
How you can add messages to the nt event log from within a stored procedure?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Can a rule be bound to any column of any data type?
can an order by clause be used in a creation of a view?
Define constraints and give an example of their use?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How can a user-defined datatype be created?
Explain timestamp datatype?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?