Identity two ways to configure a PHP application to use the UTF8 character set.
A. mysqli: :query (`'SET NAMES utfs'');
B. mysqli : :set_charset (`utf8')
C. spdo = new PDO (`'mysql:host=localhost;dbname=test;charset=utfs'', user'', `'pass'');
D. PDO: :set_charset(`'utf8'')
You have two test tables:
Code_innodb as InnoDB engine
Code_ myisam as MYISAM engine
The tables have the same structure:
The tables have one row of data:
You execute an INSERT statement on both code_myisam tables and receive duplicate key errors: mysql> INSERT INTO code_innodb VALUES (1, `Alpha'), (2, `Beta'), (3, `charlie,),(4, `Delta'); ERROR 1062 (23000): Duplicate entry `3' for key `PRIMARY'
Mysql> INSERT INTO code_myisam VALUES (1, `Alpha'), (2, `Beta'), (3, `charlie'), (4, `Delta'); ERROR 1062 (23000); Duplicate entry `3' for key `PRIMARY'
What is the expected output of the SELECT statements?
A. Option A
B. Option B
C. Option C
D. Option D
Using the MYSQL command line client you have received the error "Lost connection to MYSQL server query"
Which three are possible causes of the error?
A. The MYSQL server stopped working during query execution.
B. The network connection was interrupted during query execution.
C. The connection that issued the query was killed.
D. The client connection stayed idle for longer than interactive timeout seconds and was closed.
E. The client sent an erroneous query to the server causing the connection to be closed.
F. The server interrupted client connection after max-connect-errors was achieved.
Which two PHP modules provide APIs for developing MYSQL applications?
A. Mysqli
B. Mysqlnd
C. PDO
D. PDO_mysql
Inspect the query:
Mysql> SELECT count (emp_no) FROM titles WHERE title = `senior staff';
How can this query be optimized?
A. The query need an index on the emp-no column.
B. The query cannot be optimized as an index is already used.
C. The query needs an index that includes the title column.
D. The query cannot be optimized as count () must read all rows.
Inspect the CREATE TABLE below:
Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB; Query Ok, 0 rows affected, 2
warnings (0.11 sec)
Mysql> SHOW WARNINGS;
Which two is true connecting the meaning of the warnings?
A. The InnoDB storage engine was disabled during server startup.
B. Global variable skip _innodb was set to ON after the server had started.
C. The default storage engine MYISAM was used for the table created.
D. MYSQL server was not started with the option default storage engine=InnoDB
E. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB
You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN SELECT * FROM employees1 UNION ALL SELECT * FROM employees2;
What is the result?
A. An error is produced because you cannot create a TEMPORARY TABLE with a UNION.
B. The employees common to both tables exist in employees MAIN.
C. A unique list of employees exist in employeesMAIN.
D. All rows from both tables exist in employeesMAIN.
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)
You have two lists of values to correlate.
Which query lists all names in colors1 and how many total matches are there in colors2?
A. SELECT colors1 .name.count (colors2.name) FROM colors1. Colors2 WHERE Colors1. Name = (SELECT DISTINCT name FROM colors2 WHERE colors1.name=colors2.name) GROUP BY colorse1.name,
B. SELECT colors1.name, count(colorse2. Name) FROM colorse1 .name =colors2.name WHERE colors1. Name =colors2.name GROUP BY colors1.name,
C. SELECT colors1. Name count (colors2.name) FROM colors1 INNER JOIN colors2 on colors1. Name =colors2. Name GROUP BY colors1 .name;
D. SELECT colors1.name, count (colors2.name) FROM JOIN colors2 on colors1 .name =colors2.name GROUP BY colors1.name;
E. SELECT colors1.name, count (colors2.name) FROM colors1 RIGHT JOIN colors1 on colors1 .name =colors2.name GROUP BY colors1.name;
A MySQL command- line client is started with safe updates disabled. Mysql - -safe updates=0
What happens when you execute an UPDATE statement without a WHERE clause?
A. Results in an error
B. Updates every row in the specified table(s)
C. Results in - -safe-updates being enabled automatically
D. Causes a syntax error
