Microsoft 070-761 資格準備の問題集のサンプルを参考しよう
NO.1 DRAG DROP
You need to create a stored procedure that meets the following requirements:
- Produces a warning if the credit limit parameter is greater than 7,000
- Propagates all unexpected errors to the calling process
How should you complete the Transact-SQL statement? To answer, drag the appropriate
Transact-SQP segments to the correct locations. Each Transact-SQL segments may be used once,
more than once, or not at all. You may need to drag the split bar between panes or scroll to view
content.
Answer:
Explanation:
Box 1: THROW 51000, 'Warning: Credit limit is over 7,000!",1
THROW raises an exception and transfers execution to a CATCH block of a TRY...CATCH construct in
SQL Server.
THROW syntax:
THROW [ { error_number | @local_variable },
{ message | @local_variable },
{ state | @local_variable } ]
[ ; ]
Box 2: RAISERROR (@ErrorMessage, 16,1)
RAISERROR generates an error message and initiates error processing for the session.
RAISERROR can either reference a user-defined message stored in the sys.messages catalog view or
build a message dynamically. The message is returned as a server error message to the calling
application or to an associated CATCH block of a TRY...CATCH construct. New applications should use
THROW instead.
Severity levels from 0 through 18 can be specified by any user. Severity levels from 19 through 25 can
only be specified by members of the sysadmin fixed server role or users with ALTER TRACE
permissions. For severity levels from 19 through 25, the WITH LOG option is required.
On Severity level 16. Using THROW to raise an exception
The following example shows how to use the THROW statement to raise an exception.
Transact-SQL
THROW 51000, 'The record does not exist.', 1;
Here is the result set.
Msg 51000, Level 16, State 1, Line 1
The record does not exist.
Note: RAISERROR syntax:
RAISERROR ( { msg_id | msg_str | @local_variable }
{ ,severity ,state }
[ ,argument [ ,...n ] ] )
[ WITH option [ ,...n ] ]
Note: The ERROR_MESSAGE function returns the message text of the error that caused the CATCH
block of a TRY...CATCH construct to be run.
References:
https://msdn.microsoft.com/en-us/library/ms178592.aspx
https://msdn.microsoft.com/en-us/library/ms190358.aspx
https://msdn.microsoft.com/en-us/library/ee677615.aspx
NO.2 Note: This question is part of a series of questions that use the same or similar answer choices.
An answer choice may be correct for more than one question in the series. Each question is
independent of the other questions in this series. Information and details provided in a question
apply only to that question.
You have a database that stores sales and order information.
Users must be able to extract information from the tables on an ad hoc basis. They must also be able
to reference the extracted information as a single table.
You need to implement a solution that allows users to retrieve the data required, based on variables
defined at the time of the query.
What should you implement?
A. the ISNULL function
B. a scalar function
C. the COALESCE function
D. a stored procedure
E. a table-valued function
F. the TRY_CONVERT function
G. the TRY_PARSE function
H. a view
Answer: E
070-761 入門
Explanation:
User-defined functions that return a table data type can be powerful alternatives to views.
These functions are referred to as table-valued functions. A table-valued user-defined function can
be used where table or view expressions are allowed in Transact-SQL queries. While views are limited
to a single SELECT statement, user-defined functions can contain additional statements that allow
more powerful logic than is possible in views.
A table-valued user-defined function can also replace stored procedures that return a single result
set.
References: https://technet.microsoft.com/en-us/library/ms191165(v=sql.105).aspx
NO.3 Note: This question is part of a series of questions that use the same or similar answer choices.
An answer choice may be correct for more than one question in the series. Each question is
independent of the other questions in this series. Information and details provided in a question
apply only to that question.
You have a database that contains tables named Customer_CRMSystem and
Customer_HRSystem. Both tables use the following structure:
The tables include the following records:
Customer_CRMSystem
Customer_HRSystem
Records that contain null values for CustomerCode can be uniquely identified by
CustomerName.
You need to display a Cartesian product, combining both tables.
Which Transact-SQL statement should you run?
A. Option E
B. Option B
C. Option G
D. Option H
E. Option F
F. Option D
G. Option C
H. Option A
Answer: C
070-761 受験期 070-761 本番
Explanation:
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved
in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied
by the number of rows in the second table.
References: https://technet.microsoft.com/en-us/library/ms190690(v=sql.105).aspx
NO.4 You have a database that includes the tables shown in the exhibit. (Click the exhibit button.)
You need to create a list of all customers, the order ID for the last order that the customer placed,
and the date that the order was placed. For customers who have not placed orders, you must
substitute a zero for the order ID and 01/01/1990 for the date.
Which Transact-SQL statement should you run?
A. Option D
B. Option C
C. Option A
D. Option B
Answer: C
070-761 訓練
Explanation:
ISNULL Syntax: ISNULL ( check_expression , replacement_value ) author:"Luxemburg, Rosa"
The ISNULL function replaces NULL with the specified replacement value. The value of
check_expression is returned if it is not NULL; otherwise, replacement_value is returned after it is
implicitly converted to the type of check_expression.
References: https://msdn.microsoft.com/en-us/library/ms184325.aspx
JapanCertの070-761 資格準備はあなたの一発合格を保証できる資料です。問題集の的中率はとても高いですから、この問題集だけで試験に合格することができます。信じられなら利用してみてください。不合格になればJapanCertは全額返金のことができますから、絶対損にならないです。利用したら070-761 資格準備の品質がわかるようになるので、まず問題集の無料なサンプルを試しましょう。問題集のdemoが無料で提供されますから、JapanCertのサイトをクリックしてダウンロードしてください。
070-761 資格準備の品質を確かめ、この問題集はあなたに合うかどうかを確認することができるように、JapanCertは070-761 資格準備の一部のダウンロードを無料で提供します。二つのバージョンのどちらでもダウンロードできますから、JapanCertのサイトで検索してダウンロードすることができます。体験してから購入するかどうかを決めてください。そうすると、070-761 資格準備の品質を知らないままに問題集を購入してから後悔になることを避けることができます。
JapanCertは最新の70-480問題集と高品質の70-767問題と回答を提供します。JapanCertの1V0-621 VCEテストエンジンと400-251試験ガイドはあなたが一回で試験に合格するのを助けることができます。高品質の070-764 PDFトレーニング教材は、あなたがより迅速かつ簡単に試験に合格することを100％保証します。試験に合格して認証資格を取るのはそのような簡単なことです。
記事のリンク：http://www.japancert.com/070-761.html
