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 

+ Answer
+ Report
Total Preview: 925

Copyright © 2024. Powered by Intellect Software Ltd