nerdexam
Oracle

1Z0-883 · Question #38

Which three methods will show the storage engine for the Country table?

The correct answer is A. SHOW CREATE TABLE Country; C. SHOW TABLE STATUS LIKE `Country'; D. SELECT ENGINE. See the full explanation below for the reasoning.

Question

Which three methods will show the storage engine for the Country table?

Options

  • ASHOW CREATE TABLE Country;
  • BSHOW ENGINE Country STATUS;
  • CSHOW TABLE STATUS LIKE `Country';
  • DSELECT ENGINE
  • ESELECT ENGINE

How the community answered

(24 responses)
  • A
    75% (18)
  • B
    8% (2)
  • E
    17% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice