Tag: databases

Questions Related to databases

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

MARS stands for:
technology databases

  1. Multiple Active Record Sets

  2. Multiple Active Result Sets

  3. Multiple Account Record Sets

  4. Multiple Account Result Sets

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. 1 GB

  2. 1024 KB

  3. 2 GB

  4. 500 MB

Show answer
Correct Option: C

A trigger name in SQL 2005 cannot start with #.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. @@MAX_CONNECTIONS

  2. @@TRANCOUNT

  3. @@CONNECTIONS

  4. None of the above

Show answer
Correct Option: A

Choose the correct option:

technology databases

  1. When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NULL

  2. When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NOT NULL

  3. When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to FALSE if the data value is NULL

  4. When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to TRUE if the data value is NULL

Show answer
Correct Option: D

Choose the correct option:

technology databases

  1. A CTE is created using the WITH statement

  2. A CTE is created using the SELECT statement

  3. A CTE is created using the CREATE statement

  4. None of the above

Show answer
Correct Option: A

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

technology databases

  1. sp_who

  2. sys.dm_tran_locks

  3. @@lock_timeout

  4. sp_lock

  5. None of the above

Show answer
Correct Option: D