bob from United States – 08 27 2013, 6:25 PM Report Spam Continued Q71 The question and answer were somewhat reversed. It looked more like this:Q Which statement best describes a primary key?A Made up of one or more candidates. New question – kinda a reverse of Q102Which of the following describes a relation? Don't remember what A was.B. 3 dimensional table consisting of rows, columns, and attributes.C. Are made up of entities, attributes, and relationships.D. 2 dimensional table consisting of rows and columns. I chose D. Q98Answer syntax's were slightly altered.'_02' instead of _02 and '%02' instead of %02 Q124 Syntax was changed. It looked like this: A. SELECT *FROM Employee;B. SELECT ID,Last_NameFROM Employee;WHERE ID = '0004';C. SELECT *FROM Employee;WHERE Dept_ID = 022;D. SELECT *FROM EmployeeWHERE Dept_ID = '022'; I chose D, but the answer in the dump is C. Someone please verify. New question -I also had one normal form question that was not on the dump. It had a cardinality of 3 and under the "employee start date" column there were multiple dates on 2 of the 3 employees. My answer was first normal form. bob from United States – 08 27 2013, 6:24 PM Report Spam Thanks to John Doe for his comment about Q44. Dump mostly verbatim including answer order. Saw a few new questions, and there were a couple reworded or reversed. Q3 was slightly rewordedA. A virtual table is a relation created as the result of data manipulation. It is not a permanent part of the database.B. It exists only in computer memory. It is used when multiple users access the same relation in a database I still chose A. Q7 Answer B looked like this:CREATE TABLE RESIDENT (R_ID INTEGER,Room_NumBINARY,Res_NameVARCHAR (20),Building_IDINTEGER NOT NULL,FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)); I still chose D. New question -Which of the following Concurrency Control methods processes transactions in chronological order then restarts any transactions where there are conflicts. A. PollingB. LockingC. BlockingD. Time Stamp I believe the answer is D, but someone please verify. Q34 Answer B looked more like this:UPDATE TABLE Recreation SET ACTIVITY = 'Tennis', Activity_Fee = 100 WHEREStudent__ID = 1003 AND Activity = 'Swimming'; I still chose C. Q373 answers were similar to answer D The difference was in the wording of the last lineRoom_Count > -1 Or Room_Count < 601));Room_Count > -1 And Room_Count < 601));Can't remember the other conjunction they used. I chose the answer with "And". John Doe from United States – 08 26 2013, 3:56 AM Report Spam I will be taking this test on Wednesday. I have noticed that there are a couple answers that are wrong. Such as Exam A, Q44 should be "C" not "D".So, I wouldn't just go off of what it tells you per say.Obviously "C" is the only one that meets the criteria of "not <1000 and Sales_Rep-No=210" M-T from United States – 08 22 2013, 2:21 PM Report Spam Took and passed the test. Still a valid dump. As noted, format issues are a bit off, but pay attention and you'll do just fine. Neo from United States – 08 21 2013, 6:23 PM Report Spam Dr. Rock did you take that exam recently or you know someone who took it? Thanks! Dr. Rock from United States – 08 02 2013, 8:25 PM Report Spam To answer all yes it is still very valid. maybe 2 or 3 new ones. Study, learn, take! Princess 2 from United States – 07 29 2013, 2:23 PM Report Spam Can someone update this thread. I sure if you have taken and pass the test there isnt much reason to stop by here. But need an update.. pleaseeeeeeeeeeee. Bob from United Kingdom – 06 25 2013, 5:14 PM Report Spam Lance how was this dump? Lance from United States – 06 22 2013, 5:46 PM Report Spam Hey Sam,Did you take the exam? If so how valid is this dump? Aside from the formatting issues that is. I'm taking this exam on Tuesday and spending this weekend cramming. It seems most of my studying has shown confusion around the 1/2/3nf concept. Sam from United States – 06 15 2013, 1:34 AM Report Spam Does anyone know if anyones working on a new dump for this? I'm currently going through and finished reading the material. I was planning on going through this as soon as I finished the studying but if this dump is this old I wonder if its still valid. Kyrik from United States – 05 01 2013, 2:28 PM Report Spam Passed today. The comments already mentioned are still true. Know when to put " " in your SQL statements. Best of luck everyone. Thank you all for your input. Alex from United States – 02 02 2013, 4:30 PM Report Spam Passed on 01 28th, 87%, dump is valid, but there were new questions in the exam, and some questions instead of showing algebraic options as answers, were showing the resulting relations. Good luck Jon from United States – 10 30 2012, 5:10 AM Report Spam Valid with as mentioned minor formatting problems Dan from United States – 10 23 2012, 5:41 PM Report Spam Passed today, 23 10ober 2012. Dump is good enough to pass but there are formatting issues.