56.
Which of the following statements are true regarding wildcards in the host name of an account
specification?
- A.The '%' character is used to match any number of characters or numbers
- B.The '*' character is used to match any number of characters or numbers
- C.The '_' character is used to match any number of characters or numbers
- D.The '.' character is used to match any single character or number
- E.Wildcards may be used to match any number of characters at the beginning of the host name or IP address only
- F.Wildcards may be used to match any number of characters anywhere in the host name or IP address
- Answer
- Report
Answer : [A, F]
57.
Does max_connections have an affect on the number of slaves that may connect to a master?
- A.No, because slaves are not really clients.
- B.Yes, because each slave is effectively a connected user.
- C.No, because slaves do not use the same type of connection as a regular client.
- D.Yes, because if the server has too many connections, it may slow the slaves down.
- Answer
- Report
Answer : [B]
58.
Which of the following best describes what the master.info file contains and how it is used?
- A.It contains the values from the CHANGE MASTER statement.
- B.When the slave restarts it looks for which master to use from this file.
- C.It contains information about the master server, its slaves and its configuration.
- D.It is used by an administrator to determine what slaves connect to the master, and other information about the master server.
- Answer
- Report
Answer : [A, B]
59.
Which of the following is/are valid reasons to consider using --skip-networking?
- A.Your server is not networked to other servers.
- B.You do not have a need for remote clients to connect.
- C.You have a need for remote clients to connect.
- D.You are not going to use replication or clustering.
- Answer
- Report
Answer : [B]
60.
Which of the following would be considered a good candidate table for compression?
- A.A table with data that needs only few updates in the future.
- B.A table with data that will not be updated in the future.
- C.A large table, such as those used for data warehousing.
- D.AllMyISAM tables are good candidates for compression.
- Answer
- Report
Answer : [B]
|
|
||||||||||||||||||||||||||||
