We share the latest updated Microsoft 98-364 test questions and answers for free, all test questions are real cracked, guaranteed to be true and effective! You can practice the test online!
Or download the latest 98-364 exam pdf. The free exam questions are only part of what we share. If you want to get the complete Microsoft 98-364 exam questions and answers, you can get them in lead4pass.
The lead4pass 98-364 exam dumps contain VCE dumps and PDF dumps.
Microsoft 98-364 Exam “Database Fundamentals” https://www.leads4pass.com/98-364.html (Total Questions: 140 Q&A)

Get FREE Microsoft 98-364 pdf from Lead4Pass for free

Free share Microsoft 98-364 exam PDF from Fulldumps provided by Lead4pass
https://www.fulldumps.com/wp-content/uploads/2021/05/Lead4pass-Microsoft-MTA-98-364-Exam-Dumps-Braindumps-PDF-VCE.pdf

Microsoft 98-364 exam questions online practice test

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) microsoft 98-364 exam questions q1

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
Correct Answer: B

 

QUESTION 2
You have two database tables as defined below. The first table contains information about students. The second table
contains information about courses. The two tables are related by CourseID.microsoft 98-364 exam questions q2

Match the CourseName to the StudentName.
Instructions: To answer, drag the appropriate CourseName from the column on the left to its StudentName on the right.
Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.
Select and Place:

microsoft 98-364 exam questions q2-1

Correct Answer:

microsoft 98-364 exam questions q2-2

 

QUESTION 3
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department
This type of operation is called a/an:
A. Intersection
B. Outer join
C. Equi-join
D. Cartesian product
Correct Answer: D

 

QUESTION 4
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.
Select and Place:microsoft 98-364 exam questions q4

Correct Answer:

microsoft 98-364 exam questions q4-1

 

QUESTION 5
What defines the amount of storage space that is allocated to a value in a column?
A. format
B. key
C. data type
D. validator
Correct Answer: C

 

QUESTION 6
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
A. 0
B. 3
C. 6
D. 9
Correct Answer: D


QUESTION 7
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct
selection is worth one point.
Hot Area:microsoft 98-364 exam questions q7

Correct Answer:

microsoft 98-364 exam questions q7-1

 

QUESTION 8
You have a database table that contains the following columns:microsoft 98-364 exam questions q8

You must insert the following record into the table: Which two Structured Query Language (SQL) statements can you
use? (Choose two.)

microsoft 98-364 exam questions q8-1

A. Option A
B. Option B
C. Option C
D. Option D
Correct Answer: BC

 

QUESTION 9
The following graphic shows the components of a SQL Server application. You access the SQL Server application
through Internet Explorer. microsoft 98-364 exam questions q9

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

microsoft 98-364 exam questions q9-1

Correct Answer:

microsoft 98-364 exam questions q9-2

 

QUESTION 10
You work at a coffee shop. They ask you to set up a website that stores charges on purchases.
You need to recommend a data type in a database table to run financial functions against the charged amounts.
Which data type should you recommend?
A. Money
B. Bit
C. Varchar
D. Binary
Correct Answer: A

 

QUESTION 11
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
Correct Answer: D

 

QUESTION 12
This question requires that you evaluate the underlined text to determine if it is correct.
A view can be used to ensure referential integrity.
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. Save an extra copy of data stored in a separate table.
C. Limit access to specific rows or columns of data in a table.
D. Save historical data before deleting it from the base table.
Correct Answer: C


QUESTION 13
You develop a database to store data about textbooks. The data must be stored to process at a later time. Which
database object should you use to store the data?
A. View
B. Table
C. Function
D. Stored procedure
Correct Answer: D


Thank you for reading! I have told you how to successfully pass the Microsoft 98-364 exam.
You can choose: https://www.leads4pass.com/98-364.html to directly enter the 98-364 Exam dumps channel! Get the key to successfully pass the exam! Wish you happiness!

Get free Microsoft 98-364 exam PDF online: https://www.fulldumps.com/wp-content/uploads/2021/05/Lead4pass-Microsoft-MTA-98-364-Exam-Dumps-Braindumps-PDF-VCE.pdf