If a table is dropped, then triggers created on it will also be dropped.

Select belongs to which type of language?

How can we calculate average of a column?

what are the functions used for calculating sub totals ?

Which process registers the logfile in a standby database ?

Which process reads data from the data file into the database buffer cache ?

There is no entry in the file listener.ora. You issue the command "lsnrctl start". Which process will register the running instance with the listener?

what happens if the listener currently running for prod database is terminated due to some reason?

Is it possible to resize the size of redo logs while the database is running?

Code Name of SQL Server 2005?

Which recovery model doesn't allow Log backups?

This database will be flushed when SQL Server restarts

Which table has all the users of a server?

Which of the following option helps to execute a stored procedure when the server instance starts?

Which database holds the information of all the jobs in a server?

If a sysadmin is granted with "db_denydatareader" role for a database he will not be able to access the data from that database.

What does the OUT= represents in PROC SORT ?

BY statement specifies one or more variables whose values are used to order the data in PROC SORT?