Share some MTA 98-364 exam questions and answers below.
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
A. 0
B. 3
C. 6
D. 9
Answer: D
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database.
What is the result of the script?
A. The Customer table no longer exists.
B. The Customer table is unaffected.
C. The Customer table exists but has no data.
D. The script fails.
Answer: A
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department
This type of operation is called a/an:
A. intersection.
B. outer join.
C. equi-join.
D. Cartesian product.
Answer: D
You have a table that contains the following data.
This process is referred to as:
A. defragmentation.
B. normalization.
C. fragmentation.
D. denormalization.
Answer: B
One reason to add an index is to:
A. decrease storage space.
B. increase database security.
C. improve performance of select statements.
D. improve performance of insert statements.
Answer: C
The material including practice questions and answers. The information we have could give you the opportunity to practice issues, and ultimately achieve your goal that through Microsoft 98-364 exam certification.There is no site can compare with Passtcert Microsoft MTA 98-364 exam latest dumps. This is unprecedented true and accurate test materials. To help each candidate to pass the exam, our IT elite team explore the real exam constantly. I can say without hesitation that this is definitely a targeted training material. The Passtcert website is not only true, but the price of materials are very reasonable.
No comments:
Post a Comment