This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Fri Nov 22 10:48:37 2024 / +0000 GMT ___________________________________________________ Title: [TESTS SOFTWARE & PDF] New Published Exam Microsoft 70-461 Practice Test Questions Braindump2go Guarantee You 100% Pass! (111-122) --------------------------------------------------- 2015 Timesaving Comprehensive Guides For Microsoft 70-461 Exam: Using Latst Released Braindump2go 70-461 Practice Tests Questions, Quickly Pass 70-461 Exam 100%! Following Questions and Answers are all the New Published By Microsoft Official Exam Center! Vendor: MicrosoftExam Code: 70-461Exam Name: Querying Microsoft SQL Server 2012 QUESTION 111Why is it important to use standard SQL code when possible and know what is standardand 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.    Answer: BD QUESTION 112Which of the following is not a violation of the relational model? A.    Using ordinal positions for columnsB.    Returning duplicate rowsC.    Not defining a key in a tableD.    Ensuring that all attributes in the result of a query have names Answer: D QUESTION 113What 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. Answer: B QUESTION 114Which of the following correctly represents the logical query processing order of the various query clauses? A.    SELECT > FROM > WHERE > GROUP BY > HAVING > ORDER BYB.    FROM > WHERE > GROUP BY > HAVING > SELECT > ORDER BYC.    FROM > WHERE > GROUP BY > HAVING > ORDER BY > SELECTD.    SELECT > ORDER BY > FROM > WHERE > GROUP BY > HAVING Answer: B QUESTION 115Which of the following is invalid? (Choose all that apply.) A.    Referring to an attribute that you group by in the WHERE clauseB.    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 ofD.    the GROUP BY list and not within an aggregate function Referring to an alias defined in the SELECT clause in the HAVING clause Answer: CD QUESTION 116What 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. Answer: A QUESTION 117What is the importance of the ability to assign attribute aliases in T-SQL? (Choose allthat 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. Answer: BD QUESTION 118What are the mandatory clauses in a SELECT query, according to T-SQL? A.    The FROM and SELECT clausesB.    The SELECT and WHERE clausesC.    The SELECT clauseD.    The FROM and WHERE clauses Answer: C QUESTION 119Which of the following practices are considered bad practices? (Choose all that apply.) A.    Aliasing columns by using the AS clauseB.    Aliasing tables by using the AS clauseC.    Not assigning column aliases when the column is a result of a computationD.    Using * in the SELECT list Answer: CD QUESTION 120Why 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 valuesB.    Because the type constrains the values to a certain domain of supported valuesC.    Because the type prevents duplicatesD.    Because the type prevents NULLs Answer: B QUESTION 121Which of the following functions would you consider using to generate surrogate keys?(Choose all that apply.) A.    NEWIDB.    NEWSEQUENTIALIDC.    GETDATED.    CURRENT_TIMESTAMP Answer: AB QUESTION 122You need to create a view named uv_CustomerFullNames. The view must prevent the underlying structure of the customer table from being changed.Part of the correct T-SQL statement has been provided in the answer area. Provide the complete code. Answer: CREATE VIEW sales.uv_CustomerFullNamesWITH SCHEMABINDINGAS SELECTFirstName,LastNameFROM Sales.Customers Instant Download Braindump2go New Released Microsoft 70-461 Exam Dumps PDF & VCE! Enjoy 1 year Free Updation! 100% Exam Pass Guaranteed Or Full Money Back! http://www.braindump2go.com/70-461.html --------------------------------------------------- Images: http://www.itexamquiz.com/braindump2go/bdimages/8c0718a27bf4_98AC/1102.png http://www.itexamquiz.com/braindump2go/bdimages/8c0718a27bf4_98AC/wps2370.tmp_thumb2_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/8c0718a27bf4_98AC/152.png --------------------------------------------------- --------------------------------------------------- Post date: 2015-02-05 02:53:45 Post date GMT: 2015-02-05 02:53:45 Post modified date: 2015-02-05 02:53:45 Post modified date GMT: 2015-02-05 02:53:45 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com