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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

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

#21. Multinational company with offices in NY, London, Nairobi and Cairo tracks sales. Sales are in local currency. Nairobi and Cairo have value added tax. HQs want reports in $$$ at the end of the month. They have monthly replication set up. Currency rates fluctuations are the reason that the total of a sale in $$$ for a particular date is not the same in the end of the month.

You have a tables: ConversionRate: (PK)Currency, (PK)Ratevaliddate, Rate, Check to reject later date than current date Sales: (PK)SalesID with uniqueidentifier, default Newid(), SalesAmount, TaxAmount, SalesDate (Choose all that apply.)

#22. Output of DBCC SHOWCONTIG: Pages Scanned: 158 Extents scanned: 20 Extent Switches: 21 Scan Density: 20:21 (Best Count : ActualCount) Extent scan Fragmentation: 4.83% Avg bytes free per page: 284.7 Avg Page density(full): 94.83% (Choose all that apply)

#23. Insert or update over 200,000 into sales table. Output of DBCC SHOWCONTIG: Pages Scanned: 1657 Extents scanned: 210 Extent Switches: 1528 Avg. Page per extent: 7.9 Scan density:13.60% [208:1529] bla bla: 91.43 Extent scan fragmentation 1.43 Avg bytes free per page: 2843.5 Avg Page density(full): 64.87

(Choose all that apply)

#24. You have a table: Create table employee( Employee_id int identity (1,1), Fname varchar (30), Lname varchar (30), Phone int , Address varchar (30), Salary money) The phone number is an int but you want wen to show it like (999)-999-999. Choose the write select query.

#25. You want to Delete orders that are > 3 years old. How?

#26. You must reconcile the checking account for your company. You have a CheckRegister table, an InvalidCheck table, and a ClearedCheck table. The ClearedCheck table lists checks that have cleared the bank. You must update the ClearedDate column of the CheckRegister table for any checks that are on the ClearedCheck table. If the check is in the ClearedCheck table but not on the CheckRegister table, you must insert a row into the InvalidCheck table. If the amount shown for a check in the ClearedCheck table is different from the amount shown for the same check in the CheckRegiste r table, you must insert a row into the InvalidCheck table. Each row must be deleted from the ClearedCheck table after it has been evaluated for accuracy. Which statement group should you use to accomplish this task in the shortest time?

#27. A stored procedure is created and a VB user with SQL authentication is trying to execute it but can't. Windows NT security is not used. Choices given:

#28. Importing from dbase III data to SQL. The table structure is like this in dbase. Create table order (order int, orderdate datetime, foreign bit) You use the DTS wizard, You have filled all the options. Everytime you execute you get an error. How do you correct this problem?

#29. How do you automate export of data to excel?

#30. How do you add constraint to an existing table? create table sample (field1 int, field2 int, field3 int) You want your fields 1-3 to be unique.

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

gen. 0.048

Server date 04:02 08-01-2009

Microsoft 70-029

Forum

Start online exam simulation

Master braindump