70-461 試験問題を無料オンラインアクセス

You use Microsoft SQL Server 2012 to develop a database application.
You need to create an object that meets the following requirements:
* Takes an input variable
* Returns a table of values
* Cannot be referenced within a view
Which object should you use?

• A.User-defined data type
• B.Scalar-valued function
• C.Inline function
• D.Stored procedure

You administer a Microsoft SQL Server database named ContosoDb. ContosoDb contains a table named Suppliers and an indexed view named VWLocalSuppliers, both of which were created by using the following Transact-SQL statement:

You need to change the data type of the Code column in the Suppliers table to nvarchar(50).
Which four Transact-SQL segments 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 area and arrange them in the correct order.

正解：

You develop a database application. You create four tables. Each table stores different categories of products.
You create a Primary Key field on each table.
You need to ensure that the following requirements are met:
* The fields must use the minimum amount of space.
* The fields must be an incrementing series of values.
* The values must be unique among the four tables.
What should you do?

• A.Create a TIMESTAMP column.
• B.Create a SEQUENCE object that uses the INTEGER data type.
• C.Use the UNIQUEIDENTIFIER data type along with NEWSEQUENTIALID()
• D.Use the INTEGER data type along with IDENTITY
• E.Create a ROWVERSION column.

You need to create a query that calculates the total sales of each OrderID from a table named Sales.Details. The table contains two columns named OrderID and ExtendedAmount.
The solution must meet the following requirements:
* Use one-part names to reference columns.
* Start the order of the results from OrderID.
* NOT depend on the default schema of a user.
* Use an alias of TotalSales for the calculated ExtendedAmount.
* Display only the OrderID column and the calculated TotalSales column.
Provide the correct code in the answer area.

• A.SELECT
  OrderID,
  SUM(ExtendedAmount) AS TotalSales
  FROM Sales.Details
  GROUP BY OrderID
  ORDER BY OrderID
• B.SELECT
  OrderID,
  SUM(ExtendedAmount) AS TotalSales
  FROM Sales.Details
  GROUP
  ORDER BY OrderID

You develop a Microsoft SQL Server database that contains a two tables named OrdersHistorical and CompletedOrders.
Both tables have the same schema that has the following definition:

You write the following Transact-SQL statement:

You need to ensure that data that falls into the date range of the SELECT statement cannot be inserted into CompletedOrders while the INSERT statement is running. You also need to ensure that other operations are unaffected.
Which table hint should you use?

• A.ROWLOCK
• B.XLOCK
• C.HOLDLOCK
• D.TABLOCK
• E.UPDLOCK