Question:Which of the following will show when a table in a MySQL database was last updated?
A Using the following query: SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name'
B Creating an on-update trigger to write timestamp in a custom table, then querying the custom table
C Getting the "last modified" timestamp of the corresponding database file in the file system
D None
+ AnswerA
+ Report