Microsoft Exam
You need to create a module that performs the following tasks:
*Accepts an order number
*Sets the value of the Status column in the Orders table for that order number to Shipped
*Retrieves a tracking number to the Shipping table
*Returns the number of items shipped and the customer's e-mail address
What should you create? - correct answer ✔✔Stored procedure
Using a stored procedure: - correct answer ✔✔improves performance because parsing is not required
with each execution.
An inline table-valued function: - correct answer ✔✔includes only a single SELECT statement.
You can retrieve data sorted by the LastName column by using a: - correct answer ✔✔SELECT statement
with a GROUP BY clause.
Which statement shows a valid use of the CREATE VIEW statement? - correct answer ✔✔CREATE VIEW
TopStudents AS
SELECT TOP 10 FirstName, LastName, Grade
FROM Grades
ORDER BY Grades
You execute the following query:
SELECT LoanNumber, OriginalLoanAmt, InterestRate
FROM Loan
You need to create a module that performs the following tasks:
*Accepts an order number
*Sets the value of the Status column in the Orders table for that order number to Shipped
*Retrieves a tracking number to the Shipping table
*Returns the number of items shipped and the customer's e-mail address
What should you create? - correct answer ✔✔Stored procedure
Using a stored procedure: - correct answer ✔✔improves performance because parsing is not required
with each execution.
An inline table-valued function: - correct answer ✔✔includes only a single SELECT statement.
You can retrieve data sorted by the LastName column by using a: - correct answer ✔✔SELECT statement
with a GROUP BY clause.
Which statement shows a valid use of the CREATE VIEW statement? - correct answer ✔✔CREATE VIEW
TopStudents AS
SELECT TOP 10 FirstName, LastName, Grade
FROM Grades
ORDER BY Grades
You execute the following query:
SELECT LoanNumber, OriginalLoanAmt, InterestRate
FROM Loan
