Independence Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Microsoft 98-364 Database Fundamentals Exam Practice Test

Demo: 19 questions
Total 130 questions

Database Fundamentals Questions and Answers

Question 1

Which keyword can be used in a create table statement?

Options:

A.

ORDER BY

B.

DISTINCT

C.

GROUP BY

D.

UNIQUE

Question 2

A database contains two tables named Customer and Order.

You execute the following statement:

DELETE FROM Order

WHERE CustomerID = 209

What is the result?

Options:

A.

The first order for CustomerID 209 is deleted from the Order table.

B.

All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.

C.

All orders for CustomerID 209 are deleted from the Order table.

D.

CustomerID 209 is deleted from the Customer table.

Question 3

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.)

Options:

A.

ChapterId

B.

LanguageId

C.

Country

D.

Region

E.

City

F.

LanguageName

Question 4

This question requires that you evaluate the underlined text to determine if it is correct.

The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.

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

Options:

A.

No change is needed

B.

INTERSECT

C.

ALL

D.

UOIN

Question 5

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.

Options:

A.

No change is needed.

B.

Data manipulation language (DML) statements

C.

Data definition language (DDL) statements

D.

A unique constraint

Question 6

You have a table named Customer. You need to add a new column named District.

Which statement should you use?

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 7

You need to populate a table named EmployeeCopy with data from an existing table named Employee.

Which statement should you use?

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 8

Which type of index changes the order in which the data is stored in a table?

Options:

A.

non-sequential

B.

sequential

C.

non-clustered

D.

clustered

Question 9

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?

Options:

A.

1

B.

2

C.

3

D.

4

Question 10

On which database structure does an update statement operate?

Options:

A.

Table

B.

User

C.

Trigger

D.

Role

Question 11

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Options:

Question 12

A named group of SQL statements that can be executed in a database is called a:

Options:

A.

Subroutine

B.

Formula

C.

Stored procedure

D.

Method

Question 13

The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Options:

Question 14

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:

Options:

A.

Inherited delete

B.

Cascade delete

C.

Functional delete

D.

Waterfall delete

E.

Domino delete

Question 15

The following illustration shows backup strategies that use the simple recovery model and the full recovery model:

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Options:

Question 16

You have the following table:

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Options:

Question 17

One difference between a function and a stored procedure is that a function:

Options:

A.

Must be called from a trigger.

B.

Must return a value.

C.

Cannot contain a transaction.

D.

Cannot accept parameters.

Question 18

You need to store the first name, last name, and student ID for 100 students.

This information will be stored in a table as:

Options:

A.

100 items and three cells.

B.

100 rows and three columns.

C.

three rows and 100 columns.

D.

three items and 100 cells.

Question 19

You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.

Which data type should you use?

Options:

A.

VARCHAR (3, 30)

B.

CHAR (3, 30)

C.

VARCHAR (30)

D.

CHAR (30)

Demo: 19 questions
Total 130 questions