Tag: databases

Questions Related to databases

Which of the following statements can you use to create a filegroup?
technology databases

  1. ALTER DATABASE … ADD FILE

  2. ALTER DATABASE … MODIFY FILEGROUP

  3. ALTER DATABASE … ADD FILEGROUP

  4. ALTER DATABASE … REMOVE FILEGROUP

Show answer
Correct Option: C

Which of the following are valid filegroup types? (Choose all that apply.)
technology databases

  1. Read-only

  2. Write-Only

  3. Default

  4. Primary

Show answer
Correct Option: A,C,D

Which of the following is a prerequisite for Database Mail?

technology databases

  1. Service Broker

  2. Database Mirroring

  3. Extended MAPI Profile

  4. Microsoft Exchange Server

Show answer
Correct Option: A

Which of the following sentences is true for recovery models?
technology databases

  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.

Show answer
Correct Option: D

Which is an ideal pool for transaction log cache?
technology databases

  1. 2K

  2. 8K

  3. 16K

  4. 4K

Show answer
Correct Option: D

Which option can be used to generate a new password for an sso login from RUN_SERVER file

technology databases

  1. -c

  2. -E

  3. -u

  4. -p

Show answer
Correct Option: D

Which trace is useful for checking index selection by Sybase Optimiser
technology databases

  1. 3604

  2. 2512

  3. 302

  4. 310

Show answer
Correct Option: C

Which parameter tells us about current memory used by Sybase ASE
technology databases

  1. max memory

  2. physical memory

  3. logical memory

  4. network memory

Show answer
Correct Option: C

Which metadata cache descriptor is used for holding database structure
technology databases

  1. DBINFO

  2. DES

  3. IDES

  4. DBTABLE

Show answer
Correct Option: D

Which dbcc command logs records onto dbccdb database
technology databases

  1. dbcc checkdb

  2. dbcc checkverify

  3. dbcc checkstorage

  4. dbcc checkalloc

Show answer
Correct Option: C