Free Oracle 1Z0-805 Exam Dumps Questions & Answers

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

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

Given the code fragment:
public static void main(String[] args) {
String source = "d:\\company\\info.txt";
String dest = "d:\\company\\emp\\info.txt";
//insert code fragment here Line **
} catch (IOException e) {
System.err.println ("Caught IOException: " + e.getmessage();
}
}
Which two try statements, when inserted at line **, enable the code to successfully move the file info.txt to the destination directory, even if a file by the same name already exists in the destination directory?

• A.  try {Files.copy(Paths.get(source), Paths.get(dest));
  Files.delete(Paths.get(source));
• B.  try {FileChannel in = new FileInputStream(source).getChannel();
  FileChannel out = new FileOutputStream(dest).getChannel ();
  in.transferTo (0, in.size(), out);
• C.  try {Files.move (Paths.get(source), Paths.get(dest));
• D.  try {BufferedReader br = Files.newBufferedReader(Paths.get(source), Charset.forName ("UTF-
  8"));
  BufferedWriter bw = Files.newBufferedWriter (Paths.get(dest), Charset.forName ("UTF-8"));
  String record = "";
  while ((record = br.readLine()) != null){
  bw.write (record);
  bw.newLine();
  }
  Files.delete(Paths.get(source));
• E.  try {Files.copy(Paths.get(source), Paths.get(dest));
  Files.delete(Paths.get(source));

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.  Compilation fails.
• D.  The statement at line 16 execute

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 customer IDs.
• B.  The program prints Error.
• C.  Compilation fails on line 13.
• D.  The program prints employees IDs.

Which two statements are true about the walkFileTree method of the files class?

• A.  The file tree traversal is breadth-first with the given FileVisitor invoked for each file encountered.
• B.  The maxDepth parameter's value is the maximum number of directories to visit.
• C.  If the file is a directory, and if that directory could not be opened, the postVisitFileFailed method is invoked with the I/O exception.
• D.  By default, symbolic links are not automatically followed by the method.