You are a database developer on an instance of SQL Server 2008. You have a partitioned table named TransAudit that contains historical audit records. Older audit records are rarely accessed. The TransAudit table is partitioned as follows: You want to…

You manage a database, Prod, on an instance of SQL Server 2008. You have a partitioned table, TransDetails, which was defined using the following Transact-SQL: CREATE PARTITION FUNCTION PFunction1 (int)AS RANGE LEFT FOR VALUES (2000, 3000); CREATE PARTITION SCHEME PScheme1…

You are a database developer on an instance of SQL Server. You executed the following statements to create the Policies and PolicyHolders tables: CREATE TABLE PolicyHolders ( PolicyHolderID int IDENTITY(1,1) PRIMARY KEY, LastName varchar(35) NOT NULL, FirstName varchar(35) NOT NULL…

You work in an International company named TAKEEEN. And you’re in charge of the database of your company. There’s a SQL Server 2008 database named TaskDB. A task management application which contains a module named Task is created to connect…

You intend to use SQL Server 2008 to create a database solution. There’s a large table in the database. The table is updated not very often. A query is executed against the table by users. The execution of a complex…

You are a database developer on an instance of SQL Server 2008. You are developing a Transact-SQL script that will be used by developers. The script uses multiple DML statements, but does not use transactions. You want to ensure that…

You are a database developer on an instance of SQL Server 2008. You have a Prod database that contains all inventory-related data for your company. Your InvTransaction table is defined as follows: You have a Transact-SQL script that is performing…

You are a database developer on an instance of SQL Server 2008. You created the TestDetails table using the following CREATE TABLE statement: CREATE TABLE TestDetails ( TestID int IDENTITY(1,1) PRIMARY KEY, TestName nvarchar(10) NULL UNIQUE, TestType char(1) CHECK (TestType…

You are a database developer on an instance of SQL Server 2008. Your Product table is defined as follows: Your company sells two types of products identified by the ProductType column: physical and virtual. Physical products are stored in inventory…

You are a developer on an instance of SQL Server 2008. You are designing an Event table. The EventDate column must contain a value. In addition, for each event, the EventDate must be a date between the StartDate and EndDate.…