nerdexam
Oracle

1Z0-882 · Question #54

Using the query: SELECT Code FROM country WHERE Name = `united states' Which statement executed in the mysql client would create a prepared statement?

The correct answer is C. PREPARE countrycode FROM `SELECT code FROM country WHERE Name =? See the full explanation below for the reasoning.

Question

Using the query:

SELECT Code FROM country WHERE Name = `united states' Which statement executed in the mysql client would create a prepared statement?

Options

  • APREPARE STATEMENT countrycode FROM `SELECT code FROM counyry WHERE Name =?.;
  • BPREPARE countrycode As `SELECT code FROM country WHERE Name =?.;
  • CPREPARE countrycode FROM `SELECT code FROM country WHERE Name =?.;
  • DPREPARE STATEMENT countrycode As `SELECT code FROM country WHERE Name =?.;

How the community answered

(57 responses)
  • A
    5% (3)
  • B
    16% (9)
  • C
    72% (41)
  • D
    7% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice