If DBCC CHECKDB for a database then DBCC CHECKALLOC has to be run separately.
True
False
MARS stands for:
Multiple Active Record Sets
Multiple Active Result Sets
Multiple Account Record Sets
Multiple Account Result Sets
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:
1 GB
1024 KB
2 GB
500 MB
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?
@@MAX_CONNECTIONS
@@TRANCOUNT
@@CONNECTIONS
None of the above
Choose the correct option:
When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NULL
When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NOT NULL
When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to FALSE if the data value is NULL
When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to TRUE if the data value is NULL
A CTE is created using the WITH statement
A CTE is created using the SELECT statement
A CTE is created using the CREATE statement
Which of the below is used to get the system lock information?
sp_who
sys.dm_tran_locks
@@lock_timeout
sp_lock
Which of the below is a part of Data Control Language?
SELECT
DENY
APPLY
UPDATE