The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Version |
Location |
Description |
Submitted by |
Date submitted |
ePub |
Page exam
Practice Exam |
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.)
|
Eric Bowen |
Apr 06, 2013 |
ePub |
Page `
1 |
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
|
Arthur Hill |
Sep 08, 2013 |
Printed |
Page training kit exam
question 461P_3.2_01 |
Hi, in the question 461P_3.2_01 there are incorrect answers. For the book are
1) INSERT INTO Hovercraft.Testing (Notes, HullID, TestDate, Registration,) VALUES (N'Hovercraft requires maintenance.', 142, '20120715', N'AAA320')
2) INSERT INTO Hovercraft.Testing (HullID, TestDate, Registration, Notes) VALUES (124, '20120722', N'AAA321', N'Hovercraft in good condition. Next service in six months' time')
but in the first answer there is ....Registration,) is incorrect comma
|
mattia |
Nov 27, 2013 |
Printed |
Page 1
N/A |
Error in the practice test: Question ID: 461P_3.2_08.
It says you want to decrease a discount by 0.5%, but the 'correct' answer is:
SET discount = -=.05 ....
This would decrease the discount by 5%, not 0.5%, as the discounts are stored as decimals:
.125 = 12.5%
-= .05 would make it .075 or 7.5%, when the intended result staged by the question should be .12 or 12%
|
Anonymous |
Jan 11, 2013 |
Printed |
Page 1
1 |
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.)
|
Hanna Takla |
Apr 09, 2013 |
Printed, PDF |
Page 243
2nd sentence in "FLWOR Expressions" section |
I must have read this sentence four times before I finally figured out what it was saying:
A FLWOR expression is actually a for each loop.
I couldn't figure out why for each loop the expresson would be "a" or how that made any sense.
There are better ways to express this using exactly the same words:
A FLWOR expression is actually a foreach loop.
A FLWOR expression is actually a for-each loop.
A FLWOR expression is actually a "for each" loop.
A FLWOR expression is actually a FOR EACH loop.
|
Gary Schroller |
Mar 07, 2014 |
Printed |
Page 284
Quick Check Answer #2 |
Quick Check Answer #2
Change: "No, all table constraints must have unique names withing the schema of a database."
To: "No, all table constraints must have unique names within the schema of a database."
|
Jackson Fabros |
Mar 14, 2014 |
Printed |
Page 520
Paperback - Chapter 14, Page 520 Paragraph 3, Line 2 |
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/
|
Suffy |
Feb 11, 2014 |