最新的Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 - 070-457免費考試真題

A. SELECT CustomerName, OrderDate FROM Customers JOIN Orders ON Customers.CustomerId = Orders.CustomerId

B. SELECT CustomerName, OrderDate FROM Customers RIGHT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerId

C. SELECT CustomerName, OrderDate FROM Customers LEFT OUTER JOIN Orders ON Customers.CuscomerlD = Orders.CustomerId

D. SELECT CustomerName, OrderDate FROM Customers CROSS JOIN Orders ON Customers.CustomerId = Orders.CustomerId

A. Float

B. Smallmoney

C. Numeric

D. Money

A. CREATE TABLE DocumentStore
(
[Id] hierarchyid,
[Document] NVARCHAR NOT NULL
)
GO

B. CREATE TABLE DocumentStore
(
[Id] INT NOT NULL PRIMARY KEY,
[Document] VARBINARY(MAX) NULL
)
GO

C. CREATE TABLE DocumentStore
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
[Document] VARBINARY(MAX) FILESTREAM NULL
)
GO

D. CREATE TABLE DocumentStore AS FileTable

A. Drop the UDF and rewrite the report query as follows:
SELECT c.CustomerName
FROM Sales.Customer c
WHERE NOT EXISTS (
SELECT s.OrderDate
FROM Sales.SalesOrder
WHERE s.OrderDate > DATEADD(DAY, -90, GETDATE())
AND s.CustomerID = c.CustomerID)

B. Drop the UDF and rewrite the report query as follows:
SELECT DISTINCT c.CustomerName
FROM Sales.Customer c
INNER JOIN Sales.SalesOrder s
ON c.CustomerID = s.CustomerID
WHERE s.OrderDate < DATEADD(DAY, -90, GETDATE())

C. Drop the UDF and rewrite the report query as follows:
WITH cte(CustomerID, LastOrderDate) AS ( SELECT CustomerID, MAX(OrderDate) AS [LastOrderDate] FROM Sales.SalesOrder GROUP BY CustomerID
)
SELECT c.CustomerName
FROM cte
INNER JOIN Sales.Customer c
ON cte.CustomerID = c.CustomerID
WHERE cte.LastOrderDate < DATEADD(DAY, -90, GETDATE())

D. Rewrite the report query as follows:
SELECT c.CustomerName
FROM Sales.Customer c
WHERE NOT EXISTS (SELECT OrderDate FROM Sales.ufnGetRecentOrders(c.
CustomerID, 90))
Rewrite the UDF as follows:
CREATE FUNCTION Sales.ufnGetRecentOrders(@CustomerID int, @MaxAge datetime)
RETURNS TABLE AS RETURN (
SELECT OrderDate
FROM Sales.SalesOrder
WHERE s.CustomerID = @CustomerID
AND s.OrderDate > DATEADD(DAY, -@MaxAge, GETDATE())

A. SELECT CustomerName, OrderDate FROM Customers LEFT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

B. SELECT CustomerName, OrderDate FROM Customers RIGHT 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, CrderDate FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID

A. Use the TODATETIMEOFFSET function.

B. Use the DATETIME2 data type.

C. Use the FORMAT function.

D. Use the DATETIME data type.

E. Use the VARBINARY data type.

F. Use the CAST function.

G. Use the DATE data type.

H. Use the DATETIMEOFFSET data type.

I. Use an appropriate collation.

J. Use a user-defined table type.

A. RESTART

B. STANDBY

C. FULL

D. CONTINUE_AFTER_ERROR

E. Differential

F. SIMPLE

G. SKIP

H. DBO_ONLY

I. NO_CHECKSUM

J. COPY_ONLY

K. NORECOVERY

L. BULK_LOGGED

M. CHECKSUM

N. Transaction log

A. REVOKE SELECT ON Schema::Customers FROM UserA

B. DENY SELECT ON Schema::Customers FROM UserA

C. EXEC sp_addrolemember 'Sales', 'UserA'

D. REVOKE SELECT ON Object::Regions FROM Sales

E. REVOKE SELECT ON Schema::Customers FROM Sales

F. REVOKE SELECT ON Object::Regions FROM UserA

G. DENY SELECT ON Schema::Customers FROM Sales

H. EXEC sp_droprolemember 'Sales', 'UserA'

I. DENY SELECT ON Object::Regions FROM Sales

J. DENY SELECT ON Object::Regions FROM UserA

A. Restart the SQL Server Agent Service.

B. Execute the following Transact-SQL command: sp_configure 'remote admin connections',

C. Enable inbound connections on TCP port 135 in the Windows Firewall on the server.

D. Execute the following Transact-SQL command: sp_configure 'remote access', 1

E. Execute the Reconfigure command.

F. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server.