Exam 1z0-809 topic 1 question 154 discussion

Actual exam question from Oracle's 1z0-809

Question #: 154
Topic #: 1

Given the structure of the Student table:
Student (id INTEGER, name VARCHAR)
Given the records from the STUDENT table:

Given the code fragment:

Assume that:
✑ The required database driver is configured in the classpath.
✑ The appropriate database is accessible with the dbURL, userName, and passWord exists.
What is the result?

A. The program prints Status: true and two records are deleted from the Student table.
B. The program prints Status: false and two records are deleted from the Student table.
C. A SQLException is thrown at runtime.
D. The program prints Status: false but the records from the Student table are not deleted.

Show Suggested Answer

Suggested Answer: B 🗳️

by Svetleto13 at May 28, 2021, 1:13 p.m.

Comments

Submit Cancel

steefaand

10 months, 4 weeks ago

Selected Answer: B

B is correct since execute returns true for SELECT queries and false for others.

upvoted 1 times

...

WilsonKKerll

2 years, 9 months ago

Answer is B.

upvoted 1 times

...

AVB22

3 years, 2 months ago

execute boolean execute(String sql) throws SQLException Returns:true if the first result is a ResultSetobject; false if it is an update count or there are no results

upvoted 1 times

...

Svetleto13

3 years, 7 months ago

B is correct.

upvoted 1 times

...