Oracle 1Z0-805 問題集

質問 1：
Given:
Person
public Person(int id)
public int getid()
public String getContactDetails()
public void setContactDetails(String contactDetails) public String getName()
public void setName(String name)
public Person getPerson(int id) throws Exception
public void createPerson(int id) throws Exception
public Person deletePerson(int id) throws Exception
public void updatePerson(Person p) throws Exception
Which group of methods is moved to a new class when implementing the DAO pattern?
A. public int getId ()
public String getContractDetails ()
public void setContactDetails (String ContactDetails)
public void getName ()
public Person setName (String name)
B. public int getId ()
public String getContractDetails ()
public void getName ()
public person getPerson (int id) throws Exception
C. public void setContactDetails(String contactDetails)
public void setName (String name)
D. public person getPerson(int id) throws Exception
public void createPerson (person p) throws exception
public void deleteperson(int id) throws Exception
public void updatePerson (Person p) throws Exception
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Given the code fragment:
public static void main(String[] args) {
Path file = Paths.get("D:\\company\\report.txt");
try (SeekableByteChannel sbc = Files.newByteChannel(file,new OpenOption[]
sbc.position(5);
sbc.truncate(30);
} catch (IOException e) {
System.err.printin("Caught IOException: " + e.getMessage () } ;
}
}
What is the result if the report.txt file contains
Welcome to the world of Java?
A. The contents of the file remain unchanged.
B. The file contains the first five characters.
C. A NonWritableChannelException is thrown at runtime.
D. The file contains the first four characters.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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. Compilation fails on line 13.
C. The program prints customer IDs.
D. The program prints Error.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
In the Java SE7 API, which method is most commonly used by factories to instantiate objects?
A. getInstance ()
B. new ()
C. createObject ()
D. make ()
E. getObject ()
F. create ()
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three must be used when using the Java.util.concurrent package to execute a task that returns a result without blocking?
A. Executor
B. ExecutorService
C. Thread
D. Future
E. Callable
F. Runnable
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two descriptions are benefits of using PreparedStatement objects over static SQL in JDBC?
A. Built in support for multi database transaction semantics
B. Prevention of SQL injection attacks
C. Conversion to native SQL
D. Supports BLOB types on every type of database
E. Improved performance from frequently run SQL queries
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Consider the following database table: Inventory Table
*Item_ID, Integer: PK
*Item_name, Varchar (20)
*Price, Numeric (10, 2)
*Quan, Integer
Consider the following method that updates the prices in the Inventory table:
public static void updatePrices{ // #1: missing line
Connection con) throws SQLException {
// #2: missing line
PreparedStatement updatePrices = con.prepareStatement (updatePricesString);
// #3: missing line { // #4: missing line updatePrices.executeUpdate(); } }
This method us missing four lines, which group of lines complete this method?
A. 1. HashMap<Integer, Float> newPrices,
2.StringupdatePriceString = "UPDATE inventory SET price =? WHERE item_id '?' ";
3.For (map.Entry<Integer, String> x : newPrices.entrySet())
4.UpdatePrices.setFloat(1, x.getvalue().floatValue()); updatePrice.setString (2,
x.getKey().intValue());
B. 1. HashMap<Integer, Float> newPrices,
2.StringupdatePriceString = "UPDATE inventory SET price =? Where item_id '?' ";
3.For (map.Entry<Integer, String> x : newPrices.entrySet())
4.UpdatePrices.setInt(1, x.getvalue().floatValue()); updatePrice.setString (2, x.getvalue().floatValue()
C. 1. HashMap<Integer, Float> newPrices,
2.StringupdatePriceString = "UPDATE inventory SET price =? Where item_id '?' ";
3.For (map.Entry<Integer, String> x : newPrices.entrySet())
4.UpdatePrices.setInt(1, x.getvalue().floatValue()); updatePrice.setString (2, x.getvalue());
D. 1. HashMap<Integer, String> newPrices,
2.StringupdatePriceString = "UPDATE inventory SET price =? WHERE item_name '?' ";
3.For (map.Entry<Integer, String> x : newPrices.entrySet())
4.UpdatePrices.setFloat(1, x.getvalue().floatValue()); updatePrice.setString (2, x.getKey());
E. 1. HashMap<Integer, String> newPrices,
2.StringupdatePriceString = "UPDATE inventory SET price =? Where item_id '?' ";
3.For (map.Entry<Integer, String> x : newPrices.entrySet())
4.UpdatePrices,setString(1, x.getKey()); updatePrices.setFloat(2, x.getValue().floatValue());
F. 1. HashMap<Integer> newPrices,
2.StringupdatePriceString = "UPDATE inventory SET price =? Where item_id '?' ";
3.For (Integer x: newPrice)
4.updatePrice.setInt(1, x);
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Two companies with similar robots have merged. You are asked to construct a new program that allows the features of the robots to be mixed and matched using composition. Given the code fragments:
public class CrusherRobot {
public void walk () {}
public void positionArm (int x, int y, int z) {}
public void raiseHammer() {}
public void dropHammer() {}
}
public class GripperRobot {
public void walk() {}
public void moveArm (int x, int y, int z) {}
public void openGripper () {}
public void closeGripper() {}
}
When applying composition to these two classes, what functionality should you extract into a new class?
A. A new BasicRobotFactory class to construct instances of GripperRobot.
B. A new BasicRobot class that provides walking.
C. A new BasicRobotFactory class to construct instances of CrusherRobot.
D. A new BasicRobot class that combines gripping and hammering.
正解：D