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?
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
You start SQL-Server with the -f option. Unfortunately now you can't establish a connection to your SQL-Server. What should you do?
Rebuild Master database
Edit registry
Run regrebld.exe
Restore registry from backup
What SQL Server protocol must be installed to communicate via SQL Server with a Unix application?
TCP/IP
Unix Command Protocol
Multiprotocol
Named Pipes
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?
DBCC CHECKDB
DBCC NEWALLOC
DBCC CHECKALLOC
DBCC CHECKCATALOG
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
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
You want to prevent long-running queries from executing. How would you do this?
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
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?
C:MSSQL7LOGERROR.LOG
C:MSSQL7ERROR.LOG
C:MSSQL7SQLSTP.LOG
Windows NT Event Log-Application Log
Windows NT Event Log-System Log
Under what occasions does the SQL Server 7 write events to the Windows NT application log?
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
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 Enterprise Manager
SQL Server Transact
SQL Server Network Client
SQL Server Query Analyzer
Both A and D
What functions are performed by the SQL Server Agents?
Replication management
Job execution
Notification
Alert management