SQL Server 2005 MCTS 70-431

SQL Server 2005 MCTS 70-431 - Part 3

Take This Test

Section 1

1)	You are working on a view that was created when the database was first implemented several years ago. You believe that indexing the view would improve its performance. When you try to implement the index, you are unsuccessful because an ANSI_NULLS error occurs. What must you do to implement the index?

2)	As deletions are made from one table within the system, you would like to automatically delete detail records within another table. How would you implement this functionality?

3)	After starting a SQL Server from the command prompt by using SQLSERVR.EXE -f command. DBA notice that users are still able to connect to the server. What is wrong?

4)	You would like to use log shipping and want to start the process by using a full backup and the most recent log backup from the source database. How do you get these backups onto the destination and implement the configuration and query?

5)	How to improve response time of queries being run on a table whose definition has been altered recently?

6)	You are the database developer for a leasing company. Your database includes a table that is defined as shown here:
	CREATE TABLE Lease (Id Int IDENTITY NOT NULL CONSTRAINT pk_lease_id PRIMARY KEY NONCLUSTERED, Lastname varchar(50) NOT NULL, FirstName varchar(50) NOT NULL, SSNo char(9) NOT NULL, Rating char(10) NULL, Limit money NULL) Each `SSNo` must be unique. You want the data to be physically stored in `SSNo` sequence. Which constraint should you add to the `SSNo` column on the `Lease` table?
7)	Whic tool should be used to get detailed information on the types of queries being performed and the locking effects of all operations on a database implementation in a production environment?

8)	You are preparing a table design for a complex business database application. After data entry, it is a requirement of one of these fields that a series of complex business logic procedures must be performed to obtain the value for the field. Which of the following would you implement?

9)	How to find out backup sets on an unlabeled tape which was created on another server?