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

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

#61. You have to convert legacy database to SQL 7. Legacy database has: Name as Last & First (one column containing both names). SQL has: EmployeeID IDENTITY LastName, FirstName (2 separate columns with the names). Select the best option:

#62. You have an accounting application that captures batchs of transactions into a staging table before being processed, processing can be performed on individual batches or on the whole staging table. Processing includes many validations before updating any of the production tables. You want to accomplish the following goals: - Avoid deadlocks or ensure the deadlocks are handled appropriately. - Ensure that each batch of transactions is accepted or rejected. - Allow other users to access the production tables while accounting transactions are being processed. - Minimize reuse locking. You take following actions: - Begin a transaction. - Validate each rows into production tables as appropriate by using insert select statement. - Update and delete existing producting tables as appropriate by joining production tables to the staging tables. - Commit the transaction. - Roll back the transaction if any errors are encounted.

(Choose all that apply)

#63. Table(customer) Table(loan) Table(inspection) Table(appraisal) PK: customerid PK: loanid PK: inspectionid PK: loanid lastname R loandate R loanid appraisalid firstname loanstatusid inspectionresultid appraisalamount addressid appraisaldate inspectiondate appraisalid statusid appraisalamount inspectiontypeid country customerid

NOTE! The above tables did NOT come thru the dumps and so are probably F'ed up! and the question below is F'ed up! You must sored procedure casually delets on the homeloan database client application will pass a parameter country the customerid of the customer to be deleted a customer might have any number of pending loans Each pending loan has one or more inspections and one or name appraisal associated with it.

#64. You are building an invoicing system for your company. On each invoice, you want to show the following information: Customer Number, Customer Name, Customer Address, Customer City, Customer Territory, Customer Postal Code, Part Number, Part Description, Part shipping weight, Current cost, Current price, Quantity on hand, Order Number, Order Date, Part Number, Quantity There can be multiple parts on one invoice. Cost and information comes from a master list, but the history stored for each invoice should show the cost and price at time of sale. You want to make sure your database is properly normalized. You want to accomplish the following: - Every table must have a primary key. - All non-key columns must depend on the whole primary key. - All columns must contain exactly one value. - Each column in a table must be independent of any non-key column in the same table. You create the logical model as shown in exhibit: (??) Customers: CustomerNo(PK), CustomerName, etc. Part: PartNo(PK), PartDescription, UnitWeight, etc. Orders: OrderNo(PK), OrderDate OrderDetail: OrderNo(PK), ItemNo(PK), CustomerNo(FK), PartNo(FK), PartDescription, QuantitySold, UnitWeight, etc...

Which result does this model produce (choose all that apply)?

#65. You are deriving a Personnel database for your company. This database includes a employee table that is define as follows:

CREATE TABLE Employee( Id int IDENTITY NOT NULL, Surname varchar(50) NOT NULL, FirstName varchar(50) NOT NULL, SocialSecurityNo char(10) NOT NULL, Extension char(4) NOT NULL, EmailAddress varchar(255) NOT NULL)

Your company provide each employee with a telephone extension number and an e-mail address. Each employee must have a unique telephone extension and a unique e-mail address. In addition, you must prevent duplicate SocialSecurityNo from being entered into the database. How can you alter the table to meet all of the requirements?

#66. Tables: Member_Ship table Committee table Address table When a person resigns from organization, you want to delete the Membership row & have all related rows to be automatically removed.

#67. Evaluate this statement: Use hr SELECT department_id SUM(salary) FROM employee GROUP BY department_id HAVING emp_id > 2001 Which clause will cause the statement to fail?

#68. Designing Insurance database: In POLICY table you need to ensure that the value entered in to Beginning_effective_date column is less than or equal to the value entered into Ending_effective_date.

#69. Your company uses an application, named Application Z that is run daily after business hours. As your company expands its business, data becomes more dynamic, and management wants the report to be produced every 2 hours. Multiple applications concurrently access SQL Server during the day. Which two of the following modifications to Applications Z should you implement to produce the reports more quickly without preventing other SQL Server applications from performing their tasks? (Choose 2)

#70. You are troubleshooting a process that makes use of multiple complex stored procedures that operate on a table. The process is producing unexpected update to the table. You want to identify the specific stored procedure and statement that are causing the problem:

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

gen. 0.059

Server date 02:46 08-01-2009

Microsoft 70-029

Forum

Start online exam simulation

Master braindump