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

Ensurepass

QUESTION 161

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

 

A view can be used to ensure referential integrity.

 

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 162

The component that holds information for a single entry in a table is called a:

 

A.

Data type

B.

Row

C.

Column

D.

View

 

Correct Answer: B

 

 

QUESTION 163

You have a table named Employee that includes the following columns:

 

EmployeeID

 

Smp1oyeeName

 

Which statement should you use to return the number of rows in the table?

 

clip_image002

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: D

 

 

 

QUESTION 164

Data in a database is stored in:

 

A.

Tables

B.

Queries

C.

Data types

D.

Stored procedures

 

Correct Answer: A

 

 

QUESTION 165

You have a table named Customer. You need to add a new column named District. Which statement should you use?

 

clip_image004

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: D

 

 

QUESTION 166

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

 

Correct Answer: A

 

 

QUESTION 167

You have a database table that contains the following columns:

 

clip_image006

 

You must insert the following record into the table:

 

clip_image008

 

Which two Structured Query Language (SQL) statements can you use? (Choose two.)

 

clip_image010

 

< td style="border-top-style: none; border-left-style: none; background: white; border-bottom-style: none; padding-bottom: 0cm; padding-top: 0cm; border-right-style: none; padding-left: 0cm; padding-right: 0cm" valign="top" width="708">

Option B

A.

Option A

B.

C.

Option C

D.

Option D

 

Correct Answer: AC

 

 

 

 

 

QUESTION 168

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

 

Correct Answer: D

 

 

QUESTION 169

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

 

Correct Answer: B

 

 

QUESTION 170

On which database structure does an insert statement operate?

 

A.

Role

B.

Trigger

C.

User

D.

Stored procedure

E.

Table

 

Correct Answer: E

 

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…