Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam : CIW 1D0-441
Title
: CIW DATABASE
SPECIALIST
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. A foreign key maps to a:
A. prime key.
B. indirect key.
C. parent key.
D. composite key.
Answer: C
2. Consider the relation shown in the exhibit. Which of the following SQL statements would properly add
information for a new employee?
A. INSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);
B. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0004, Tim, Bogart, 03-15-77);
C. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);
D. INSERT INTO Employee (Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES (0005, Tim, Bogart, 03-05-77);
Answer: D
3. Which pair of relational algebraic operations requires union compatibility?
A. Union and join
B. Selection and projection
C. Intersection and difference
D. Cartesian product and intersection
Answer: C
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
4. Which static member of the ResultSet class should be used to create an updatable result set?
A. ResultSet.TYPE_FORWARD_ONLY
B. ResultSet.TYPE_FORWARD_UPDATABLE
C. ResultSet.TYPE_SCROLL_INSENSITIVE
D. ResultSet.TYPE_SCROLL_SENSITIVE
Answer: D
5. Which method of the Statement interface could be used to delete data from a database?
A. executeUpdate
B. executeQuery
C. close
D. clearBatch
Answer: A
6. Which JDBC interface is used to extract information about the database schema?
A. ResultSet
B. Connection
C. DatabaseMetaData
D. ResultSetMetaData
Answer: C
7. Which of the following statements is true of the Connection interface?
A. Each JDBC client application must provide a class that implements the Connection interface.
B. Each JDBC driver provides a class that implements the Connection interface.
C. Each JVM provides a class that implements th