1Z0-805 | 10 Tips For Regenerate 1Z0-805 braindumps

Q1. 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. The code prints the employee ID.

C. Compilation fails due to an error at line 13.

D. Compilation fails due to an error at line 14.

Answer: B

Explanation: Assuming that the connection conn has been set up fine, the code will compile and run fine.

Note #1: The GetInt method retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Note 2: A table of data representing a database result set, which is usually generated by executing a statement that queries the database.

A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.

A default ResultSet object is not updatable and has a cursor that moves forward only. Thus, you can iterate through it only once and only from the first row to the last row. It is possible to produce ResultSet objects that are scrollable and/or updatable.

Reference: The Java Tutorials, Interface ResultSet

Q2. Given:

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

A. Singleton

B. DAO

C. Factory

D. Composition

Answer: B

Explanation: We move the most abstract highest level methods into a separate class.

Note: Data Access Object

Abstracts and encapsulates all access to a data source

Manages the connection to the data source to obtain and store data

Makes the code independent of the data sources and data vendors (e.g. plain-text, xml,

LDAP, MySQL, Oracle, DB2)

Q3. Given the code fragment:

/* method declaration */ {

try {

String className = "java.lang.String";

String fieldname = "somefield";

Class c = Class.forName(className);

Field f = c.getField(fieldname);

} catch(Exception e) {

e.printStackTrace();

throw e;

}

Which two method declarations are valid options to replace /* method declaration */?

A. public void getMetadata ()

B. public void getMetadat ()

C. public void getMetadata () throws Exception

D. public void getMetadata () throws NoSuchFieldException

E. public void getMetadata () throws classNotFoundException

F. public void getMetadata () throws ClassNotFoundException, NoSuchFieldException.

Answer: C,F

Explanation: We must specify that the getMetaData method can throw both ClassNotFoundException (line Class c = Class.forName(className);) and a NoSuchFieldException (line Field f = c.getField(fieldname);). We can do this by either declare that all exception can be thrown or that these two specific exceptions can be thrown

Note: Valid Java programming language code must honor the Catch or Specify Requirement. This means that code that might throw certain exceptions must be enclosed by either of the following:

* A try statement that catches the exception. The try must provide a handler for the exception.

* A method that specifies that it can throw the exception. The method must provide a throws clause that lists the exception.

Code that fails to honor the Catch or Specify Requirement will not compile.

Reference: The Java Tutorials, The Catch or Specify Requirement

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

A. The interface extends WatchService interface

B. Implementations of this interface are immutable.

C. Implementations of this interface are not safe for use by multiple concurrent threads.

D. Paths associated with the default provider are not interoperable with the java.io.File class.

Answer: A

Explanation: The java.nio.file.Path interface extends Watchable interface so that a directory located by a path can be registered with a WatchService and entries in the directory watched.

Note: An object that may be used to locate a file in a file system. It will typically represent a system dependent file path. A Path represents a path that is hierarchical and composed of a sequence of directory and file name elements separated by a special separator or delimiter. A root component, that identifies a file system hierarchy, may also be present. The name element that is farthest from the root of the directory hierarchy is the name of a file or directory. The other name elements are directory names. A Path can represent a root, a root and a sequence of names, or simply one or more name elements. A Path is considered to be an empty path if it consists solely of one name element that is empty. Accessing a file using an empty path is equivalent to accessing the default directory of the file system. Path defines the getFileName, getParent, getRoot, and subpath methods to access the path components or a subsequence of its name elements.

Reference: java.nio.file.Path Interface

Q5. How many Threads are created when passing tasks to an Executor Instance?

A. A new Thread is used for each task.

B. A number of Threads equal to the number of CPUs is used to execute tasks.

C. A single Thread is used to execute all tasks.

D. A developer-defined number of Threads Is used to execute tasks.

E. A number of Threads determined by system load is used to execute tasks.

F. The method used to obtain the Executor determines how many Threads are used to execute tasks.

Answer: F

Explanation: A simple way to create an executor that uses a fixed thread pool is to invoke the newFixedThreadPool factory method in java.util.concurrent.Executors This class also provides the following factory methods:

* The newCachedThreadPool method creates an executor with an expandable thread pool. This executor is suitable for applications that launch many short-lived tasks.

* The newSingleThreadExecutor method creates an executor that executes a single task at a time.

* Several factory methods are ScheduledExecutorService versions of the above executors.

If none of the executors provided by the above factory methods meet your needs, constructing instances of java.util.concurrent.ThreadPoolExecutor or java.util.concurrent.ScheduledThreadPoolExecutor will give you additional options.

Note: The Executor interface provides a single method, execute, designed to be a drop-in replacement for a common thread-creation idiom. If r is a Runnable object, and e is an Executor object you can replace (new Thread(r)).start(); with e.execute(r); However, the definition of execute is less specific. The low-level idiom creates a new thread and launches it immediately. Depending on the Executor implementation, execute may do the same thing, but is more likely to use an existing worker thread to run r, or to place r in a queue to wait for a worker thread to become available.

Reference: The Java Tutorials, Thread Pools

Reference: The Java Tutorials, Executor Interfaces

Q6. 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 "financepayroll"?

A. public static void setFileContent (String[] s) throws IOException {

path p=paths.get("payroll\salary.dat");

File file=p.toAbsolutePath().toFile();