Exam Guide For 1D0-441 CIW Database Specialist 

• Credit Toward Certification
• Prerequisites
• Exam Information
• Skills Measured
• Exam Preparation Tools
• Exam Retake Policy
• Exam Retirement

CREDIT TOWARD CERTIFICATION

CIW Database Specialist 1D0-441 is a requirement for the following CIW certifications:

• CIW Certified Instructor - for those teaching CIW Database Specialist content.
• Master CIW Enterprise Developer.

CIW Associates who pass the CIW Database Specialist exam (or any other CIW job role series exam) also earn the following CIW certification:

• CIW Professional

PREREQUISITES

Candidates must complete the following prerequisites prior to sitting the CIW Database Specialist exam:

• CIW Certification Agreement. This simple on-line agreement only needs to be completed once, but is necessary for CIW Certification Central to ship CIW certificates (CIW Associate, CIW Professional or Master CIW certificates) to candidates who pass the required CIW certification exam(s).
• CIW Associate certificate. Passing the CIW Foundations exam 1D0-510 is required for those candidates seeking CIW Professional and Master CIW Enterprise Developer certification designation.
• It is recommended, but not required, that students seeking Master CIW Enterprise Developer status to take (and pass) the CIW Web Languages (JavaScript and Perl), CIW Application Developer, Sun/jCert Java Programmer, and CIW Object-Oriented Analysis and Design with UML exams prior to the CIW Database Specialist exam.

EXAM INFORMATION

Students who have taken CIW courses are encouraged to continue their studies and apply their new skills before attempting the 1D0-441 Database Specialist exam. Skills taught in the CIW Database Specialist courses are best reinforced with real-world experience.

The candidate is responsible for learning the content and earning a passing score on the CIW Database Specialist exam. Comments regarding course delivery should be referred to the training company that delivered the course.

Any 1D0-441 CIW Database Specialist exam taken on or after August 31, 2001 will be subject to the following:

• Each delivery of the exam will include a random selection of 54 items.
• The examination period will be 75 minutes.

Examination Version	Date Published	Exam Notes
CIW Database Specialist 1D0-441	August 31, 2001	This version is the first version of the Database Specialist exam.

To earn a passing score on the exam, candidates must:

• Correctly answer at least 41 of the 54 scored questions to achieve a total score of 75% or greater.

Each exam item offers four solutions or distracters where exam candidates select the best solution(s) for each item.

SKILLS MEASURED

A CIW Database Specialist plans and designs relational databases. This individual defines the structure of a database, employs entity relationship (ER) diagrams and normalization to optimize databases, builds database client applications, and performs database maintenance and security administration. Skills measured in the 1D0-441 exam include but are not limited to:

• Database management systems (DBMSs), and advantages and disadvantages of using a DBMS.
• Relational model terminology, relational tables and their characteristics.
• Database design life cycle and aspects of database planning.
• Relational database design methodology and phases of database design.
• Normalization processes and normal forms.
• Design issues related to logical and physical database design.
• Database definition languages.
• Structured Query Language (SQL) commands and syntax.
• Relational algebra and concepts related to relational algebra.
• JDBC API architecture and implementation of relational database management systems.
• Establishment of database connections.
• Table and query manipulation in a database using JDBC.
• SQL statement storage and execution.
• Prepared statements and stored procedures with database management systems.
• DBMS or database metadata.
• Scrollable and updatable result sets.
• Batch updates (a function of JDBC 2.0 that increases efficiency).
• Graphical database clients.

EXAM PREPARATION TOOLS

Official Curriculum

Instructor-Led Training

• CIW Database Design Methodology (30 hours)

Practice Exams

CIW does not endorse Web sites that list study guides or practice questions for CIW exams. All CIW examinations are copyrighted material. To maintain the security and value of our program, we reserve the right to decertify and/or prohibit from examinations any individuals who republish or distribute our copyrighted certification exam questions.

Third-Party Books, Web Sites, or Newsgroups

The following resources are provided as a supplement to your studies, and will reinforce the skills and concepts learned with CIW official Database Design Methodology course materials.

