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

Ensurepass

QUESTION 121

John works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database. John wants to insert records in a table where the database is structured in a fixed format. Which of the following data models will he use to accomplish the task?

 

A.     Object relational data model

B.     Entity-Relationship Model

C.     Network data model

D.     Relational model

 

Correct Answer: D

 

 

QUESTION 122

You are a Database Administrator of MySQL database. Few days back, your server crashed. Now, it is up and online. You need to check the integrity of various tables used in the database. You need to issue the CHECK TABLE command. For which of the following tables will this command work? Each correct answer represents a complete solution. Choose two.

 

A. FEDERATED

B. MyISAM

C. MERGE

D. InnoDB

 

Correct Answer: BD

 

 

 

 

 

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.

 

clip_image002

 

You break the table into the following two tables.

 

clip_image004

 

This process is referred
to as:

 

A.

defragmentation

B.

normalization

C.

fragmentation

D.

denormalization

 

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.

 

clip_image006

 

You execute the following statement:

 

SELECT Name FROM Product WHERE Quantity IS NOT NULL

How many rows are returned?

 

A.

0

B.

1

C.

2

D.

3

E.

4

 

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?

 

clip_image008

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

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.

 

clip_image010

 

Correct Answer:

clip_image012

 

 

 

 

 

 

 

 

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?

 

A.

Foreign key

B.

Index key

C.

Link key

D.

Default key

 

Correct Answer: B

 

 

QUESTION 130

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.

 

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…