Besides specifying the column names and data types, which connection parameters may be defined when defining a FEDERATED table?

The correct answer is A. The name and database of the referenced table B. The host name of the server where the referenced table is located C. The user name and password to be used to connect the remote server. Connection string format is as follows, where optional parts are shown in square brackets: mysql://user_name[:password]@host_name[:port]/db_name/table_name The username, password, hostname, and port number specify what connection parameters to use for connecting to the remote…

MySQL Storage Engines

Question

Options

AThe name and database of the referenced table
BThe host name of the server where the referenced table is located
CThe user name and password to be used to connect the remote server
DThe compression method to be used
EThe operating system of the remote server

How the community answered

(26 responses)

A
69% (18)
D
12% (3)
E
19% (5)

Explanation

Connection string format is as follows, where optional parts are shown in square brackets: mysql://user_name[:password]@host_name[:port]/db_name/table_name The username, password, hostname, and port number specify what connection parameters to use for connecting to the remote server. The database and table names indicate which table to access

Topics

#FEDERATED storage engine#connection parameters#remote table reference

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice