AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-804





Question ID 3519

ITEM Table
* ID, INTEGER: PK
* DESCRIP, VARCHAR(100) * PRICE, REAL
* QUALITY, INTEGER
And given the code fragment (assuming that the SQL query is valid):
 
What is the result of compiling and executing this code?

Option A

A.    An exception is thrown at runtime
 

Option B

B.    Compile fails
 

Option C

C.    The code prints Error
 

Option D

D.    The code prints information about Item 110
 

Correct Answer C
Explanation


Question ID 3520

Which code fragment demonstrates the proper way to handle JDBC resources?
 

Option A

A.    try {
ResultSet rs = stmt.executeQuery (query); statement stmt = con.createStatement(); while (rs.next()) (/* . . . */)
} catch (SQLException e) {}
 

Option B

B.    try {
Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery (query); while (rs.next()) (/* . . . */)
} catch (SQLException e) {}
 

Option C

C.    try {
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery (query);
while (rs.next()) (/* . . . */)
} finally {
rs.close();
stmt.close();
}
 

Option D

D.    try {
ResultSet rs = stmt.executeQuery (query);
Statement stmt = con.createStatement();
while (rs.next()) (/* . . . */)
} finally {
rs.close();
stmt.close();
}
 

Correct Answer C
Explanation

Send email to admin@getfreedumps for new dumps request!!!