98-364試験無料問題集（130題）「Microsoft Database Fundamentals 認定」

出題：1

This question requires that you evaluate the underlined text to determine if it is correct.
First normal form requires that a database excludes repeating groups.
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. Composite keys

B. No change is needed.

C. Duplicate rows

D. Foreign keys

正解：B 解答を投票する

出題：2

You assign User1 a set of permissions that include the WITH GRANT OPTION.
The WITH GRANT OPTION enables User1 to:

A. request a log of permission use.

B. delegate permissions to other users.

C. view other users' permissions.

D. create new database users.

正解：D 解答を投票する

出題：3

Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?

A. Option D

B. Option C

C. Option A

D. Option B

正解：A 解答を投票する

出題：4

You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data:

You need to normalize the data to third normal form.
How many tables should you create?

A. 2

B. 1

C. 4

D. 3

正解：D 解答を投票する

出題：5

This question requires that you evaluate the underlined text to determine if it is correct.
Views are database objects that contain all of the data 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. Stored procedures

B. No change is needed

C. Tables

D. Queries

正解：C 解答を投票する

出題：6

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. Functional delete

B. Cascade delete

C. Inherited delete

D. Waterfall delete

E. Domino delete

正解：B 解答を投票する

出題：7

You need to enable a new employee to authenticate to your database.
Which command should you use?

A. ALTER USER

B. CREATE USER

C. ALLOW USER

D. INSERT USER

E. ADD USER

正解：B 解答を投票する

出題：8

The Product table contains the following data.

You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantity > 18
What is the value returned by this statement?

A. 2

B. 1

C. 4

D. 3

正解：D 解答を投票する

98-364試験無料問題集「Microsoft Database Fundamentals 認定」