Question 56

Which statement is true about the single abstract method of the java.util.function.Function interface?
  • Question 57

    Given the code fragment:
    9. Connection conn = DriveManager.getConnection(dbURL, userName,
    passWord);
    10. String query = "SELECT id FROM Employee";
    11. try (Statement stmt = conn.createStatement()) {
    12. ResultSet rs = stmt.executeQuery(query);
    13.stmt.executeQuery("SELECT id FROM Customer");
    14. while (rs.next()) {
    15. //process the results
    16.System.out.println("Employee ID: "+ rs.getInt("id"));
    17.}
    18. } catch (Exception e) {
    19. System.out.println ("Error");
    20. }
    Assume that:
    - The required database driver is configured in the classpath.
    - The appropriate database is accessible with the dbURL, userName, and
    passWord exists.
    - The Employee and Customer tables are available and each table has id
    column with a few records and the SQL queries are valid.
    What is the result of compiling and executing this code fragment?
  • Question 58

    Given the code fragments:
    public class Book implements Comparator<Book> {
    String name;
    double price;
    public Book () {}
    public Book(String name, double price) {
    this.name = name;
    this.price = price;
    }
    public int compare(Book b1, Book b2) {
    return b1.name.compareTo(b2.name);
    }
    public String toString() {
    return name + ":" + price;
    }
    }
    and
    List<Book>books = Arrays.asList (new Book ("Beginning with Java", 2), new book ("A
    Guide to Java Tour", 3));
    Collections.sort(books, new Book());
    System.out.print(books);
    What is the result?
  • Question 59

    Given:
    class Bird {
    public void fly () { System.out.print("Can fly"); }
    }
    class Penguin extends Bird {
    public void fly () { System.out.print("Cannot fly"); }
    }
    and the code fragment:
    class Birdie {
    public static void main (String [ ] args) {
    fly( ( ) -> new Bird ( ));
    fly (Penguin : : new);
    }
    /* line n1 */
    }
    Which code fragment, when inserted at line n1, enables the Birdie class to compile?
  • Question 60

    Given:
    Item table
    ID, INTEGER: PK
    DESCRIP, VARCHAR(100)
    PRICE, REAL
    QUANTITY< INTEGER
    And given the code fragment:
    9. try {
    10.Connection conn = DriveManager.getConnection(dbURL, username,
    password);
    11. String query = "Select * FROM Item WHERE ID = 110";
    12. Statement stmt = conn.createStatement();
    13. ResultSet rs = stmt.executeQuery(query);
    14.while(rs.next()) {
    15.System.out.println("ID:" + rs.getInt("Id"));
    16.System.out.println("Description:" + rs.getString("Descrip"));
    17.System.out.println("Price:" + rs.getDouble("Price"));
    18. System.out.println(Quantity:" + rs.getInt("Quantity"));
    19.}
    20. } catch (SQLException se) {
    21. System.out.println("Error");
    22. }
    Assume that:
    - The required database driver is configured in the classpath.
    - The appropriate database is accessible with the dbURL, userName, and
    passWord exists.
    - The SQL query is valid.
    What is the result?