QUESTION 111

Why is it important to use standard SQL code when possible and know what is standard

and what isn’t? (Choose all that apply.)

 

A.

It is not important to code using standard SQL.

B.

Standard SQL code is more portable between platforms.

C.

Standard SQL code is more efficient.

D.

Knowing what standard SQL code is makes your knowledge more portable.

 

Correct Answer: BD

 

 

QUESTION 112

Which of the following is not a violation of the relational model?

 

A.

Using ordinal positions for columns

B.

Returning duplicate rows

C.

Not defining a key in a table

D.

Ensuring that all attributes in the result of a query have names

 

Correct Answer: D

 

 

QUESTION 113

What is the relationship between SQL and T-SQL?

 

A.

T-SQL is the standard language and SQL is the dialect in Microsoft SQL Server.

B.

SQL is the standard language and T-SQL is the dialect in Microsoft SQL Server.

C.

Both SQL and T-SQL are standard languages.

D.

Both SQL and T-SQL are dialects in Microsoft SQL Server.

 

Correct Answer: B

 

 

QUESTION 114

Which of the following correctly represents the logical query processing order of the various query clauses?

 

A.

SELECT > FROM > WHERE > GROUP BY > HAVING > ORDER BY

B.

FROM > WHERE > GROUP BY > HAVING > SELECT > ORDER BY

C.

FROM > WHERE > GROUP BY > HAVING > ORDER BY > SELECT

D.

SELECT > ORDER BY > FROM > WHERE > GROUP BY > HAVING

 

Correct Answer: B

 

 

 

QUESTION 115

Which of the following is invalid? (Choose all that apply.)

 

A.

Referring to an attribute that you group by in the WHERE clause

B.

Referring to an expression in the GROUP BY clause; for example, GROUP BY YEAR(orderdate)

C.

In a grouped query, referring in the SELECT list to an attribute that is not part of

D.

the GROUP BY list and not within an aggregate function Referring to an alias defined in the SELECT clause in the HAVING clause

 

Correct Answer: CD

 

 

QUESTION 116

What is true about the result of a query without an ORDER BY clause?

 

A.

It is relational as long as other relational requirements are met.

B.

It cannot have duplicates.

C.

The order of the rows in the output is guaranteed to be the same as the insertion order.

D.

The order of the rows in the output is guaranteed to be the same as that of the clustered index.

 

Correct Answer: A

 

 

QUESTION 117

What is the importance of the ability to assign attribute aliases in T-SQL? (Choose all

that apply.)

 

A.

The ability to assign attribute aliases is just an aesthetic feature.

B.

An expression that is based on a computation results in no attribute name unless you assign one with an alias, and this is not relational.

C.

T-SQL requires all result attributes of a query to have names.

D.

Using attribute aliases, you can assign your own name to a result attribute if you need it to be different than the source attribute name.

 

Correct Answer: BD

 

 

QUESTION 118

What are the mandatory clauses in a SELECT query, according to T-SQL?

 

A.

The FROM and SELECT clauses

B.

The SELECT and WHERE clauses

C.

The SELECT clause

D.

The FROM and WHERE clauses

 

Correct Answer: C

 

 

QUESTION 119

Which of the following practices are considered bad practices? (Choose all that apply.)

 

A.

Aliasing columns by using the AS clause

B.

Aliasing tables by using the AS clause

C.

Not assigning column aliases when the column is a result of a computation

D.

Using * in the SELECT list

 

Correct Answer: CD

 

 

QUESTION 120

Why is it important to use the appropriate type for attributes?

 

A.

Because the type of your attribute enables you to control the formatting of the values

B.

Because the type constrains the values to a certain domain of supported values

C.

Because the type prevents duplicates

D.

Because the type prevents NULLs

 

Correct Answer: B

 

Free VCE & PDF File for Microsoft 70-461 Real Exam

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