What happens if a table has one column defined a

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What happens if a table has one column defined as TIMESTAMP?

That field gets the current timestamp whenever the row gets altered.

(Continued on next question...)

Other Job Interview Questions

• How MySQL Stores Its Row Data and Index Data?
• Functionality Missing from MySQL - Foreign Keys
• On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?
• MySQL - SQL Commands Related to Replication
• MySQL - Replication Implementation Overview
• MySQL - When and how much can MySQL replication improve the performance of my system?
• What happens if a table has one column defined as TIMESTAMP?
• MySQL - How can I use replication to provide redundancy/high availability?
• MySQL - How do I rotate replication logs?
• Explain advantages of MyISAM over InnoDB?
• More...