Errata

The question below has 2 "correct" answers, but neither is actually correct for different reasons:
1. The "INSERT INTO... " clause ends in a comma:
--> INSERT INTO Hovercraft.Testing (Notes, HullID, TestDate, Registration,) VALUES (N'Hovercraft requires maintenance.', 142, '20120715', N'AAA320')
and
2. The apostrophe is not escaped in "six months' time'".
--> INSERT INTO Hovercraft.Testing (HullID, TestDate, Registration, Notes) VALUES (124, '20120722', N'AAA321', N'Hovercraft in good condition. Next service in six months' time')
---------------------------------------------------------------------------------------
The Question:

You are adding tables to the Hovercraft database. You create a table by using the following statement:

Create Table Hovercraft.Testing
(
TestIdentifier uniqueidentifier DEFAULT NEWSEQUENTIALID() PRIMARY KEY,
HullId tinyint NOT NULL,
TestDate date NOT NULL,
Registration nvarchar(8) NOT NULL,
Notes nvarchar(max)
)

Which of the following statements can you use to insert data into this table? (Each correct answer presents a complete solution. Choose two.)

Can not install sample exams on Windows 8 machine. Receive the following message when attempting.

MDAC 2.6 Sp2 cannot be installed on this machine. MDAC 2.6 Sp2 requires any one of the following configurations.

LIST OF EVERYTING BUT WINDOWS 8

Note from the Author or Editor:
Hi Arthur,

This is Itzik, the lead author of the book. Me and my team of authors were not involved in writing the practice test or preparing the practice test tool, we wrote the training kit itself. But I just wanted to let you know that I just tried to install the practice test on my Windows 8 machine and it installed fine.
What I suggest is that you try downloading the latest version of the CD Content (available in the oreilly.com website under Your Products section), and try installing again.
In the meanwhile, I'll contact the editors at O'Reilly and see if someone can get in touch with you to troubleshoot the specific errors you're getting.

Cheers,
Itzik

The question 10/ 60 for data modifications has no correct answer. all answers are wrong becuase of the identity columns

You create the Hovercraft.OrdersAPAC table by using the following statement:

CREATE TABLE Hovercraft.OrdersAPAC
(
orderid INT NOT NULL IDENTITY(1, 1)
CONSTRAINT PK_Orders_orderid PRIMARY KEY,
custid INT NOT NULL,
empid INT NOT NULL,
orderdate DATE NOT NULL
CONSTRAINT DFX_MyOrders_orderdate DEFAULT (CAST(SYSDATETIME() AS DATE)), shipcountry NVARCHAR(15) NOT NULL,
freight MONEY NOT NULL
);

The Hovercraft.Orders statement already exists and was created using the following statement:

CREATE TABLE Hovercraft.Orders
(
orderid INT NOT NULL IDENTITY(1, 1)
CONSTRAINT PK_Orders_orderid PRIMARY KEY,
custid INT NOT NULL,
empid INT NOT NULL,
orderdate DATE NOT NULL
CONSTRAINT DFZ_MyOrders_orderdate DEFAULT (CAST(SYSDATETIME() AS DATE)), shipcountry NVARCHAR(15) NOT NULL,
freight MONEY NOT NULL
);

You want to populate the Hovercraft.OrdersAPAC table with all the order data from the Hovercraft.Orders table related to countries in the Asia/Pacific region such as Australia and New Zealand.

Which of the following statements can you use to accomplish this goal of inserting order data where Australia is the ship country? (Each correct answer presents a complete solution. Choose two.)

The line that states "The actual execution is performed by the storage engine." is wrong.

I believe it should be something like
"The actual execution is performed by the Execution Engine which is a component of the Relational Engine."

Source:
http://technet.microsoft.com/en-us/library/aa175248%28v=sql.80%29.aspx

https://www.simple-talk.com/sql/sql-training/the-sql-server-query-optimizer/