Typos/Misinterpretations in 70-229 mock exam?
CroMagnon
Member Posts: 1 ■□□□□□□□□□
I hope these numbers are unique - I'd hate to have to copy and paste the entire questions 
These are the numbers in brackets that appear when reviewing the questions I got wrong... I'll add a brief description in case that's an objective number or something.
(1.3) Airline DB designers want to add a passport field to a reservations table.
The question says they want to add it so they can re-use the passport number for future reservations, and goes on to mention they should be unique. A passport column is of no use in a reservations table if it is unique! No passenger would be allowed to make a new reservation with the same passport number. The answer says "UNIQUE" constraint, but I say it should be a foreign key, with passports stored uniquely in a customer table or something instead. I think the question may just need re-wording, or I am missing something obvious (more likely
)
(2.1) Question about SQL syntax for creating a database and a log file... the question says GB, but the answer is given in MB. I chose the wrong answer, and I realise I was wrong because "gigabyte" is not correct syntax, but unless specifying 10MB results in a 10GB file, the answer is incorrect I'm sure this is just a typo.
Also, the text at this link http://www.techexams.net/technotes/mcdba/physicaldatabase.shtml says:
These are the numbers in brackets that appear when reviewing the questions I got wrong... I'll add a brief description in case that's an objective number or something.(1.3) Airline DB designers want to add a passport field to a reservations table.
The question says they want to add it so they can re-use the passport number for future reservations, and goes on to mention they should be unique. A passport column is of no use in a reservations table if it is unique! No passenger would be allowed to make a new reservation with the same passport number. The answer says "UNIQUE" constraint, but I say it should be a foreign key, with passports stored uniquely in a customer table or something instead. I think the question may just need re-wording, or I am missing something obvious (more likely
)(2.1) Question about SQL syntax for creating a database and a log file... the question says GB, but the answer is given in MB. I chose the wrong answer, and I realise I was wrong because "gigabyte" is not correct syntax, but unless specifying 10MB results in a 10GB file, the answer is incorrect
I'm sure this is just a typo.Also, the text at this link http://www.techexams.net/technotes/mcdba/physicaldatabase.shtml says:
but the example actually saysThe following is a step-by-step guide in creating the Sales Database with a SIZE of 50MB, a MAXSIZE of 200MB, and a FILEGROWTH of 10MB.
SIZE = 15MB,
MAXSIZE = 30MB,
FILEGROWTH = 5MB
Comments
-
2lazybutsmart
Member Posts: 1,119
CoMagnon,
Thanks for pointing out the typos. They'll be corrected asap. sorry for the trouble.
2lbs.Exquisite as a lily, illustrious as a full moon,
Magnanimous as the ocean, persistent as time.