Q. Which command is used to select distinct subject (SUB) from the table (BOOK)?

View solution

Q. In SQL, the CREATE TABLESPACE is used

View solution

Q. In SQL, which command is used to remove a stored function from the database?

View solution

Q. A command that lets you change one or more fields in a record is

View solution

Q. In SQL, the command(s) is(are) used to create an index for a table or cluster

View solution

Q. In SQL, which command(s) is(are) used to recompile a stored function?

View solution

Q. Report generators are used to

View solution

Q. In SQL, which command(s) is(are) used to change a table's storage characteristics?

View solution

Q. In SQL, which of the following is not a data definition language commands?

View solution

Q. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?

View solution

Q. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?

View solution

Q. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?

View solution

Q. What mode of authentication does SQL Server NOT provide?

View solution

Q. The strictest transaction isolation level provided by SQL Server is called:

View solution

Q. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):

View solution

Q. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

View solution

Q. Which of the three possible types of triggers does SQL Server support?

View solution

Q. Which of the following is a way to create and modify tables using SQL Server?

View solution

Q. With which type of SQL Server recovery model, is no logging done?

View solution

Q. SQL Server 2000 stored procedures can:

View solution