最新的Microsoft Database Fundamentals - 98-364免費考試真題
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?
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?
正確答案: C
HOTSPOT
You have a user that has server roles as defined below:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
You have a user that has server roles as defined below:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
正確答案:
A view can be used to:
正確答案: B
This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALLOW SELECT command to give a user permission to read the data in a table.
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
Use the ALLOW SELECT command to give a user permission to read the data in a table.
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
正確答案: C
You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:
You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.
Which two columns should you select? (Choose two.)
You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.
Which two columns should you select? (Choose two.)
正確答案: B,C
You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
Which database term is used to describe the relationship between ProductID and ProductCategory?
正確答案: A
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
正確答案: C
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.
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.
正確答案:
What is one difference between an update statement and a delete statement?
正確答案: C
One difference between a function and a stored procedure is that a function:
正確答案: C