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

Identity two ways to configure a PHP application to use the UTF8 character set.

• A.spdo = new PDO (''mysql:host=localhost;dbname=test;charset=utfs'', user'', ''pass'');
• B.mysqli: :query (''SET NAMES utfs'');
• C.PDO: :set_charset(''utf8'')
• D.mysqli : :set_charset ('utf8')

Inspect the query:
Mysql> SELECT count (emp_no) FROM titles WHERE title = 'senior staff';

How can this query be optimized?

• A.The query cannot be optimized as an index is already used.
• B.The query needs an index that includes the title column.
• C.The query cannot be optimized as count () must read all rows.
• D.The query need an index on the emp-no column.

You want to use the SHA -256 Authentication plugin with Connector/J.
Which two parameter settings achieve this?

• A.defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin
• B.defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin
• C.Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jdbc
• D.Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin

Given the table City:
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?

• A.A single result set with two columns containing the names from country codes USA and JPN.
• B.A single result set with one column that contains the names of cities from country codes USA and JPN.
• C.Two result sets each containing a single column with the names of cities from country codes USA and JPN.
• D.No result set is returned and an error message is given.

The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than 'max_allowed_packet' bytes
With two scenarios can (Hibernate this error message?

• A.The operating system caused an error inducing the max_allowed_packet error.
• B.The application tried to SELECT many rows together that exceeded max__allowed_packet.
• C.The application did not use the COMPRESS () function for a large result set.
• D.The application tried to INSERT a row that exceeded max_allowed_packet.
• E.The application tried to SELECT a row that exceeded max_allowed_packet.
• F.The network caused an error Inducing the max_allowed_packet error.