Tag: databases

Questions Related to databases

What command(s) you have to execute to know the processes running inside SQL server.
technology databases

  1. Sp_helpdb

  2. sp_helpprocess

  3. sp_who2

  4. select * from sys.sysprocesses

Show answer
Correct Option: C,D

On which port does SQL server runs.
technology databases

  1. 1433

  2. 1434

  3. 1432

  4. 1435

Show answer
Correct Option: A

Wchich recovery model should database be in for database mirroring to be configured on it
technology databases

  1. Bulk logged

  2. Half

  3. Full

  4. Simple

Show answer
Correct Option: C

What are the modes of authentication in SQL server database.
technology databases

  1. Builtin/Administrator

  2. Windows authentication

  3. Mixed mode

  4. SQL authentication

Show answer
Correct Option: B,C

What is process to truncate a transaction log in SQL server
technology databases

  1. Fire truncate command

  2. Backup the transaction log

  3. Backup the database

  4. Logs cannot be truncated in SQL Server

Show answer
Correct Option: B

Mark all the indexes which are their in SQL server
technology databases

  1. Bit Map

  2. clustered

  3. Non clustered

  4. filter

  5. covering

  6. Composite

Show answer
Correct Option: B,C,D,E,F

How many types of system database are therand which database stores information about jobs running on the SQL server
technology databases

  1. 4,Model

  2. 4,MSDB

  3. 5,MSDB

  4. 5,Master

Show answer
Correct Option: C

Waht is page size and Extent size in SQL server
technology databases

  1. 8,64 MB

  2. 8,64 KB

  3. 16,64 KB

  4. 10,86 MB

Show answer
Correct Option: B

What is view in sql server database
technology databases

  1. Logical form of table

  2. Physical view of table

  3. Logical view of table

  4. View are thoes which are created on Stored procedure

Show answer
Correct Option: C

What are HA Options in SQL server 2005 database.
technology databases

  1. Data Guard

  2. Clustering

  3. Mirroring

  4. Transaction log shipping

  5. RAC

Show answer
Correct Option: B,C,D