Microsoft Database Fundamentals - 98-364 Exam Questions

QUESTION NO: 1
The component that holds information for a single entry in a table is called a:

QUESTION NO: 2
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.

QUESTION NO: 3
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.

QUESTION NO: 4
You have a database table that contains the following columns:

You must insert the following record into the table:

Which two Structured Query Language (SQL) statements can you use? (Choose two.)

QUESTION NO: 5
You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?

QUESTION NO: 6
You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?

QUESTION NO: 7
You need to delete a database table.
Which data definition language (DDL) keyword should you use?

QUESTION NO: 8
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

QUESTION NO: 9
Which keyword would you use in a select statement to return rows that meet a specific condition?

QUESTION NO: 10
One difference between a function and a stored procedure is that a function: