OPOSICION

3. You must suppress warning messages but display error messages. Which command will do this?. A. SET @SQL_WARNINGS=3;. B. SET SQL WARNINGS=0;. C. SET SQL WARNINGS=3;. D. SET SQL_WARNINGS=1;. E. SET @SQL WARNINGS=1;. F. SET @SQL WARNINGS=0;.

4. You require a MySQL connector to ease migration of a PHP application from other Relational Database Management Systems with minimal code change Which connector will do this. A. PDO connector. B. mysql connector. C. mysqli connector with XDev API. D. mysqli connector.

1. Your program which uses a MySQL connector receives this error: Client does not support authentication protocol requested by server The account running the program uses caching_sha2_password. Which two resolve this conflict?. A. Upgrade the connector to a version that supports caching_sha2_password. B. Place this in the root directory of your shell account: [mysqld] require_secure_transport=OFF. C. Disable TLS/SSL authentication. D. Change the user account to use mysql_native_password. E. Use blank RSA or SSL certificates.

2. Which two are true of Stored Routines?. A. Cursors must be opened before being accessed. A. Handlers must be declared before conditions. B. Prepared statements must be declared before conditions. C. Variables must be declared before cursors. D. Handlers must be declared before cursors. E. Cursors are only for updating records, not retrieving records.

5. Which two are true about indexes?. A. Secondary index access will always be faster than a table scan. B. Indexes contain rows sorted by key values. C. Indexes are used to enforce unique constraints. D. Index reduce disk space used. E. Indexing all of a table's columns improves performance.

6. A MySQL server has been provided self signed certificates by your corporate Certificate Authority. The server is only accessible from your private network and all name resolution is provided by a private DNS service. Which two statements are true?. A. Self signed certificates provide more trust than those signed by a trusted CA. B. Public trusted CA certificates are more trustworthy than those signed by the corporate CA. C. Public trusted CA certificates and those signed by the corporate CA can provide the same level of technical security. D. Public trusted CA certificates are more technically secure than those signed by the corporate CA. E. Public trusted CA certificates and those signed by the corporate CA provide the same level of trust in the destination host.

7. The employee table includes these columns: e_id INT, e_name VARCHAR(45), dept_id INT, salary INT You must create a stored function, getMaxSalary (), which returns the maximum salary paid for a given department id. Which statement will create the function?. A. CREATE FUNCTION getMaxSalary (v_dept_id INT) RETURNS INT DETERMINISTIC BEGIN DECLARE msalary INT; SELECT MAX(salary) INTO msalary FROM employee WHERE dept_id = v_dept_id; RETURN msalary; END. B. CREATE FUNCTION getMaxSalary (v_dept_id INT) RETURNS INT DECLARE msalary INT; BEGIN END SELECT MAX(salary) INTO msalary FROM employee WHERE dept_id = v_dept_id; getMaxSalary:= msalary; RETURN;. C. CREATE FUNCTION getMaxSalary (v_dept_id INT) RETURNS INT DETERMINISTIC BEGIN DECLARE msalary INT; USE schemaName; SELECT MAX(salary) INTO msalary FROM employee WHERE dept_id = v_dept_id; RETURN msalary END. D. CREATE FUNCTION getMaxSalary(v_dept_id INT) RETURNS CHAR(50) BEGIN SELECT MAX(salary) INTO @m FROM employee WHERE dept_id = v_dept_id; RETURN msalary; END.

8. Examine this statement: DELIMITER // CREATE PROCEDURE get_num_emp() #line 1 BEGIN # line 2 INSERT INTO employee (emp_id, emp_name) VALUES (102, 'John'); # line 3 SELECT COUNT(*) INTO @m FROM employee; # line 4 END; // What is required to create this procedure successfully?. A. user who creates the procedure needing the CREATE and EXECUTE privileges. B. user who creates the procedure needing the CREATE ROUTINE privilege. C. inserting COMMIT: SET @m := 0; before line 4. D. inserting DEFINER 'username'@'localhost' clause into the CREATE PROCEDURE statement. E. inserting USE <database>; before line 3.

9. Examine this bar graph based on columns from the players table Which two statements would generate this bar graph?. A. SELECT Name, Gender, Sport, CONCAT('#', GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;. B. SELECT Name, Gender, Sport, LENGTH (GPA*10, '#') AS GPA_Graph FROM players ORDER BY GPA DESC:. C. SELECT Name, Gender, Sport, RPAD('', GPA*10, '') AS GPA_Graph FROM players ORDER BY GPA DESC;. D. SELECT Name, Gender, Sport, CHAR LENGTH('#', GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;. E. SELECT Name, Gender, Sport, REPEAT('#', GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;.

You must determine the number of non-null dates in the last_login column. Which function call will satisfy this requirement?. A. FOUND_ROWS(). B. COUNT (last_login). C. ROW_COUNT (). D. COUNT(*). E. SUM(last_login). F. DISTINCT (last_login).