Microsoft 98-364 Certification | Exam Guide | Syllabus | Questions
Make 98-364 Certification Exam Easy with edusum.com
98-364 Exam Detail Exam Code
98-364
Full Exam Name
Microsoft Technology Associate (MTA) - Database Fundamentals
Number of Questions
40-60
Practice Exams
Microsoft 98-364 Certification Practice Exam
Passing Score
700 / 1000
Time Limit
45 mins
Books / Training
40364A: Database Administration Fundamentals: MTA Exam 98-364 (three days)
Enjoy success with Edusum.com
How to Prepare for 98-364 •
Perform enough practice with Microsoft system with related Microsoft 98-364 certification subjects
•
Identify the key configuration, workflow and data flow
•
Understand the all Syllabus Topics of Exam which are Given in Description.
•
Identify your weak areas from practice test and do more practice with system
•
Repeat practice exams and try to score 100% on www.edusum.com
Enjoy success with Edusum.com
98-364 Exam Questions Enjoy success with Edusum.com
Q 1) What would be one reason to routinely back up your database? Option. a) To be able to restore the database to a functioning state after a hardware
or server failure b) To be able to control access to specific database objects c) To be able to build temporary tables to store transient data d) To be able to control database access by unauthorized users
Enjoy success with Edusum.com
ANSWER a) To be able to restore the database to a functioning state after a hardware or server
failure Enjoy success with Edusum.com
Q 2) You need to track organization members. For each organization member, you need to keep track of the member's unique membership number, name and address, membership expiration date, and the payment date and amount for each dues payment received from the member. A table in your database would represent: Option. a) the membership expiration date for each member.
b) the members of the organization. c) the address for each member. d) the amount of each payment made by each member.
Enjoy success with Edusum.com
ANSWER b) the members of the organization.
Enjoy success with Edusum.com
Q 3) A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order WHERE CustomerID = 209 What is the result? Option. a) The first order for CustomerID 209 is deleted from the Order table. b) All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table. c) All orders for CustomerID 209 are deleted from the Order table.
d) CustomerID 209 is deleted from the Customer table.
Enjoy success with Edusum.com
ANSWER c) All orders for CustomerID 209 are deleted from the Order table.
Enjoy success with Edusum.com
Q 4) On which database structure does an insert statement operate? Option.
a) Role b) Trigger c) User
d) Stored procedure e) Table
Enjoy success with Edusum.com
ANSWER e) Table
Enjoy success with Edusum.com
Q 5) What is the purpose of including a COLLATE clause in a column definition? Option. a) To create a relationship with a column in a different table b) To ensure functional dependency
c) To create a computed column that can be included in an index d) To ensure that all values entered in the column fall within a specific range e) To specify sorting rules that are different than those used for the other
columns in the table
Enjoy success with Edusum.com
ANSWER e) To specify sorting rules that are different than those used for the other columns in the
table Enjoy success with Edusum.com
More Info on Microsoft Certification •
For more information on Microsoft Certification please refer to FAQs
•
A Microsoft certification is increasingly becoming important for the career of employees
•
The fees information are for the informative purposes and do not serve as an official offering and are subject to change
•
Focus on the guide for online registration and you will very soon find it out
Enjoy success with Edusum.com
More Info on Microsoft Certification VISIT www.edusum.com