• Borland Software Corporation site. http://www.borland.com/.
• Connolly, Thomas, with Carolyn Begg and Anne Strachan. Database Systems. Harlow, England: Addison-Wesley, 1999.
• Date, C. J. An Introduction to Database Systems. Harlow, England: Addison-Wesley, 1999.
• Gruber, Martin. Mastering SQL. Alameda, CA: SYBEX, 2000.
• Hare, Keith. The SQL Standards Page, copyright 2001 JCC Consulting, Inc. http://www.jcc.com/SQLPages/jccs_sql.htm.
• Harrington, Jan. Relational Database Design. Chestnut Hill, MA: AP Professional, 1998.
• Intelligent Enterprise's Database Programming & Design Online. http://www.dbpd.com/homepage.shtml.
• "Introduction to Databases," Web Developer's Virtual Library site. http://www.wdvl.com/Authoring/DB/Intro/.
• JDBC - Database Access Articles, Java Developer Connection, copyright 2001 Sun Microsystems. http://developer.java.sun.com/developer/technicalArticles/Database/
• "JDBC Data Access API," Java Developer Connection, copyright 2001 Sun Microsystems. http://java.sun.com/products/jdbc/index.html.
• "SQL Interpreter and Tutorial with Live Practice Database," Internet.com online magazine, copyright 2001 INT Media Group. http://www.sqlcourse.com/intro.html.
• Taylor, Allen G. SQL For Dummies. Foster City, CA: IDG Books, 1997.
• TechTarget's SearchDatabase.com site. http://searchdatabase.techtarget.com/.
• Vepstas, Linas. Linux SQL Databases and Tools page. http://www.linas.org/linux/db.html.
• White, Seth, with Rick Cattell and Mark Hapner. JDBC API Tutorial and Reference, Second Edition: Universal Data Access for the Java 2 Platform. Reading, Mass: Addison Wesley Longman, Inc., 1999.

EXAM RETAKE POLICY

The CIW Exam Retake Policy outlines the conditions under which a candidate may retake a CIW exam. A waiting period between retakes of a single certification exam maintains the security of the exam and strengthens the value of the CIW certification. Each CIW exam is defined by a unique exam ID (e.g., IDO-510). A retake is any subsequent sitting of an exam with the same CIW exam ID by the same candidate at any authorized testing center.

In the event that a candidate passes a CIW exam, the candidate will not be allowed to retake that CIW exam. If the CIW exam objectives change, the exam ID changes to reflect the new exam version. Candidates who have passed an exam may sit a newer version of the exam that may have the same title but a different ID number.

In the event that a candidate fails a CIW exam on his or her first attempt, a 24-hour waiting period is required between the first and second sittings of that CIW exam. Candidates are required to wait for a period of no less than thirty (30) calendar days from the date of the previous sitting before any third or subsequent sitting of the same CIW exam.

Exams administered in any ways that do not comply with the CIW Exam Retake Policy shall be considered invalid and ineligible for a refund.

In the event that a candidate has violated this Exam Retake Policy, the candidate may be deemed ineligible to register for or schedule any CIW exam for a minimum period of twelve (12) months from the date of such determination.

In addition, any candidate determined to have violated the CIW Exam Retake Policy may be subject to any or all of the following:

• Denial of a specific CIW certification for a period of twelve (12) months from the date of such determination;
• Revocation of a specific CIW certification, if such certification had been previously granted to the candidate;
• Revocation of all CIW certifications previously granted to the candidate;
• Ineligibility to receive any CIW certification for a minimum of twelve (12) months from the date of such determination;
• Any other appropriate actions, including legal remedies, deemed necessary or appropriate to enforce the CIW Exam Retake Policy.

EXAM RETIREMENT

Exam 1D0-441 is scheduled to retire on October 31, 2008. It has been replaced by the CIW v5 Database Design Specialist exam (1D0-541).

COMMENTS

To make a comment or recommendation about CIW certification exams, please contact our CIW certification department.

© 2008 Prosoft Learning - A VCampus Company
CIW-certified.com | Find Training | CIW Store | Site Map | Privacy Policy | Contact Us |  RSS