Free pass4sure Microsoft MCSE 70-229 2.93 Download

MCDBA Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition : 70-229 Exam
Exam Number/Code: 70-229
Exam Name: MCDBA Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition

“MCDBA Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition”, also known as 70-229 exam, is a Microsoft certification. With the complete collection of questions and answers Q&as with Expert Explanations, Pass4sure has assembled to take you through 105 questions to your 70-229 Exam preparation. In the 70-229 exam resources, you will cover every field and category in MCDBA helping to ready you for your successful Microsoft Certification.

QUESTION 1
You work as a database developer for www.pass4sure.cc. www.Pass4sure.ccis an online training provider and its network consists of a single Active Directory domain named www.pass4sure.cc. All servers on the www.Pass4sure.ccnetwork run Microsoft Windows Server 2000 and the database servers run Microsoft SQL Server 2000. You are designing a database for www.pass4sure.cc. This database base must accommodate the customers who want to make reservations online or by phone to
sit for examinations. To make a reservation, a new customer is required to provide his/her name, telephone number, address and relevant examination information.
This relevant information includes details like certification, preferred dates and times. Once a reservation has been confirmed, the customer will receive a unique customer number, a unique reference number that pertains to the reservation, and
accurate examination information. This accurate information include details such as vendor, examination number, name of certification, data and time of the
reservation.
1. To make another reservation at a later time, the customer must provide his/her customer number.
2. To enquire about an existing reservation or to change it, the customer must provide the reservation’s reference number.
Examination numbers are assigned according to the certification that it contributes toward and are independent from vendor to vendor. Each vendor may offer one or more examinations towards certain certifications. The database should be
normalized to the third normal form. You create the following tables: CREATE TABLE Examinations
( Vendor int, ExamID int,
Certification nvarchar (20)) CREATE TABLE TimeTable
( Vendor int, ExamID int, ExamDate datetime)
Now you need to define the foreign keys for these tables. What should you do?

A. Define a FOREIGN KEY constraint on the Vendor, ExamID and ExamDate columns
in the TimeTable table that references the Examinations table.
B. Define a FOREIGN KEY constraint on the Vendor, ExamID and Certification columns in the Examinations table that references the TimeTable table.
C. Define a FOREIGN KEY constraint on the Vendor and ExamDate columns in the
TimeTable table that references the Examinations table.
D. Define a FOREIGN KEY constraint on the Vendor and ExamDate columns in the
Examinations table that references the TimeTable table. Answer: C

Explanation: Foreign Key constraints are used to enforce referential integrity of data.
Online Transaction Processing (OLTP) systems usually has a large number of relatively narrow interrelated tables. Thus for optimal performance regarding query activity, a database should comply with formal criteria called normal forms.
A First Normal Form for a database is when no table has columns that define similar attributes and if no columns contains multiple values in a single row.
A Second Normal Form for a database is if it complies with the first normal form; and also if each column that is not part of a primary key depends on all of the columns that are covered by the primary key in that table and not a subset of the columns that are covered by the primary key.
The Third Normal Form for a database is when it complies with the second normal form and if, in each table, columns that are not covered by the primary key do not depend on each other.
In this scenario:
1. Each row in the Examinations table represents an examination.
2. Each examination is uniquely identified by the vendor and the examination number
3. Each row in the
TimeTable table represents an individual occurrence of the examination that is registered
in the Examinations table.
4. For each examination occurrence in the TimeTable table, exactly one examination with the same combination of values in the Vendor and ExamID columns must exist in the Examinations table.
Thus the Vendor and ExamID columns constitute a foreign key on the TimeTable table that references the Vendor and the ExamID columns in the Examinations table.
You should use the following statements to define the primary and foreign keys on the
Examinations and TimeTable tables:
ALTER TABLE Examinations ADD PRIMARY KEY (ExamID, Vendor) ALTER TABLE TimeTable ADD
PRIMARY KEY (ExamID, Vendor, ExamDate),
FOREIGN KEY (ExamID, Vendor) REFERENCES Examinations (ExamID, Vendor) Reference:
Microsoft SQL Server 2000 Books Online (2004), Contents: Creating and Maintaining
Databases, “Databases”, “Database Design Considerations,” “Normalization.”
Microsoft SQL Server 2000 Books Online (2004), Contents: Creating and Maintaining
Databases, “Tables”, “Designing Tables,” “Using Constraints, Defaults, and Null Values,
” FOREIGN KEY constraints.”

QUESTION 2
You work as a database developer for www.pass4sure.cc. www.Pass4sure.ccis an online training provider and its network consists of a single Active Directory domain named www.pass4sure.cc. All servers on the www.Pass4sure.ccnetwork run Microsoft Windows Server 2000 and the database servers run Microsoft SQL Server 2000. You are designing a database for www.pass4sure.cc. This database base must accommodate the customers who want to make reservations online or by phone to
sit for examinations. To make a reservation, a new customer is required to provide his/her name, telephone number, address and relevant examination information.

This relevant information includes details like certification, preferred dates and
times. Once a reservation has been confirmed, the customer will receive a unique customer number, a unique reference number that pertains to the reservation, and accurate examination information. This accurate information include details such as vendor, examination number, name of certification, data and time of the
reservation.
1. To make another reservation at a later time, the customer must provide his/her customer number.
2. To enquire about an existing reservation or to change it, the customer must provide the reservation’s reference number.
The database must be normalized to the third normal form. To this end you need to decide on which tables you should create in the database.
What should you do?

A. Create a Customers table that contains only the columns for the CustomerID, Name, Address and Telephone number.
B. Create a Reservations table that contains only the columns for the CustomerID, Name, Address, Telephone number, reference number, vendor, examination number,
examination date and reservation date.
C. Create an Examinations table that contains only the columns for the vendor, examination number, examination date and time and certification.
D. Create a Reservations table that contains only the columns for the CustomerID, certification, vendor, examination number, examination date and reservation date.

Answer: A

Explanation: Normalization is usually applied to OLTP systems which are usually subject to extensive additions, deletions and modifications of data because in many situations normalization improves database performance.
A First Normal Form for a database is when no table has columns that define similar attributes and if no columns contains multiple values in a single row.
A Second Normal Form for a database is if it complies with the first normal form; and also if each column that is not part of a primary key depends on all of the columns that are covered by the primary key in that table and not a subset of the columns that are covered by the primary key.
The Third Normal Form for a database is when it complies with the second normal form and if, in each table, columns that are not covered by the primary key do not depend on each other.
In this scenario:
Customers constitute a separate entity that is independent of all other relevant entities. – thus you should create a Customers Table and include in it only the columns that specify information pertinent to the individual customer. This information would include details like name, address and telephone number. In order to uniquely identify each customer
and avoid including redundant data, you should include a column for CustomerID in the
Customers table. Incorrect answers:

pass4sure 70-229 2.93
Questions and Answers : 105 questions
Expected Date: October 21st , 2008
Price: $129.99 $89.99

Free Down: Pass4sure Microsoft 70-229 2.93
Free Down: PassGuide microsoft 70-229 2.93