nerdexam
Oracle

1Z0-144 · Question #120

The add_player procedure inserts rows into the PLAYER table. Which command will show this direct dependency?

The correct answer is A. SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'PLAYER'. See the full explanation below for the reasoning.

Question

The add_player procedure inserts rows into the PLAYER table. Which command will show this direct dependency?

Options

  • ASELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'PLAYER';
  • BSELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'ADD_PLAYER';
  • CSELECT * FROM USER_DEPENDENCIES WHERE TYPE = 'DIR';
  • DSELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'TABLE';

How the community answered

(43 responses)
  • A
    74% (32)
  • B
    14% (6)
  • C
    7% (3)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-144 Practice