Which two PHP modules provide APIs for developing MYSQL applications?

• A. PDO
• B. Mysqlnd
• C. Mysqli
• D. PDO_mysql

Inspect the query:
Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004';

4 rows in set (0.00 sec)
Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE
dept_no='d004';

2 rows in set (0.00 sec)
Which two statements are true about the EXPLAIN output?

• A. The dept_manager table has 4 times as many rows than the employees table.
• B. All data for the result is read from the indexex.
• C. The PRIMARY KEY is used for filtering in both tables.
• D. The minimal number of rows possible are read.

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

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

Examine this table that contains over two million rows of data:
CREATE TABLE 'news_feed' (
.id'bigint (20) NOT NULL AUTO _INCREMENT,
.news _sources_id'varchar (11) NOT NULL,
.dataline' datetime NOT NULL,
.headline' varchar (256) NOT NULL,
.story' text NOT NULL,.tag varchar (32768) DEFAULT NULL,
PRIMARY KEY ('id')
KEY 'dateline' ( 'dateline')
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= '2013-01-01'
Which change would show the greatest improvement in the response time of the query?

• A. Use numeric equivalents for comparing the two dates:
  SELECT. . .WHERE MOD(UNIX_TIMESTAMP (dateline), 86400 =UNIX_TIMESTAMP ('2013-01-01')
• B. Use the LIKE operator:
  SELECT . . .WHERE dateline LIKE '2013-10-01&'
• C. Use a date range comparison:
  SELECT . . . WHERE dateline >= '2013-01' and dateline < '2013-01-02'
• D. USE the DATEDIFF function:
  SELECT . . . WHERE DATEDIFF (dateline, '2013-01-01') = 0