070-461 무료 덤프문제 온라인 액세스

You develop 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 not include customers who have not placed any orders.
Which Transact-SQL query should you use?

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

You are working with a table that has an XML column that contains information about books. Each book may have an associated price.
You need to write with a query that returns the price of each book as a non-xml value.
Which XML method should you use?

• A.Query()
• B.Value()
• C.Nodes()
• D.Exist()

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.GLOBAL FORWARD_ONLY
• B.GLOBAL STATIC
• C.LOCAL STATIC READ_ONLY FORWARD_ONLY
• D.LOCAL FAST_FORWARD

You have a SQL database that contains a table named Products.
You are implementing a stored procedure that retrieves the list of products, performs custom business logic and then retrieve the list of products again.
The custom business logic in the stored procedure does not modify data from the Products table.
The stored procedure contains the following:

You need to complete line 01 of the stored procedure to ensure that when the transaction occurs, the data read from the SELECT * FROM Products statement on line 05 is identical to the data read from the SELECT * FROM Products statement on line 10. The solution must maximize concurrency.
Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.


Use the Check Syntax button to verify your work. Any syntax or spelling errors will be reported by line and character position.

You are developing an SQL Server database. The database contains two tables and a function that are defined by the following Transact-SQL statements.

You need to create a query to determine the total number of products that are sold each day for the live top-selling products on that particular day.
How should you complete the relevant Transact-SQL script? To answer, select the appropriate Transact-SQL statements from each list in the answer area.

정답:

Explanation:
The APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query. T There are two forms of APPLY: CROSS APPLY and OUTER APPLY. CROSS APPLY returns only rows from the outer table that produce a result set from the table-valued function. OUTER APPLY returns both rows that produce a result set, and rows that do not, with NULL values in the columns produced by the table-valued function.
Reference:
https://technet.microsoft.com/en-us/library/ms175156(v=sql.105).aspx