Explain federated tables?

Answers were Sorted based on User's Feedback



Explain federated tables?..

Answer / amith

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

Is This Answer Correct ?    9 Yes 0 No

Explain federated tables?..

Answer / sivaraj

The FEDERATED storage engine is available beginning with
MySQL 5.0.3. It is a storage engine that accesses data in
tables of remote databases rather than in local tables.

Is This Answer Correct ?    6 Yes 0 No

Explain federated tables?..

Answer / aravind

The FEDERATED storage engine is available beginning with
MySQL 5.0.3. This storage engine enables data to be
accessed from a remote MySQL database on a local server
without using replication or cluster technology. When using
a FEDERATED table, queries on the local server are
automatically executed on the remote (federated) tables. No
data is stored on the local tables

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is index length in mysql?

1 Answers  


What is mysql architecture?

1 Answers  


What are the functions of commit and rollback statements?

1 Answers  


What is MySQL Stored Procedure?

1 Answers  


Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 Answers  


What is username in mysql?

1 Answers  


What is a trigger? How you can create a trigger in mysql?

1 Answers  


What does it mean to be case sensitive?

1 Answers  


How do I copy an entire mysql database?

1 Answers  


Which is faster mongodb or mysql?

1 Answers  


How to execute mysql query in php?

1 Answers  


Explain Normalization concept?

2 Answers   Inuva,


Categories