Oracle Upgrade to Java SE 7 Programmer - 1Z0-805

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, 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());
• 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.setFloat(1, x.getvalue().floatValue()); updatePrice.setString (2,
  x.getKey().intValue());
• 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().floatValue()
• D. 1. HashMap<Integer> newPrices,
  2.StringupdatePriceString = "UPDATE inventory SET price =? Where item_id '?' ";
  3.For (Integer x: newPrice)
  4.updatePrice.setInt(1, x);
• 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, 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());

Given the code fragment: SimpleDateFormat sdf = new SimpleDateFormat("zzzz", Locale.US);
System.out.println ("Result: " + sdf.format(today) ) ;
What type of result is printed?

• A. Full-text time zone name
• B. Era
• C. Julian date
• D. Time of the Epoch (in milliseconds)
• E. Time zone abbreviation

Given:
import java.io.*;
public class SampleClass {
public static void main(String[] args) throws IOException {
try {
String dirName = args[0];
File dir = new File(dirName);
File.createTempFile("temp", "log", dir);
} catch (NullPointerException | IOException e) {
e = new IOException("Error while creating temp file");
throw e;
}
}
}
What is the result?

• A. Compilation fails.
• B. An IOException with the default message is thrown at runtime.
• C. A temporary file is created in the specified directory.
• D. An IOException with the message Error while creating temp file is thrown at runtime.

Given:
private static void copyContents() {
try (
InputStream fis = new FileInputStream("report1.txt");
OutputStream fos = new FileOutputStream("consolidate.txt");
) {
byte[] buf = new byte[8192];
int i;
while ((i = fis.read(buf)) != -1) {
fos.write(buf, 0, i);
}
fis.close();
fis = new FileInputStream("report2.txt");
while ((i = fis.read(buf)) != -1) {
fos.write(buf, 0, i);
}
}
What is the result?

• A. The contents of report1.txt are copied to consolidate.txt. The contents of report2.txt are appended to consolidate.txt, without a break in the flow.
• B. Compilation fails due to error at line 15 and 16
• C. Compilation fails due to an error at line 28
• D. The contents of report1.txt are copied to consolidate.txt. The contents of report2.txt are appended to consolidate.txt, after a new line

Given the following code fragment:
public static void getInfo() {
//insert code here
List fontCatalog = new ArrayList();
fontCatalog.add("Algerian");
fontCatalog.add("Cambria");
fontCatalog.add("Lucida Bright");
category.put("firstCategory",fontCatalog);
List entrySet = new ArrayList(category.entrySet());
Iterator it = entrySet.iterator();
while(it.hasNext()) {
System.out.println(it.next));
}
}
Which two code fragments, when inserted independently at line **, enable the code to compile?

• A. Map<String, List<String>> category = new HashMap<> ();
• B. Map<String, List<String>> category = new HashMap<List> ();
• C. Map<String, List<String>> category = new HashMap<String, List<String>> ();
• D. Map<String, List<String>> category = new HashMap <String, ArrayList<String>> ();
• E. Map<String, List<String>> category = new HashMap<String, List <>> ();
• F. Map<String, List<String>> category = new HashMap<<>,List<>>();