Pass4sure 1D0-441 Dumps and Practice Tests with Real Questions

CIW

1D0-441 CIW Database Specialist

http://killexams.com/exam-detail/1D0-441

QUESTION: 154

Which of the following definitions best describes an atomic value?

A. B. C. D.

A relation value processed in a single atomic action A tuple value that can be subdivided into multiple pieces of information An attribute value that can be decomposed into multiple pieces of information An attribute value that cannot be subdivided into multiple pieces of information

Answer: D

QUESTION: 155 Which mechanism provides database users with controlled access to the database through the use of virtual tables?

A. B. C. D.

View Data dictionary Database control language Database management system

Answer: A

QUESTION: 156

Which statement best describes the use of prepared statements with JDBC?

A. Prepared statements can only be used by the client that created them.

B. If the DBMS does not support prepared statements, your code will fail if it attempts to use the prepared-statement feature of JDBC. C. Prepared statements can only be used to query the database.

D. A Prepared statements can only be used to perform updates on the database.

Answer: A

QUESTION: 157 Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

90

A. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID B. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT C. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING Foreign Key BUILDING(Building_ID) references RESIDENT(Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT D. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID Foreign Key Building_ID references BUILDING(Building_ID)

Answer: D

QUESTION: 158

Which method of the SQLException class returns an X/OPEN SQLState error code?

A. B. C. D.

getMessage getSQLState getErrorCode getNextException

Answer: B

QUESTION: 159

91

Which of the following statements is true of JDBC URLs?

A. The jdbc:subprotocol:subname form of a JDBC URL is prescribed by the JDBC specification and strictly followed by all JDBC drivers.

B. A JDBC URL specifies the location of both a database and a driver that will be used to connect to that database.

C. JDBC URLs are parsed by a driver manager.

D. The JDBC URL specifies the location of a database, but includes no driver-specific information.

Answer: B

QUESTION: 160

Which of the following best defines a database?

A. B. C. D.

Data stored as tables Software that manages data Data that is stored in a structured manner Data records that are stored sequentially in a file

Answer: C

QUESTION: 161

What is the highest normal form of the relation(s) shown in the exhibit?

92

A. B. C. D.

Second normal form First normal form Boyce-Codd normal form Third normal form

Answer: A

QUESTION: 162

Consider the following code fragment:

1. Statement s = conn.createStatement(); 2.

3. s.executeUpdate(CREATE TABLE MyTable ( + 4.

ColumnA CHAR(5), + 5.

ColumnB CHAR(5))); 6.

7. s.executeUpdate(INSERT INTO MyTable VALUES ( + 8.

'00001', 'AAAAA'); 9. s.executeUpdate(INSERT INTO MyTable VALUES ( + 10.

'00002', 'AAAAA'); 11.

12. ResultSet rs = s.executeQuery(SELECT * FROM MyTable + 13.

WHERE ColumnB = 'AAAAA'); 14. while(rs.next())

93

15. System.out.println(rs.getString(1));

Assume that variable conn references a valid and open Connection object, and that the database

does not already contain a table named MyTable. Which output is generated?

A. 00001

AAAAA B. AAAAA C. 00001 00002 D. 1 2

Answer: C

94

For More exams visit https://killexams.com/vendors-exam-list

Kill your exam at First Attempt....Guaranteed!