Tag: sql-server

Questions Related to sql-server

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

  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

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: B

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

  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

Show answer
Correct Option: C

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

  1. Remote replication

  2. Snapshot replication

  3. Transactional replication

  4. Merge replication

Show answer
Correct Option: D

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

sql-server

  1. SQL Server Agent

  2. MS DTC

  3. MSSQL Server

  4. All of the above

Show answer
Correct Option: D

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

  1. Increase Min server memory

  2. Set working area to 1

  3. Set working area to 0

  4. Increase memory allocated to the procedure cache option

  5. Reduce Min server memory

Show answer
Correct Option: A

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

  1. On failure

  2. Return codes

  3. On success

  4. All of the above

Show answer
Correct Option: D

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

  1. Msdb

  2. Tempdb

  3. Master

  4. Model

Show answer
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?

sql-server

  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

Show answer
Correct Option: B

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

  1. Run the rebuild.exe program

  2. Drop the MASTER database

  3. Run the reblddb.exe program

  4. Run the sqlservr.eve program with the -m option

Show answer
Correct Option: D