Question 141

Given that /green.txt and /colors/yellow.txt are accessible, and the code fragment:
Path source = Paths.get("/green.txt);
Path target = Paths.get("/colors/yellow.txt);
Files.move(source, target, StandardCopyOption.ATOMIC_MOVE);
Files.delete(source);
Which statement is true?
  • Question 142

    Given:
    class Sum extends RecursiveAction { //line n1
    static final int THRESHOLD_SIZE = 3;
    int stIndex, lstIndex;
    int [ ] data;
    public Sum (int [ ]data, int start, int end) {
    this.data = data;
    this stIndex = start;
    this. lstIndex = end;
    }
    protected void compute ( ) {
    int sum = 0;
    if (lstIndex - stIndex <= THRESHOLD_SIZE) {
    for (int i = stIndex; i < lstIndex; i++) {
    sum += data [i];
    }
    System.out.println(sum);
    } else {
    new Sum (data, stIndex + THRESHOLD_SIZE, lstIndex).fork( );
    new Sum (data, stIndex,
    Math.min (lstIndex, stIndex + THRESHOLD_SIZE)
    ).compute ();
    }
    }
    }
    and the code fragment:
    ForkJoinPool fjPool = new ForkJoinPool ( ); int data [ ] = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10} fjPool.invoke (new Sum (data, 0, data.length));
    and given that the sum of all integers from 1 to 10 is 55. Which statement is true?
  • Question 143

    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?
  • Question 144

    Which two reasons should you use interfaces instead of abstract classes? (Choose two.)
  • Question 145

    Given the records from the Employee table:

    and given the code fragment:
    try {
    Connection conn = DriverManager.getConnection (URL, userName, passWord);
    Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
    ResultSet.CONCUR_UPDATABLE);
    st.execute("SELECT*FROM Employee");
    ResultSet rs = st.getResultSet();
    while (rs.next()) {
    if (rs.getInt(1) ==112) {
    rs.updateString(2, "Jack");
    }
    }
    rs.absolute(2);
    System.out.println(rs.getInt(1) + " " + rs.getString(2));
    } catch (SQLException ex) {
    System.out.println("Exception is raised");
    }
    Assume that:
    The required database driver is configured in the classpath.
    The appropriate database accessible with the URL, userName, and passWord exists.
    What is the result?