1Z0-874 試験問題を無料オンラインアクセス

Why should you be selective when granting the PROCESS privilege to an account?

• A.Because it allows for the use of the SHOW PROCESSLIST command, which can expose data.
• B.Because it allows the client to control running processes on the server.
• C.Because it allows the client to process scripts.
• D.Because it allows for the use of stored routines.

How can the strict SQL mode provide added security? (Choose three)

• A.By rejecting actions that do not have values for columns without a default.
• B.By limiting the operations that the server can perform.
• C.By restricting incorrect data types.
• D.By restricting out of range values.

Which of the following statements are true regarding the structure of grant tables in new distributions?

• A.They remain the same for backwards compatibility.
• B.They are often changed.
• C.They change with every upgrade.

Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Code = 'CAN' *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: const possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: const rows: 1 Extra: Which of the following best describes the meaning of the value of the type column?

• A.Several rows may be read from the table.
• B.The table has exactly one row.
• C.Only one row of all its rows need to be read.

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.