Database Management Systems

SQL Server 7.0 introduced DTS (Data Transformation Services), which can import data from SQL 6.5. Alternatively, bcp (bulk copy program) with -out to export from 6.5 and -in to import to 7.0 works across versions. DTS Export is for exporting data OUT, not importing. There is no 'bcp -copy' command - the correct syntax is bcp -out and bcp -in.

The -f flag starts SQL Server with minimal configuration, which may exclude network libraries. regrebld.exe rebuilds the registry entries for SQL Server, restoring proper network configuration. Rebuilding the master database (A) is extreme and would lose all configuration. Manually editing (B) or restoring (D) the registry is risky and unnecessary when regrebld.exe automates this correctly.

DBCC CHECKDB is the primary command used to check the logical and physical integrity of all objects in the database, including verifying that index pages are correctly sorted and that offsets are reasonable. CHECKALLOC focuses specifically on disk space allocation structures.

SQL Server recovery rolls forward committed transactions from the transaction log since the last checkpoint, ensuring durability. Transactions before the last checkpoint were already written to data files. Uncommitted transactions (B) are rolled back, not forward. Option A is incorrect because transactions before the checkpoint are already on disk. Option D is incorrect - recovery uses the last checkpoint, not the interval between two checkpoints.

When SQL Server fails to start on a Windows NT/2000 system, the Application Log within the Windows Event Viewer is the primary place to find service-level errors. While SQL's own ERRORLOG is useful, the Event Log captures the initial service startup failure details.

SQL Server writes to the Windows NT application log through multiple mechanisms. The xp_logevent extended stored procedure explicitly logs custom messages. System stored procedures sp_addmessage and sp_altermessage can configure error messages to write to the NT log. SQL Server automatically logs errors with severity levels 19-25 (critical errors). The RAISERROR WITH LOG statement also forces logging. Since all four methods are valid, option E is correct.

SQL Server Enterprise Manager is the main administrative console that shows server status and registered servers. SQL Server Query Analyzer allows you to execute test queries against the server; successful queries confirm the server is running. Both tools are valid for verification.

SQL Server Agent is a scheduling and automation service that performs job execution (scheduled tasks), alert management (responding to SQL Server events), notification (sending alerts to operators), and replication management (automating replication tasks). All listed functions are performed by the Agent.

Windows NT Authentication mode requires the client to be part of a Windows NT domain and support integrated security. Windows 98 workstations cannot participate in Windows NT authentication; they must use SQL Server authentication with a username and password.

SQL Server 7.0 does not support a direct upgrade path from version 4.2. The standard procedure requires upgrading the 4.2 instance to version 6.5 first, and then using the SQL Server Upgrade Wizard to move to version 7.0.

A Typical installation of SQL Server on NT includes the core database engine (MSSQLServer), the SQL Server Agent for automation, and the Microsoft Distributed Transaction Coordinator (MS DTC) for managing transactions across multiple servers.

The msdb database is used by SQL Server Agent for scheduling alerts and jobs, as well as recording history. Master stores system-level info, tempdb stores temporary objects, and model is the template for new databases.

Data Transformation Services (DTS) is the legacy SQL Server 7.0/2000 tool designed specifically for importing, exporting, and transforming data between different formats, such as moving an Access table into a SQL Server database.