1.Name four DBCC commands that are commonly used for database maintenance?
Any of the following:
2.What is the system function in SQL used to retrieve the current user’s user id?
3.What is the command line tool used for administration of Windows SharePoint Services or Office SharePoint?
4.Which of the following are the recovery models used by SQL Server? (Select all that apply)
A,B and D
5.What is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server?
A) Log Automation
B) Log Shipping
C) Stored Procedure
D) Heap Transfer
6.In Microsoft SQL Server what command is used to rename a database?
7.What command is used to display or change server-level settings in MS SQL Server?
8.Which of the following SQL keywords is used to change or set a users permissions? (Select all that apply)
A, C, and D
9.Where are web part resources contained? (Select all that applies)
A) In the registry hive
C) GAC folder
D) Referenced in the web.config file
B, C and D
10.Which of the following system databases in Microsoft SQL stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping?