Questões prova 1Z0-871

Question 1:
Is the following statement true or false?
All of the MySQL client programs and utilities communicate with the MySQL server.

Question 2:
Is the following statement true or false?
When running a MySQL server under Windows, client programs accessing that server also must run under
Windows.

Question 3:
Is the following statement true?
All MySQL programs read startup options from plain text option files named my.ini, my.cnf, or
.my.cnf.

Question 4:
Is the following statement true or false?
A command-line program commonly used to communicate with the server is called mysqld.

Question 5:
If you connect to a local server on a Unix machine using the hostname localhost, will the connection
be made using TCP/IP or a Unix socket file? How will the connection be made if you use the local
host's actual name?

Question 6:
Which connection parameters identify you to the MySQL server?

Question 7:
Suppose that you invoke mysql with the -h localhost option.
a. Will mysql establish a connection to a local server or a remote server?
b. Will mysql use a Unix socket file, a Windows named pipe, Windows shared memory, or TCP/IP?
c. Will mysql work only for a specific operating system?

Question 8:
Suppose that you invoke mysql with the -h . option.
a. Will mysql establish a connection to a local server or a remote server?
b. Will mysql use a Unix socket file, a Windows named pipe, Windows shared memory, or TCP/IP?
c. Will mysql work only for a specific operating system?

Question 9:
Suppose that you invoke mysql with the -h 127.0.0.1 option.
a. Will mysql establish a connection to a local server or a remote server?
b. Will mysql use a Unix socket file, a Windows named pipe, Windows shared memory, or TCP/IP?
c. Will mysql work only for a specific operating system?

Question 10:
Suppose that you invoke mysql with the -h 192.168.10.1 option.
a. Will mysql establish a connection to a local server or a remote server?
b. Will mysql use a Unix socket file, a Windows named pipe, Windows shared memory, or TCP/IP?
c. Will mysql work only for a specific operating system?