Which privileges are required on the source server to use mysqldbcopy?
A. CREATE
B. INSERT
C. UPDATE
D. SELECT
Answer: Option D
Solution (By Examveda Team)
This question is about mysqldbcopy, a tool in MySQL used to copy data between servers.To use mysqldbcopy, you need the right permissions on the source server (where the data comes from).
Think of it like taking a photo of something. You need permission to look at the thing (the data) you want to copy.
So, the answer is Option D: SELECT.
The SELECT privilege allows you to read the data from the source server.
The other options (CREATE, INSERT, UPDATE) are about modifying data, which isn't needed for copying.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion