Curioustab

Home » Database » SQL Server 2000

SQL Server 2000 stored procedures can:

never be kept within the database.
be kept within the database and invoked by application programs.
be stored on the users' computer.
support BEFORE, INSTEAD OF and AFTER types.

Correct Answer: be kept within the database and invoked by application programs.

← Previous Question Next Question→

More Questions from SQL Server 2000

SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
SQL Server program code that is executed after an SQL command has been processed is called a(n):
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
By default, SQL Server will create one data file and one log file for each newly created database.
With SQL Server, parameters and variables in T-SQL start with the "%" sign.
SQL Server AFTER Triggers may be assigned views.
SERIALIZABLE is the strictest isolation level.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion