Tag: databases

Questions Related to databases

  1. ALTER DATABASE … ADD FILE

  2. ALTER DATABASE … MODIFY FILEGROUP

  3. ALTER DATABASE … ADD FILEGROUP

  4. ALTER DATABASE … REMOVE FILEGROUP


Correct Option: C
  1. Service Broker

  2. Database Mirroring

  3. Extended MAPI Profile

  4. Microsoft Exchange Server


Correct Option: A
  1. In the Simple recovery model, all transactions are logged.

  2. In the Bulk-Logged recovery model, all transactions are logged.

  3. In the Full recovery model, most transactions are minimally logged.

  4. In the Simple recovery model, most transactions are minimally logged.


Correct Option: D
  1. max memory

  2. physical memory

  3. logical memory

  4. network memory


Correct Option: C
  1. dbcc checkdb

  2. dbcc checkverify

  3. dbcc checkstorage

  4. dbcc checkalloc


Correct Option: C