Online Access Free 1Z1-805 Exam Questions

Given the code fragment:
try {
String query = "SELECT * FROM Employee WHERE ID=110";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query); // Line 13
System.out.println("Employee ID: " + rs.getInt("ID")); // Line 14
} catch (Exception se) {
System.out.println("Error");
}
Assume that the SQL query matches one record. What is the result of compiling and executing this code?

• A.The code prints error.
• B.Compilation fails due to an error at line 14.
• C.Compilation fails due to an error at line 13.
• D.The code prints the employee ID.

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.An exception is thrown at runtime
• B.The program prints Error
• C.The statement at line 16 execute
• D.Compilation fails.

Which is true regarding the java.nio.file.Path Interface?

• A.Paths associated with the default provider are not interoperable with the java.io.File class.
• B.Implementations of this interface are not safe for use by multiple concurrent threads.
• C.Implementations of this interface are immutable.
• D.The interface extends WatchService interface

Which two statements are true about RowSet subinterfaces?

• A.A jdbcRowSet object provides a JavaBean view of a result set.
• B.A cachedRowSet provides a connected view of the database.
• C.A FilteredRowSet object filter can be modified at any time.
• D.A webRowSet returns JSON-formatted data.

The current working directory is named finance.
Which two code fragments allow you to write the salary.dat file if it does not exist under "finance\payroll"?

• A.public static void setFileContent (String[] s) throws IOException {
  path p=paths.get("payroll\\salary.dat");
  File file=p.toAbsolutePath().toFile();
  try (BufferWriter br = new BufferWriter (new FileWriter(File))) {
  br.write ("experience new features of java");
  }
  }
• B.public static void setFileContent (String[] s) throws IOException {
  File file= new File ("payroll\\salary.dat").getCanonicalFile();
  try (BufferWriter br = new BufferWriter (new FileWriter(File))) {
  br.write ("experience new features of java");
  }
  }
• C.public static void setFileContent (String[] s) throws IOException {
  File file=new File ("payroll\\salary.dat").getAbsolutePath();
  try (BufferWriter br = new BufferWriter (new FileWriter(File))) {
  br.write ("experience new features of java");
  }
  }
• D.public static void setFileContent (String[] s) throws IOException {
  File file= new file ("payroll\\salary.dat").getCanonicalFile();
  try (BufferWriter br = new BufferWriter (new FileWriter(File))) {
  br.write ("experience new features of java");
  }
  }
• E.public static void setFileContent (String[] s) throws IOException {
  path p=paths.get ("payroll\\salary.dat");
  File file=p.toAbsolutePath(LinkOption.NOFOLLOW_LINKS).toFile();
  try (BufferWriter br = new BufferWriter (new FileWriter(File))) {
  br.write ("experience new features of java");
  }
  }