+ Reply to Thread
Results 1 to 2 of 2
  1. Junior Member
    Join Date
    May 2005

    Default Typos/Misinterpretations in 70-229 mock exam?

    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/m...database.shtml says:
    The 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.
    but the example actually says
    SIZE = 15MB,
    MAXSIZE = 30MB,
    Reply With Quote Quote  

  2. Senior Member
    Join Date
    May 2003


    Thanks for pointing out the typos. They'll be corrected asap. sorry for the trouble.

    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks