98-364 Exam
[Exact] 98-364 Microsoft latest exam 51-60 (Oct 2021)
Our pass rate is high to 98.9% and the similarity percentage between our 98-364 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Microsoft 98-364 exam in just one try? I am currently studying for the Microsoft 98-364 exam. Latest Microsoft 98-364 Test exam practice questions and answers, Try Microsoft 98-364 Brain Dumps First.
Q51. DRAG DROP
You need to set up a database to provide a view of North American mammals.
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:
Q52. Which keyword would you use in a select statement to return rows that meet a specific condition?
A. WHERE
B. UNION
C. ORDER BY
D. FROM
Answer: A
Q53. This question requires that you evaluate the underlined text to determine if it is correct.
Use indexing to create, remove, or change database objects.
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 correct.
A. No change is needed.
B. Data manipulation language (DML) statements
C. Data definition language (DDL) statements
D. A unique constraint
Answer: C
Q54. This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALTER statement to add a new table in a database.
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 correct.
A. No change is needed
B. UPDATE
C. INSERT
D. CREATE
Answer: D
Q55. You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to glass.
What should you include in the update statement?
A. SET ProduetName = 'glass'
B. LET ProduetName = 'glass'
C. EXEC ProduetName = 'glass'
D. ASSIGN ProduetName = 'glass'
Answer: A
Q56. You ate creating a database object named Student to store the following data:
Which syntax should you use to create the object?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q57. 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
Q58. Which category of SQL statements is used to add, remove, and modify database structures?
A. Data access language (DAL)
B. Data manipulation language (DML)
C. Data control language (DCL)
D. Data definition language (DDL)
Answer: D
Q59. 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:
Q60. This question requires that you evaluate the underlined text to determine if it is correct.
In a database table, each column represents a unique record.
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 correct
A. No change is needed
B. Table
C. Index
D. Row
Answer: D