Tag: sql-server

Questions Related to sql-server

  1. Using DTS Import

  2. Using bcp -out and use bcp -in to insert the data into the new SQL 7 Server

  3. Use the DTS Export

  4. Using bcp -copy, copy the data from the SQL 6.5 Server to the SQL 7 Server

  5. Both A and B


Correct Option: E
  1. Rebuild Master database

  2. Edit registry

  3. Run regrebld.exe

  4. Restore registry from backup


Correct Option: C

You friend is trying to familiarize herself with the DBCC commands with SQL server. Which command can she/he use to check if indexes are in the proper sorted order and if page offsets are reasonable?

  1. DBCC CHECKDB

  2. DBCC NEWALLOC

  3. DBCC CHECKALLOC

  4. DBCC CHECKCATALOG


Correct Option: A

The SQL server that you've manages crashed. The disk drives were not damaged but there was data that had not been written to some databases. Which transactions will be rolled forward in each database when his SQL server starts the automatic recovery proce

  1. All committed transactions that are in the transaction log

  2. All uncommitted transactions that are in the transaction log

  3. All committed transactions that are in the transaction log between the last checkpoint and the failure

  4. All committed transactions that are in the transaction log between the last two checkpoints


Correct Option: C
  1. Run the stored procedure set query governor cost limit.

  2. Modify the configuration parameter min memory per query.

  3. Modify the configuration parameter show advanced options.

  4. Modify the configuration parameter query governor cost limit.

  5. Both C and D


Correct Option: E

You've just installed SQL Server 7 on a NT server using the Typical Installation option. When you start SQL for the first time, you get an error and it will not start. Where is one place you would check to see what is causing the error?

  1. C:MSSQL7LOGERROR.LOG

  2. C:MSSQL7ERROR.LOG

  3. C:MSSQL7SQLSTP.LOG

  4. Windows NT Event Log-Application Log

  5. Windows NT Event Log-System Log


Correct Option: D
  1. When the xp_logevent stored procedure is invoked

  2. When sp_addmessage or sp_altermessage define errors to be written to the NT application log

  3. When SQL Server errors occur with severity levels between 19 and 25

  4. When the RAISEERROR WITH LOG statement is executed

  5. All of the above


Correct Option: E
  1. SQL Server Enterprise Manager

  2. SQL Server Transact

  3. SQL Server Network Client

  4. SQL Server Query Analyzer

  5. Both A and D


Correct Option: E

What functions are performed by the SQL Server Agents?

  1. Replication management

  2. Job execution

  3. Notification

  4. Alert management

  5. All of the above


Correct Option: E