CIW
1D0-441 · Question #162
1D0-441 Question #162: Real Exam Question with Answer & Explanation
Sign in or unlock 1D0-441 to reveal the answer and full explanation for question #162. The question stem and answer options stay visible for context.
Question
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()) 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?
Options
- A00001
- BAAAAA
- C00001
- D1
Unlock 1D0-441 to see the answer
You've previewed enough free 1D0-441 questions. Unlock 1D0-441 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.