nerdexam
Oracle

1Z0-882 · Question #47

Which two statements provide the definition for a view named view1 in the test database?

The correct answer is B. SHOW CREATE VIEW test-view1 C. SELECT VIEW_DEFINITION_SCHEMA.VIEWS. See the full explanation below for the reasoning.

Question

Which two statements provide the definition for a view named view1 in the test database?

Options

  • ASHOW CREATE VIEW view1 FROM test
  • BSHOW CREATE VIEW test-view1
  • CSELECT VIEW_DEFINITION_SCHEMA.VIEWS
  • DSELECT DEFINITION
  • ESHOW DEFINITION FOR test.view

How the community answered

(21 responses)
  • A
    14% (3)
  • B
    76% (16)
  • D
    5% (1)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice