70-451 TS Braindump
ExamSoon 70-451 Exams
Microsoft PRO: Designing Database Solutions and Data Access Using Microsoft
SQL Server 2008
O rder : 70-451 Exam
Practice Exam: 70-451
Exam Number/Code: 70-451
Exam Name: PRO: Designing Database Solutions and Data Access Using
Microsoft SQL Server 2008
Questions and Answers: 50 Q&As
Free 70-451 Braindumps
Exam : Microsoft 70-451
Title : PRO:MS SQL Serv 2008, Design & Optimizing DB Admin Solution
1. You work in an International company named TAKEEEN. And you're in charge of the database of your company.
You intend to use SQL Server 2008 to create a database solution. The full-text search component is installed in the
database which supports a Web site.
Look at the exhibit below:
You intend to create a table named Courses which has the structure above.
On the basis of the CourseTitle field, users of the Web site will search for courses.
When the search is launched for a course by a user, a full-text must be constructed to ensure the compliances
below: when the exact search phrase is found, rows are returned; rows are in order of how well they match with the
search phrase.
So what should you specify in the full-text query?
A. A CONTAINS predicate
B. A FREETEXT predicate
C. A CONTAINSTABLE function
D. A FREETEXTTABLE function
Answer: C
2. You work in an International company named TAKEEEN. And you're in charge of the database of your company.
You intend to use SQL Server 2008 to create a database. There's a table which is partitioned into four geographic
regions in the database. The table is named Selling.Items. Look at the stored procedures below:
CREATE STORED PROCEDURE usp_Update
@RegionID tinyint
AS
UPDATE Sales.Inventory
SET Qty = T.CurrentQuantity
FROM Sales.Inventory I
JOIN Sales.TempData T ON I.ItemID = T.ItemID
AND I.RegionID = @RegionID;
You use the stored procedure above, the UPDATE statement locks the Sales.Inventory table. So what should you do
to prevent this from happening?
A. You should run this Transact-SQL statement: ALTER