Explain federated tables.

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

(Continued from previous question...)

Explain federated tables.

Introduced in MySQL 5.0, federated tables allow access to the tables located on other databases on other servers.

(Continued on next question...)

Other Job Interview Questions

• What’s the default port for MySQL Server?
• How do you control the max size of a HEAP table?
• On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?
• What are HEAP tables in MySQL?
• How do you change a password for an existing user via mysqladmin?
• Functionality Missing from MySQL - How to Cope Without COMMIT/ROLLBACK
• How do you get a portion of a string?
• What is SERIAL data type in MySQL?
• The Main Features of MySQL
• What’s the difference between Unix timestamps and MySQL timestamps?
• More...