Mar 2016 updated: Pass4sure Microsoft 98-364 torrent 86-102

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 98-364 Exam Dumps (PDF & VCE):
Available on: https://www.certleader.com/98-364-dumps.html


98-364 Product Description:
Exam Number/Code: 98-364 vce
Exam name: Microsoft Database Fundamentals
n questions with full explanations
Certification: Microsoft Certification
Last updated on Global synchronizing

Instant Access to Free VCE Files: Microsoft 98-364 Microsoft Database Fundamentals

98-364 examcollection

Question No. 86

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

Use the FROM keyword in a SELECT statement to return rows that meet a specific condition. 

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. ORDER BY 

C. UNION 

D. WHERE 

Answer:


Question No. 87

What is one difference between an update statement and a delete statement? 

A. An update statement can change only one row. 

B. A delete statement cannot use a where clause. 

C. An update statement does not remove rows from a table. 

D. A delete statement works only within a stored procedure. 

Answer:


Question No. 88

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

A row holds information for a single record in a table. 

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

C. Data type 

D. View 

Answer:


Question No. 89

Data in a database is stored in: 

A. Tables 

B. Queries 

C. Data types 

D. Stored procedures 

Answer: A


Question No. 90

In which situation do you need to perform a restore on a database? 

A. when data becomes corrupted in the database 

B. when you need to roll back a transaction 

C. when you encounter an error in your application 

D. when data needs to be deleted from the database 

Answer:


98-364 training

Question No. 91

HOTSPOT

The following illustration shows the structure of a clustered index in a single partition:


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


Answer: 



Question No. 92

What are three valid data manipulation language (DML) commands? (Choose three.)

A. INSERT 

B. COMMIT 

C. DELETE 

D. OUTPUT 

E. UPDATE 

Answer: A,C,E 

Explanation: http://en.wikipedia.org/wiki/Data_manipulation_language

Data manipulation languages have their functional capability organized by the initial word ina statement, which is almost always a verb. In the case of SQL, these verbs are: 

SELECT ... FROM ... WHERE ... 

INSERT INTO ... VALUES ... 

UPDATE ... SET ... WHERE ... 

DELETE FROM ... WHERE ...


Question No. 93

Which command should you use to give a user permission to read the data in a table? 

A. ALLOW SELECT 

B. LET READ 

C. PERMIT READ 

D. GRANT SELECT 

Answer:


Question No. 94

Which statement will result in the creation of an index?


A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Question No. 95

You have two tables named Salesperson and Sales. 

You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table. 

Which database object should you add to the Sales table? 

A. Nonclustered index 

B. Primary key 

C. Foreign key 

D. Clustered index 

Answer: B


98-364 download

Question No. 96

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.

Answer:


Question No. 97

One reason to create a stored procedure is to: 

A. Improve performance. 

B. Minimize storage space. 

C. Bypass case sensitivity requirements. 

D. Give the user control of the query logic. 

Answer:


Question No. 98

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

Use the ALTER statement to add a new table 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. No change is needed 

B. UPDATE 

C. INSERT 

D. CREATE 

Answer:


Question No. 99

You have a Department table and an Employee table in your database. 

You need to ensure that an employee can be assigned to only an existing department. 

What should you apply to the Employee table? 

A. A primary key 

B. An index 

C. A foreign key 

D. A unique constraint 

E. A data type 

Answer:


Question No. 100

You need to combine the results of two queries into a single result that contains all of the rows from both queries. 

Which Structured Query Language (SQL) statement should you use? 

A. TRUNCATE 

B. JOIN 

C. EXCEPT 

D. UNION 

Answer:


Question No. 101

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 

Answer:


Question No. 102

You need to store the contact information for each student in your school database. 

You should store each student's information in a: 

A. Stored procedure 

B. Function 

C. Row 

D. Variable 

Answer: