nerdexam
Oracle

1Z0-883 · Question #55

You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are notified that users are getting the following error: mysql> CALL film_in_stock (40, 2, @count); ERROR…

The correct answer is C. Execute SELECT * FROM INFORMATION_SCHEMA. See the full explanation below for the reasoning.

Question

You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are notified that users are getting the following error:

mysql> CALL film_in_stock (40, 2, @count); ERROR 1449 (HY000): The user specified as a definer (`bon'@'localhost') does not exist How would you identify all stored procedures that pose the same problem?

Options

  • AExecute SELECT * FROM mysql.routines WHERE DEFINER='bob@localhost';.
  • BExecute SHOW ROUTINES WHERE DEFINER='bob@localhost'.
  • CExecute SELECT * FROM INFORMATION_SCHEMA.
  • DExecute SELECT * FROM INFORMATION_SCHEMA.
  • EExamine the Mysql error log for other ERROR 1449 messages.

How the community answered

(51 responses)
  • A
    2% (1)
  • B
    10% (5)
  • C
    78% (40)
  • D
    6% (3)
  • E
    4% (2)

Community Discussion

No community discussion yet for this question.

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