98-364 Exam
Top 10 faq 98-364 for IT engineers (11 to 20)
Pinpoint of 98-364 study guide materials and guidance for Microsoft certification for IT specialist, Real Success Guaranteed with Updated 98-364 pdf dumps vce Materials. 100% PASS Microsoft Database Fundamentals exam Today!
Q11. HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Answer:
Q12. You have a table of products with fields for ProductID, Name, and Price.
You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.
Which clause should you use in your update statement?
A. THAT
B. WHERE
C. GROUP BY
D. HAVING
Answer: B
Q13. You need to combine the results of two queries into a single result that contains all of the rows from both queries.
Which Structured Query Language (SQL) statement should you use?
A. TRUNCATE
B. JOIN
C. EXCEPT
D. UNION
Answer: D
Q14. You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student's first name in the table?
A. UPDATE
B. CHANGE
C. SELECT
D. INSERT
Answer: A
Q15. You have a table named Employee that includes the following columns:
EmployeeID
Smp1oyeeName
Which statement should you use to return the number of rows in the table?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q16. HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Answer:
Q17. Which two elements are required to define a column? (Choose two.)
A. A name
B. A key
C. An index
D. A data type
Answer: A,D
Q18. You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.
You execute the following statement:
DELETE FROM Student
What is the result?
A. All rows in the table will be deleted.
B. All rows containing a NULL value in the FirstName column will be deleted.
C. You will receive an error message.
D. All rows and the table definition will be deleted.
Answer: A
Q19. You have a table named Product that contains the following data.
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
A. a foreign key constraint violation
B. a syntax error
C. a new row in the Product table
D. a primary key constraint violation
E. a new row in the Category table
Answer: D
Q20. This question requires that you evaluate the underlined text to determine if it is correct.
You have two tables. Each table has three rows.
Nine rows will be included in the Cartesian product of these two tables.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.
A. No change is needed
B. Zero
C. Three
D. Six
Answer: A