Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Microsoft SQL Server 2012 Certification Exam Sample Questions and Answers, Exams of Database Programming

A set of sample questions and answers for the microsoft sql server 2012 certification exam (70-461). It covers various aspects of querying microsoft sql server, including isolation levels, indexes, statistics, and transact-sql queries. Useful for individuals preparing for the 70-461 exam and seeking to enhance their understanding of sql server querying concepts.

Typology: Exams

2024/2025

Available from 11/10/2024

zaza-maica
zaza-maica 🇬🇧

3

(3)

1.4K documents

Partial preview of the text

Download Microsoft SQL Server 2012 Certification Exam Sample Questions and Answers and more Exams Database Programming in PDF only on Docsity!

Querying Microsoft SQL Server (70-461) Certification

Exam Sample Questions and Correct Verified Answers

2024-2025. Graded A

  1. You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries. Which isolation level should you use? a) SERIALIZABLE b) SNAPSHOT c) READ COMMITTED SNAPSHOT d) REPEATABLE READ
  • ANSAnswer: c) READ COMMITTED SNAPSHOT
  1. How many clustered indexes can you create on a table? a) 999 b) 1 c) 16

d) 900

  • ANS Answer: b) 1
  1. What is the limit for the number of steps in statistic histograms? a) 10 steps per histogram b) 200 histograms per column c) 200 pages per histogram d) 200 steps per histogram
  • ANS Answer: d) 200 steps per histogram
  1. Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. There is a nonclustered index on the PurchaseTime column. The business team wants a report that displays the total number of purchases made on the current day. You need to write a query that will return the correct results in the most efficient manner. Which Transact-SQL query should you use? a) SELECT COUNT(*) FROM Purchases WHERE PurchaseTime = CONVERT(DATE, GETDATE())

b) SELECT COUNT() FROM Purchases WHERE PurchaseTime = GETDATE() c) SELECT COUNT() FROM Purchases WHERE CONVERT(VARCHAR, PurchaseTime,

  1. = CONVERT(VARCHAR, GETDATE(), 112) d) SELECT COUNT(*) FROM Purchases WHERE PurchaseTime >= CONVERT(DATE, GETDATE()) AND PurchaseTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))
  • ANS Answer: d) SELECT COUNT(*) FROM Purchases WHERE PurchaseTime >= CONVERT(DATE, GETDATE()) AND PurchaseTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))
  1. You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements:
  • Takes an input parameter
  • Returns a table of values
  • Can be referenced within a view Which object should you use? a) inline table-valued function b) user-defined data type c) stored procedure d) scalar-valued function
  • ANS Answer: a) inline table-valued function

70-461 Study Guide and How to Crack Exam on 2012/2014? Click Here... - ANShttps://70-461-study-guide.tumblr.com/ Study Guide for Querying Microsoft SQL Server 2012/2014 70-461 Certification Click Here... - ANShttps://microsoft-exam-guide.blogspot.com/2020/08/study- guide-for-querying-microsoft-sql.html