Question 1

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?

sql-server

Using DTS Import
Using bcp -out and use bcp -in to insert the data into the new SQL 7 Server
Use the DTS Export
Using bcp -copy, copy the data from the SQL 6.5 Server to the SQL 7 Server
Both A and B

Answer

Correct Option: E

Question 2

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

sql-server

Rebuild Master database
Edit registry
Run regrebld.exe
Restore registry from backup

Answer

Correct Option: C

Question 3

What SQL Server protocol must be installed to communicate via SQL Server with a Unix application?

sql-server

TCP/IP
Unix Command Protocol
Multiprotocol
Named Pipes

Answer

Correct Option: A

Question 4

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?

sql-server

DBCC CHECKDB
DBCC NEWALLOC
DBCC CHECKALLOC
DBCC CHECKCATALOG

Answer

Correct Option: A

Question 5

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

sql-server

All committed transactions that are in the transaction log
All uncommitted transactions that are in the transaction log
All committed transactions that are in the transaction log between the last checkpoint and the failure
All committed transactions that are in the transaction log between the last two checkpoints

Answer

Correct Option: C

Question 6

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

sql-server

Run the stored procedure set query governor cost limit.
Modify the configuration parameter min memory per query.
Modify the configuration parameter show advanced options.
Modify the configuration parameter query governor cost limit.
Both C and D

Answer

Correct Option: E

Question 7

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?

sql-server

C:MSSQL7LOGERROR.LOG
C:MSSQL7ERROR.LOG
C:MSSQL7SQLSTP.LOG
Windows NT Event Log-Application Log
Windows NT Event Log-System Log

Answer

Correct Option: D

Question 8

Under what occasions does the SQL Server 7 write events to the Windows NT application log?

sql-server

When the xp_logevent stored procedure is invoked
When sp_addmessage or sp_altermessage define errors to be written to the NT application log
When SQL Server errors occur with severity levels between 19 and 25
When the RAISEERROR WITH LOG statement is executed
All of the above

Answer

Correct Option: E

Question 9

After installing SQL 7, you want to connect to the SQL 7 Server to verify installation. What graphical tools would you use to verify that the server is running?

sql-server

SQL Server Enterprise Manager
SQL Server Transact
SQL Server Network Client
SQL Server Query Analyzer
Both A and D

Answer

Correct Option: E

Question 10

What functions are performed by the SQL Server Agents?

sql-server

Replication management
Job execution
Notification
Alert management
All of the above

Answer

Correct Option: E

Question 11

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?

sql-server

The catalog is not populated
You did not create a unique SQL Server index on the ProductName column
The SQL ServerAgent Service is not running
The Microsoft Service is not running

Answer

Correct Option: A

Question 12

A client connecting to a SQL Server database from a Windows 98 workstation is able to connect in a Windows NT authentication mode. True or false?

sql-server

True
False

Answer

Correct Option: B

Question 13

John Doe has SQL Server 4.2 and she wants to upgrade the server, data and database objects to SQL Server 7. Which upgrade path will accomplish this goal?

sql-server

Just upgrade normally to SQL Server 7
Use SQL 6.5 Transfer Management Tool to push the data and objects from version 4.2 to 7
Upgrade the server to SQL Server 6.5, then upgrade again to SQL Server 7
Use the DTS to transfer the data and objects

Answer

Correct Option: C

Question 14

John Doe wants to establish a replication model that will allow three branch offices to update data at the corporate site. Which replication model should John Doe use?

sql-server

Remote replication
Snapshot replication
Transactional replication
Merge replication

Answer

Correct Option: D

Question 15

Which of the following SQL Server services are installed during the Typical installation option on a NT Server?

sql-server

SQL Server Agent
MS DTC
MSSQL Server
All of the above

Answer

Correct Option: D

Question 16

Exchange and SQL 7.0 are running on the same server. You notice the performance in exchange is degraded. The Min server memory, Maximum server memory and set working area are set as they were automatically in the installation. What do you do to free memor

sql-server

Increase Min server memory
Set working area to 1
Set working area to 0
Increase memory allocated to the procedure cache option
Reduce Min server memory

Answer

Correct Option: A

Question 17

The step object in a DTS (data transformation service) package can run in parallel when there are no precedence constraints on it. Which of the following are step object precedence constraints?

sql-server

On failure
Return codes
On success
All of the above

Answer

Correct Option: D

Question 18

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

sql-server

Msdb
Tempdb
Master
Model

Answer

Correct Option: A

Question 19

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?

sql-server

The copy_db command at a command prompt
Data Transformation Services
The oslp utility
Data Transfer System
The BULK INSERT statement

Answer

Correct Option: B

Question 20

You must restore the MASTER database from a backup on a SQL 7 computer. You attempt to start the restore process but receive an error message. What must you do before you can restore the MASTER database?

sql-server

Run the rebuild.exe program
Drop the MASTER database
Run the reblddb.exe program
Run the sqlservr.eve program with the -m option

Answer

Correct Option: D

Description: SQL Server Quiz
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: sql-server

SQL Server Quiz

Find more quizzes from top tags