PRINT NOGEN  
PCB      TYPE=DB,DBDNAME=VENDOR  
SENSEG   NAME=VENSEG,PROCOPT=G  
SENSEG   NAME=ITEMSEG,PARENT=VENSEG,PROCOPT=R  
SENSEG   NAME=LOCNSEG,PARENT=ITEMSEG,PROCOPT=A  
PSBGEN  
END

Referring to the sample code above, what is missing in the first macro in the PSBGEN job stream?

@@Error returns the sys.messages.message_id column value if an error occurs in the last T-SQL statement executed.True/False?

A transaction must have ACID properties to be qualified as such.

Which of the Isolation levels causes "Dirty Read"?

Which one of the below functions is Non-Deterministic?

The given T-SQL statement is executed. What happens?

COUNT(*) returns the number of items in a group - which of the below is correct?

sys.sql_modules system catalog contains a row for each object of type P, RF, V, TR, FN, IF, TF, R, and D.

We can write triggers for Truncate.

Extended Stored Procedure master.dbo.xp_fileexist can be used to decide if a file exists.

If DBCC CHECKDB for a database then DBCC CHECKALLOC has to be run separately.

MARS stands for:

There must be at least one log file for each database.

SQL 2005 XML data type instance storage has a limit. Choose the correct limit:

A trigger name in SQL 2005 cannot start with #.

Which one of the below, returns the maximum number of simultaneous user connections allowed on an instance of SQL Server?

Choose the correct option:

Choose the correct option:

Which of the below is used to get the system lock information?

Which of the below is a part of Data Control Language?