98-364 Exam
How Does Pass4sure Microsoft 98-364 simulations Work?
We provide real 98-364 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Microsoft 98-364 Exam quickly & easily. The 98-364 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Microsoft 98-364 dumps pdf and vce product and material, you can easily pass the 98-364 exam.
Q1. You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.
What is the result in the database?
A. The table will be corrupted.
B. Forty (40) rows will be deleted from the table.
C. The transaction will restart.
D. No rows will be deleted from the table.
Answer: D
Q2. You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?
A. ALTER
B. INSERT
C. CREATE
D. UPDATE
Answer: A
Q3. Which two keys establish a relationship between two tables? (Choose two.)
A. candidate
B. foreign
C. superkey
D. local
E. primary
Answer: B,E
Q4. You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q5. DRAG DROP
You have two database tables as defined below. The first table contains information about students. The second table contains information about courses. The two tables are related by CourseID.
Match the CourseName to the StudentName.
Instructions: To answer, drag the appropriate CourseName from the column on the left to its StudentName on the right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.
Answer:
Q6. Which statement deletes the rows where the employee's phone number is not entered?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q7. HOTSPOT
You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Answer:
Q8. DRAG DROP
Your class project requires that you help a charity set up a website.
The website collects information about volunteers. Each volunteer record must be uniquely identified.
The following information is stored for each volunteer:
Given name
Surname
Date of birth
Phone number
Photo
You need to create a table to meet the requirements.
Match the Structured Query Language SQL statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right. Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.
Answer:
Q9. You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
A. Inherited delete
B. Cascade delete
C. Functional delete
D. Waterfall delete
E. Domino delete
Answer: B
Q10. Denormalization is performed in order to:
A. Reduce redundancy.
B. Eliminate repeating groups.
C. Create smaller tables.
D. Improve query performance.
Answer: D