SQL Server Quiz

Description: SQL Server Quiz
Number of Questions: 20
Created by:
Tags: sql-server
Attempted 0/20 Correct 0 Score 0

Your SQL Server is running SQL 6.5 and you want to transfer the data from the SQL 6.5 server to a new SQL 7 Server. How can you do this?

  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

You start SQL-Server with the -f option. Unfortunately now you can't establish a connection to your SQL-Server. What should you do?

  1. Rebuild Master database

  2. Edit registry

  3. Run regrebld.exe

  4. Restore registry from backup


Correct Option: C

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

You want to prevent long-running queries from executing. How would you do this?

  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

AI Explanation

To prevent long-running queries from executing, you can modify configuration parameters in SQL Server. Let's go through each option to understand why it is correct or incorrect:

Option A) Run the stored procedure set query governor cost limit - This option is incorrect because running the stored procedure alone will not prevent long-running queries. The query governor cost limit is used to limit the amount of resources (CPU, memory, etc.) that a query can consume, but it needs to be configured and set through the appropriate configuration parameters.

Option B) Modify the configuration parameter min memory per query - This option is incorrect because there is no configuration parameter called "min memory per query" in SQL Server. Therefore, modifying this parameter will not prevent long-running queries.

Option C) Modify the configuration parameter show advanced options - This option is partially correct. The "show advanced options" configuration parameter allows you to view and modify advanced configuration options in SQL Server. However, modifying this parameter alone will not prevent long-running queries.

Option D) Modify the configuration parameter query governor cost limit - This option is correct. The "query governor cost limit" configuration parameter allows you to set a limit on the amount of resources that a query can consume. By modifying this parameter, you can prevent long-running queries from executing.

Option E) Both C and D - This option is correct. Modifying both the "show advanced options" and "query governor cost limit" configuration parameters can help prevent long-running queries from executing. The "show advanced options" parameter allows you to access and modify advanced configuration options, while the "query governor cost limit" parameter sets a limit on query resource consumption.

Therefore, the correct answer is E) Both C and D.

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

You define full-text indexing on the ProductName column in the Products table. You then execute a full-text query on the column. You specify a word that you know is present in the column, but the result set is empty. What is the most likely cause?

  1. The catalog is not populated

  2. You did not create a unique SQL Server index on the ProductName column

  3. The SQL ServerAgent Service is not running

  4. The Microsoft Service is not running


Correct Option: A
  1. Just upgrade normally to SQL Server 7

  2. Use SQL 6.5 Transfer Management Tool to push the data and objects from version 4.2 to 7

  3. Upgrade the server to SQL Server 6.5, then upgrade again to SQL Server 7

  4. Use the DTS to transfer the data and objects


Correct Option: C

Which of the four system databases stores all the information about alerts and jobs?

  1. Msdb

  2. Tempdb

  3. Master

  4. Model


Correct Option: A

You have been asked to copy a one-table Access database to another table that exists in a SQL Server 7 database. What is the best method you should use to copy the data?

  1. The copy_db command at a command prompt

  2. Data Transformation Services

  3. The oslp utility

  4. Data Transfer System

  5. The BULK INSERT statement


Correct Option: B
- Hide questions