Tag: databases

True

False

True

False

Multiple Active Record Sets

Multiple Active Result Sets

Multiple Account Record Sets

Multiple Account Result Sets

True

False

1 GB

1024 KB

2 GB

500 MB

True

False

@@MAX_CONNECTIONS

@@TRANCOUNT

@@CONNECTIONS

None of the above

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

None of the above

sp_who

sys.dm_tran_locks

@@lock_timeout

sp_lock

None of the above