Microsoft Exam 70-761 Topic 3 Question 1 Discussion

Actual exam question for Microsoft's 70-761 exam

Question #: 1
Topic #: 3

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?

AOption A

BOption B

COption C

DOption D

Show Suggested Answer

Suggested Answer: A

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

by Celeste at May 03, 2022, 07:13 AM

Limited Time Offer

25%

Off

Get Premium 70-761 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!