Online Access Free 70-461 Practice Test

You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?

• A.Money
• B.Decimal
• C.Small money
• D.Real

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders.
The tables are related by a column named CustomerID.
You need to create a query that meets the following requirements:
* Returns the CustomerName for all customers and the OrderDate for any orders that they have placed.
* Results must include customers who have not placed any orders.
Which Transact-SQL query should you use?

• A.SELECT CustomerName, OrderDate
  FROM Customers
  RIGHT OUTER JOIN Orders
  ON Customers.CustomerID = Orders.CustomerID
• B.SELECT CustomerName, OrderDate
  FROM Customers
  LEFT OUTER JOIN Orders
  ON Customers.CustomerID = Orders.CustomerID
• C.SELECT CustomerName, OrderDate
  FROM Customers
  CROSS JOIN Orders
  ON Customers.CustomerID = Orders.CustomerID
• D.SELECT CustomerName, OrderDate
  FROM Customers
  JOIN Orders
  ON Customers.CustomerID = Orders.CustomerID

You develop a stored procedure for a wholesale glass manufacturing company. The stored procedure uses a cursor to read all row-based combinations of the following tables:

You observe that the stored procedure returns results very slowly.
You need to improve the execution speed of the stored procedure.
Which cursor type should you use?

• A.LOCAL STATIC READ_ONLY FORWARD_ONLY
• B.GLOBAL STATIC
• C.LOCAL FAST_FORWARD
• D.GLOBAL FORWARD_ONLY

You have a SQL Server database that contains all of the sales data for your company.
You need to create a query to update the rows in a table. The solution must write original and updated values to a separate table.
Which clause should you add to the UPDATE statement in the query?

• A.ReadText
• B.OUTPUT
• C.INSERT
• D.WRITETEXT

You need to create a cursor that meets the following requirements:
Executes as quickly as possible.
Reflects all data changes made to the table while scrolling.
Which five Transact-SQL statements should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer are and arrange them in the correct order.

Correct Answer:

Explanation:
Step 1: Declare variables.
Step 2: Open the cursor
Step 3: Fetch the first instance.
Step 4: Loop
Step 5: Close and deallocate the cursor
References: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/declare-cursor-transact-sql?view=sql-server-2017