I was taking a practice test for Microsoft Certification 70-461 and wanted to confirm if what I saw was an error (this is from the official Microsoft Press book, Ninth printing. I did not see this on existing errata).
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.)
The choices are:
INSERT INTO Hovercraft.Testing (Notes, HullID, TestDate, Registration,) VALUES (N'Hovercraft requires maintenance.', 142, '20120715', N'AAA320')
INSERT INTO Hovercraft.Testing (HullID, TestDate, Registration, Notes) VALUES (124, '20120722', N'AAA321', N'Hovercraft in good condition. Next service in six months' time')
INSERT INTO Hovercraft.Testing (HullID, TestDate, Registration, Notes) VALUES (247, '20120722', N'ABCD54321', N'Hovercraft in good condition. Next service in three months' time')
INSERT INTO Hovercraft.Testing (Notes, HullID, TestDate, Registration,) VALUES (N'Hovercraft requires maintenance.', 842, '20120709', N'AAB121')
The answer key claims the first two are correct. However, shouldn't the additional apostrophe in the word "months" cause an error in the statement?
I apologize in advance if this isn't the right forum to confirm this.