Which two Functions can be used in a C program to retrieve information about warning?

A. mysql_info

B. mysql_error

C. mysql_warning_count

D. mysql_errno

What are two ways in which normalizing your tables helps improve performance In MySQL?

A. Smaller table sizes and row lengths improve sorting operations.

B. Separate tables allow indexing more columns.

C. Fewer nullable column improve index usage.

D. Normalizing Improves the performance of innodb_file_per _table.

Which condition must be true in order that a view is considered updateable?

A. The user must have the UPDATE or DELETE privilege for the underlying table.

B. There must be a subquery in the WHERE clause that refers to a table in the FROM clause.

C. There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.

D. The view must only refer to literal values.

The city table has the following structure:

Consider the statement with an incorrect field name:

PREPARE countryBYID FROM `SELECT country FROM city WHERE ID=?, What happens if a prepared

statement named countryByID already exists when the above statement is executed?

A. A duplicate name error will result because a prepared statement with the same name already exists.

B. An unknown column error will result and the old prepared statement definition will remain in effect.

C. An unknown column error will result and no prepared statement named countryByID will exist.

D. A warning will result and the old prepared statement definition will remain in effect.

Consider the stored procedure

CREATE PROCEDURE param_test (

IN P_in INT,

OUT P_out INT,

INPUT P_inout INT)

BEGIN

SELECT P_in, P_out, P_ inout;

SET P_in, P_inout

END

You execute a series of commands:

What is the output of the CALL and SELECT?

A. (0,0,0) and (0,0,0)

B. (0,0,0,) and (0,200,300)

C. (0,NULL,0) and(0,200,300)

D. (0,NULL,0) and (100,200,300)