Which of the following correctly demonstrates how to retrieve stored routine metadata through information_schema?
A.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = ‘city_pop’ AND ROUTINE_SCHEMA = ‘world’
B.
SELECT * FROM INFORMATION_SCHEMA. STORED_ROUTINES WHERE ROUTINE_NAME = ‘city_pop’ AND ROUTINE_SCHEMA = ‘world’
C.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE = ‘city_pop’ AND SCHEMA = ‘world’
D.
SELECT * FROM INFORMATION_SCHEMA.STORED_ROUTINES WHERE ROUTINE = ‘city_pop’ AND SCHEMA = ‘world’