nerdexam
CIW

1D0-441 · Question #50

Assuming that conn references a valid and open connection to the database, which code segment will insert values into the Employees relation?

The correct answer is D. Statement s = conn.createStatement(). See the full explanation below for the reasoning.

Question

Assuming that conn references a valid and open connection to the database, which code segment will insert values into the Employees relation?

Options

  • Aconn.executeUpdate(INSERT INTO Employees VALUES +
  • BStatement s = conn.createStatement();
  • CaddBatch(INSERT INTO Employees VALUES +
  • DStatement s = conn.createStatement();
  • EexecuteQuery(INSERT INTO Employees VALUES +
  • FStatement s = conn.createStatement();
  • GexecuteUpdate(INSERT INTO Employees VALUES +

How the community answered

(62 responses)
  • B
    5% (3)
  • C
    2% (1)
  • D
    76% (47)
  • E
    13% (8)
  • F
    2% (1)
  • G
    3% (2)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice