Home Page > CIW > 1D0-441

Download CIW.ExamGoal.1D0-441.v2011-06-04.by.Jake.163q.vce

Exam: CIW Database Specialist
Size: 1.69 MB
Posted: 2011-06-04
Votes: 0
Download: CIW.ExamGoal.1D0-441.v2011-06-04.by.Jake.163q.vce

Vote For This File

Verification:*
Type the characters from the picture.

Comments

* The most recent comments are at the top.

    • 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 Q102
      Which 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.

      Q98
      Answer 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_Name
      FROM Employee;
      WHERE ID = '0004';
      C. SELECT *
      FROM Employee;
      WHERE Dept_ID = 022;
      D. SELECT *
      FROM Employee
      WHERE 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 reworded
      A. 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. Polling
      B. Locking
      C. Blocking
      D. 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 WHERE
      Student__ID = 1003 AND Activity = 'Swimming';

      I still chose C.

      Q37
      3 answers were similar to answer D

      The difference was in the wording of the last line
      Room_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.

Close

Site Search:

Site Search:

Terms of Service

Proudly powered by www.iexamcollection.com