MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II - 1Z0-874무료 덤프문제 풀어보기

A. The max_allowed_packet parameter is global and is only set by shutting down the server.

B. The max_allowed_packet parameter is used to control the buffer that is used for communication between the server and the client.

C. The max_allowed_packet parameter is set per-connection.

D. The max_allowed_packet parameter is used to control the size of the dataset that is sent to the client.

A. The type of storage engines that can be used.

B. Size limits of files.

C. Time to recover from a crash.

D. The number of users MySQL can handle.

E. Table opening time.

A. The number of times per hour that an account is allowed to connect to the server

B. The number of updates per hour an account is allowed to issue

C. MySQL does not have provisions for limiting resource usage

D. The number of queries per hour an account is allowed to issue

E. Resource limits can only be specified globally, not per-account

F. The maximum number of simultaneous connections an account can have

A. They can be uncompressed but some data corruption may occur.

B. They can be uncompressed.

C. They can not be uncompressed.

A. On login, the username, hostname and password are checked to allow access. On every query execution, username, hostname, password and current object access permissions are checked.

B. On login, the username, hostname and password are checked to allow access. On every query execution, username, hostname and current object access permissions are checked.

C. On login, the username, hostname and password are checked to allow access and the object access permissions at login time are used for all subsequent operations for the lifetime of the connection.

A. The CPU load of the system

B. The number of current connections

C. The identity of the client user

D. The current date and time