70-029 Microsoft - Braindumps.com.ua: question list for "Designing and Implementing Databases with Microsoft SQL Server 7.0", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Microsoft 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0

#1. You are the database developer for a leasing company. Your leasing database includes a lessee table that is defined as follows: CREATE TABLE lessee ( Id int IDENTITY NOT NULL, CONSTRAINT pk_lesse_id PRIMARY KEY NOT NULL Surname varchar(50) NOT NULL, FirstName varchar(50) NOT NULL, SocialSecurityNo char(9) NOT NULL, CreditRating char(10) NULL, Creditlimit money NULL ) Each SocialSecurityNo must be unique. You want the data to be physically stored in order by SocialSecurityNo. What constraint should you add to the SocialSecurity? No column on the lessee table.

#2. You have a sale table, and want show total sale by region as well as a grand total of sale. Use which of the following:

#3. You develop a logic model for your company. The company have 10 departments, every department has 6-7 employee, but every employee may work for more than one department which one of the following is true:

#4. A table named sales, which has one clustered index c-sales, and non-clustered index nc-sales1, nc-sales2. Now the table has fragmented, you should:

#5. You have a table sales with one clustered index on sales_id and 3 non-clustered index on custumer_id, date, amount. Users are complain because it takes to much time to insert or update data. You want to rebuild the indexes.

#6. You are building a database for the HR department of your company. You want to eliminate duplicate entry & minimize data storage wherever possible. You want to track the following information for each employee: First Name, Middle Name, Last Name, Employee Identity No, Address, Date of Hire, Department, Salary, Name of Manager. Which table you use?

#7. You have a sale table, the manager want a report of every saleperson, with the latest date appear first, on each day, the large saleamount appear first.

#8. USE sales DELETE FROM backorder FROM backorder bk INNER JOIN orders od ON bk.order_id = od.order_id WHERE CONVERT(char(10), ship_date) = CONVERT(char(10), GETDATE()) Which will this statement delete?

#9. You have two tables TA and TB. You want to create a query joining them, but you want maximum performance. How to improve the performance?

#10. You have a table for employees. One of the fields is Social Security Number. You don't want this field to contain nulls. If no value is given, you want a value of "UNKNOWN" to be inserted in this field. What must you do?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [24]

gen. 0.205

Server date 10:19 22-11-2008

Microsoft 70-029

Forum

Start online exam simulation

Master braindump