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

You create a disk-based table that contains the following script:

You need to prevent duplicate values in the SKU field.
Which five code segments should you use?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

정답:

Explanation:
Note: The SQL command is:
ALTER TABLE <tablename> ADD CONSTRAINT
<constraintname> UNIQUE
(
<columnname>
)

You have a text file that contains an XML Schema Definition (XSD).
You have a table named Schema1.Table1.
You have a stored procedure named Schema1.Proc1 that accepts an XML parameter named Param1.
You need to store validated XML data in Schema1.Table1. The solution must ensure that only valid XML data is accepted by Param1.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.use the modify method to insert the XML schema into each row of the XML column in Table1.
  Explanation/Reference:
  http://msdn.microsoft.com/en-us/library/bb510420.aspx
  http://msdn.microsoft.com/en-us/library/ms187856.aspx
  http://msdn.microsoft.com/en-us/library/ms176009.aspx
  http://msdn.microsoft.com/en-us/library/hh403385.aspx
  http://msdn.microsoft.com/en-us/library/ms184277.aspx
• B.Create an XML schema collection in the database from the text file.
• C.Declare Param1 var1 as type XML and associate the variable to the XML schema collection.
• D.Define an XML column in Table1 by using an XML schema collection.

You need to resolve the performance issues of the usp_getOpenings stored procedure.
Which three actions should you perform? Each correct answer presents part of the solution.

• A.Replace lines 12, 13, and 14 with the Transact SQL Segment:
  WHERE (Contains(o.Description, 'FORMSOF(INFLECTIONAL, '+@keyword+')'))
• B.Replace lines 12, 13, and 14 with the Transact_SQL segment:
  WHERE (CONTAINS(o.Description, @keyword))
• C.Create a full text index on the Description column
• D.Delete lines 05 through 08
• E.Replace lines 12, 13, and 14 with the Transact-SQL segment:
  WHERE (CONTAINS(o.Description, 'ISABOUT(' +@keyword+' weight (.5))'))

You have a table named ORDERS that contains 10,514,003 Orders. The ORDERS table has an IDENTITY(1,1) column named ORDER_ID. ORDER_ID is the UNIQUE CLUSTERED INDEX and PRIMARY KEY for the table. The first ORDER_ID is 1. There are no missing ORDER_IDs in the set.
Based on table usage patterns, you decide to use partitioning on this table based off of the ORDER_ID column.
You need to create the following partitions:

Which Transact-SQL statement should you run?

• A.CREATE PARTITION FUNCTION pfOrderIDRange (int)
  AS RANGE LEFT FOR VALUES (7500000,10000000)
• B.CREATE PARTITION FUNCTION pfOrderIDRange (int)
  AS RANGE LEFT FOR VALUES (0,7500000,10000000)
• C.CREATE PARTITION FUNCTION pfOrderIDRange (int)
  AS RANGE RIGHT FOR VALUES (7500000,10000000)
• D.CREATE PARTITION FUNCTION pfOrderIDRange (int)
  AS RANGE RIGHT FOR VALUES (0,7500000,10000000)

You plan to modify a stored procedure to use temporary data.
The stored procedure must meet the following requirements:
Favor physical memory when physical memory is available.
Be able to roll back changes to the temporary data.
You need to recommend which object to add to the stored procedure.
Which T-SQL command should you recommend?

• A.CREATE TABLE Table...
• B.CREATE PARTITION SCHEME Table...
• C.CREATE VIEW Table...
• D.CREATE TABLE ##Table...
• E.DECLARE TABLE @ Table...