Free Oracle 1Z1-805 Exam Dumps Questions & Answers

Given this code fragment:
try {
String query = "SELECT * FROM Item";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
int rowCount = rsmd.getRowCount();
System.out.println ("Processing: " + rowCount + " rows.");
while (rs.next()) {
// Process each row
}
} catch (SQLException se) {
System.out.println("Error");
}
Assume that the SQL query returns records. What is the result?

• A.Compilation fails.
• B.The program prints Error
• C.An exception is thrown at runtime
• D.The statement at line 16 execute

Given:

Which design pattern moves the getPerson, createPerson, deletePerson, and updatePerson methods to a new class?

• A.Factory
• B.Singleton
• C.DAO
• D.Composition

What statement is true about thread starvation?

• A.Thread "A" is said to be starved when it is blocked waiting for Thread "13," which in turn waiting for Thread "A."
• B.When some of the processors in a multi-processor environment go offline and the live thread(s) blocked waiting for CPU cycles, that blocking is referred to as "thread starvation."
• C.Starvation can occur when threads become so busy responding to other threads that they move forward with their other work.
• D.Thread "A" is said to be starved when it is frequently unable to gain access to a resource that it shares with another thread.

Given the code fragment:
String query = "SELECT ID FROM Employee"; \\ Line 1 try (Statement stmt = conn.CreateStatement()) { \\ Line 2 ResultSet rs = stmt.executeQuery(query); \\ Line 3 stmt.executeQuery ("SELECT ID FROM Customer"); \\ Line 4 while (rs.next()) { \\process the results System.out.println ("Employee ID: " + rs.getInt("ID") ); } } catch (Exception e) { system.out.println ("Error"); }
Assume that the SQL queries return records. What is the result of compiling and executing this code fragment?

• A.The program prints employees IDs.
• B.The program prints customer IDs.
• C.Compilation fails on line 13.
• D.The program prints Error.

Given:
public class StringApp {
public static void main(String[] args) {
String[] str="Java SE,java EE,Java ME,java FX".split(",");
int count=0;
for(int i=0;i<str.length;i++) {
switch(str[i]) {
case "Java SE":
count++; continue;
case "Java EE":
count++; break;
case "Java ME":
count++; break;
case "Java FX":
count++; break;
}
}
System.out.println("Total match found="+count);
}
}
What is the result?

• A.1
• B.4
• C.2
• D.3