Tag: 70-433 MCTS

EnsurepassQUESTION 141 You have a table named Sales.SalesOrderHeader and a table named Person.Person. You are tasked to write a query that returns SalesOrderID and SalesPersonName that have an OrderDate greater than 20040101. SalesPersonName should be made up by concatenating the columns named FirstName and LastName from the table named Person.Person. You need to write a query to return data, sorted in alphabetical order, by the concatenation of FirstName and LastName. Which Transact-SQL statement Read more [...]

EnsurepassQUESTION 131 You are the administrator of a SQL Server database. Database table modifications and additions must occur only between 11:00 P.M. and midnight. You need to ensure that if database table modifications or additions are attempted at any other time, an error is raised and the attempt is not successful. Which Transact-SQL statement should you use? A. CREATE TRIGGER TRG_TABLES_ON_LAST_HOUR ON ALL SERVER FOR ALTER_DATABASE AS IF DATEPART(hour,getdate())<>1 BEGIN ROLLBACK Read more [...]

EnsurepassQUESTION 121 You administer a Microsoft SQL Server 2008 database named AdventureWork that contains a table named Production.Product. The table has the following definition: CREATE TABLE [Production].[Product]( [ProductID] [int] IDENTITY(1,1) NOT NULL, [ProductName] [nvarchar](50) NOT NULL, [ListPrice] [money] NOT NULL, [ProductionDate] [datetime] NULL, [UserCreated] [nvarchar](128) NOT NULL, [DateCreated] [datetime] NOT NULL DEFAULT GETDATE(), CONSTRAINT [PK_Product_ProductID] PRIMARY Read more [...]

EnsurepassQUESTION 111 You have a table named Stores that has an XML column named OpenHours. This column contains the opening and closing times. <hours dayofWeek="Monday" open="8:00" closed="18:00" /> <hours dayofWeek="Tuesday" open="8:00" closed="18:00" /> ... <hours dayofWeek="Saturday" open="8:00" closed="18:00" /> You need to write a query that returns a list of stores and their opening Read more [...]

EnsurepassQUESTION 101 You have a database server that has four quad-core processors. This database server executes complex queries that are used to generate reports. You need to force a query to use only one processor core without affecting other queries. Which option should you use? A. OPTION (MAXDOP 4) B. OPTION (MAXDOP 0) C. OPTION (MAXDOP 16) D. OPTION (MAXDOP 1) Correct Answer: D QUESTION 102 You need to implement a common table expression (CTE). Which code segment should you Read more [...]

EnsurepassQUESTION 91 A table named Shirts includes an XML column named SizeAndColors that contains the sizes and colors of each shirt, as shown in the following code segment. <shirt size="XS" colors="Red" /><shirt size="S" colors="Red, Blue" />...<shirt size="XL" colors="Blue, Green" /> You need to return a list of shirt colors available in a specific size. Which code segment should you use? A. DECLARE @Size VARCHAR(10) Read more [...]