|
|
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?
|
|
|
|
 gen. 0.054
|
Server date 03:10 12-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
70-029 certification
70-029 master dump