[Free] Download New Latest (January 2016) Microsoft 98-364 Real Exam 121-130

QUESTION 123

Mark works as a Database Administrator for DataOneWorld Inc. Management instructs him to provide an additional security layer to the database to prevent unauthorized viewing of data with the help of an algorithm called cipher. Which of the following will help him to accomplish the task?

A.     Native auditing

B.     Authentication

C.     Encryption

D.     Abstraction

Correct Answer: C

QUESTION 124

Suzanne works as a Database Designer for DataOneWorld Inc. She is assigned the task of decomposing the components of a database, but she has to ensure that all the components are decomposed to only some extent. Which of the following approaches will she use to accomplish the task?

A.     Mixed approach

B.     Inside-out approach

C.     Top-down approach

D.     Bottom-up approach

Correct Answer: A

QUESTION 125

You have a table that contains the following data.

You break the table into the following two tables.

This process is referred
to as:

Correct Answer: B

QUESTION 126

You have the following table definition:

CREATE TABLE Product

(ID INTEGER PRIMARY KEY,

Name VARCHAR(20),

Quantity INTEGER)

The Product table contains the following data.

You execute the following statement:

SELECT Name FROM Product WHERE Quantity IS NOT NULL

How many rows are returned?

Correct Answer: D

QUESTION 127

You need to disable User1’s access to view the data in the Customer table. Which statement should you use?

Correct Answer: C

QUESTION 128

DRAG DROP

You need to set up a database to provide a view of North American mammals.

Match the Structured Query Language (SQL) statements to the SQL query.

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.

Correct Answer:

QUESTION 129

While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.

You need to establish a relationship between the data that is in the two tables.

Which constraint should you define?

Correct Answer: B

QUESTION 130

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

Correct Answer: C

Free VCE & PDF File for Microsoft 98-364 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…