Know all Replication Models and their usage. For example: What Model would be used if you have a slow link over which replication occurs? What if the you have a high volume order processing situation?
What is the default SQL Server Group Name?
What net library or libraries supports integrated security? Data encryption?
What net library is used for Apple? Where is it enabled? Setup or Client Configuration?
You have a client who sees a SQL error of level 19 but forgets to note the error message and has now rebooted his computer. Where would you start looking for the cause of the problem? NT log for system? NT log for applications? Where else?
You have a branch office overseas and you replicate over a high-cost connection link. Do you want to synchronize manually or automatically? How often?
You are wanting to expand your transaction log by 20MB. What would the instructions look like to accomplish this?
You are recovering from a crash and want to use the DUMP TRANSACTION entry. What else should you use? NO_LOG, NO_TRUNCATE or TRUNCATE_ONLY?
Msjobs is located where? Syspublications? Msjob_commands
Where is the SQL in the registry?
What is needed for SQL to work in a multi-server resource domain. Trusted connections? Trust relationships?
Know who can create what. DISK INIT, DISK REFIT, CREATE DATABASE, SHUTDOWN etc.
You have replication in operation and now want to put in a distribution server. What steps are needed?
You have user names that include dashes, spaces and back slashes. Know how these will be mapped in SQL.
Your server name can’t have any spaces and is limited to three specific symbols. What are the three symbols and can they be mapped like user names?
You are changing the name of your server from Moneybags to Finance. Now some remote stored procedures won’t work. What will required to get these working again? Recompiling?
Drop and re-add the server?
DISK REINIT is used together with what other command?
Understand broken ownership chains.
What does sp_logdevice command do? Why would you use it with ALTER DATABASE.
One of the questions describes a broken ownership chain of about 3 or 4 users and then has the last user attempt to run a procedure that they had no permission to run. Also the stored procedure they ran didn’t look like it was entered quite properly. One of the answer options was "The entry is invalid and an error is displayed" or something like that.
Is it possible to kill a sleeping process? How? When is it actually killed? What is the number used to specify the process you are killing?
You want to insure referential integrity. What it is used? Trigger? Rule? Constraint? Index? Stored Procedure?
What is in sysdevices, sysdatabases and sysusages. Which is associated with DISK REINIT and DISK REFIT.
What is in sysprotects?
You are working on a database during a recovery operation and want to prevent outside use of the database. How would you accomplish this? Offline? DBO use? Single user? For load?
You perform a backup while 3 transactions are in process. After the backup is complete, will these be rolled forward or back?
You have a database crash at 2PM and the last database and separate log backup is at 10AM. Will you be able to recover work up until 2PM or just until 10AM. Will log that is intact allow you to recover.
What is it called if you dump the database to more than one tape device? Know what the entry looks like that does this in ISQL.
A database has crashed and you have no record of the size, device number or any of the info needed to recreate the device and its associated databases and logs. Where would you find this information.
Can a SQL 4.2 Server be administered from the GUI interface in server manager? Why might the signal light be gray on your 4.2 server? Or any other server?
You want to upgrade from SQL 4.2 and switch machine types from Intel to MIPS. Run Transfer Manager then SQL Setup? Or vice versa?
What DBCC options should be run after you make configuration changes? Also, what back-ups are critical after changes? Master? Msdb? Model?
SQL 6.0 is not starting automatically on your server. Where would you fix this and how?
Setup? Configuration? Server Manager? Domain User Admin? Control Panel?
If you drop a user is he dropped from the server or only from his group?
Your SQL Server has 512MB of RAM. How much will SQL 6.0 allocate for itself by default?
Why would you place tempdb in RAM and what are some benefits and consequences of doing this?
What is the maximum number of locks by default?
How would you determine how system resources are being used by data and procedure cache?
How do you check object integrity?
When would you use UPDATE STATISTICS?
How would you configure read-ahead settings?
BCP is used in what situations to transfer data?
Define dynamic backup?
During setup SQL 6.0 configures tasking priority in control panel/system/tasking and server configuration in control panel/network/server/configuration. What are these settings by default?
Describe situations where makepipe and readpipe would be used.
Date last updated: 12/04/04