nerdexam
Oracle

1Z0-146 · Question #139

Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)

The correct answer is A. DDL report for all objects dependent on a table D. data definition language (DDL) report for all the tables in a schema. See the full explanation below for the reasoning.

Question

Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)

Options

  • ADDL report for all objects dependent on a table
  • BDDL report for all the objects stored in a tablespace
  • CDDL report for all the invalidated objects in a schema
  • Ddata definition language (DDL) report for all the tables in a schema

How the community answered

(21 responses)
  • A
    76% (16)
  • B
    10% (2)
  • C
    14% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice