Limited Time Discount Offer 30% Off - Ends in 02:00:00

×

Microsoft MTA 98-364 Exam - Database Fundamentals

Download Free Microsoft 98-364 Exam Questions

Questions & Answers for Microsoft 98-364

Showing 1-15 of 130 Questions

Question #1

You have the following table definition:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:

You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?

A. an error stating that NULL values are not allowed

B. a new row in the table

C. an error stating that duplicate IDs are not allowed

D. a syntax error

Question #2

A view can be used to:

A. Save an extra copy of data stored in a separate table.

B. Limit access to specific rows or columns of data in a table.

C. Ensure referential integrity.

D. Save historical data before deleting it from the base table.

Question #3

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

Question #4

Which statement deletes the rows where the employee's phone number is not entered?

A. Option A

B. Option B

C. Option C

D. Option D

Question #5

You have the following SQL query
SELECT * FROM dbo.ProAthlete WHERE Salary > 500000
The query takes too much time to return data.
You need to improve the performance of the query.
Which item should you add to the Salary column?

A. Non-null constraint

B. Default constraint

C. Index

D. Foreign key

Question #6

Which two keys establish a relationship between two tables? (Choose two.)

A. candidate

B. foreign

C. superkey

D. local

E. primary

Question #7

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

A. No change is needed

B. INTERSECT

C. ALL

D. UOIN

Question #8

Your class project requires that you help a charity set up a website.
The website collects information about volunteers. Each volunteer record must be uniquely
identified.
The following information is stored for each volunteer:
✑ Given name
✑ Surname
✑ Date of birth
✑ Phone number
✑ Photo
You need to create a table to meet the requirements.
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.

Question #9

This question requires that you evaluate the underlined text to determine if it is correct.
Ports 20 and 21 are the default ports to secure a SQL Server.
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. 1433 and 1434

C. 411 and 412

D. 67 and 68

Question #10

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 #11

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.

Question #12

You have a table named Student that contains 100 rows. Some of the rows have a NULL
value in the FirstName column.
You execute the following statement:
DELETE FROM Student
What is the result?

A. All rows in the table will be deleted.

B. All rows containing a NULL value in the FirstName column will be deleted.

C. You will receive an error message.

D. All rows and the table definition will be deleted.

Question #13

Your class project requires that you help a charity to create a website that registers
volunteers.
The website must store the following data about the volunteers:
✑ Given name
✑ Surname
✑ Telephone number
✑ Email address
You need to recommend a correct way to store the data.
What do you recommend?

A. Create a table that contains columns that are named given name, surname, phone number, and email.

B. Create a table that contains rows that are named given name, surname, phone number, and email.

C. Create a view that contains columns that are named given name surname, phone number, and email.

D. Create a view that contains rows that are named given name surname, phone number, and email

Question #14

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

Question #15

You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's
unique ID.
What will make this type of search more efficient?

A. A cursor

B. A subquery

C. A trigger

D. An index

Try Our Special 30% Discount Offer for
Premium 98-364 VCE File

  • Verified by experts

98-364 Premium File

  • Real Questions
  • Last Update: Nov 13, 2019
  • 100% Accurate Answers
  • Fast Exam Update

$14.99

$21.41

AUTUMN SALE: 30% DISCOUNT
This is ONE TIME OFFER

You save
30%

Enter Your Email Address to Receive Your 30% Discount Code

AUTUMN SALE: 30% DISCOUNT

You save
30%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@exam-labs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports