Q1. You started a MySQL command –line session with sq1_ mode (empty), and created the person table with the structure:

Mysql> DESC person;

You issue:

INSERT INTO person VALUES (‘casper’, ‘undefined’) What is the effect?

A. ‘Casper’ and ‘ undefined values are inserted into the ‘name’ and gender’ column.

B. The server returns an error indicating that ‘undefined’ cannot be inserted into a column of ENUM type

C. The server returns a warning and the empty string is inserted to the ‘gender’ column.

D. The server returns a warning and the first specified value ,”male” is inserted to the gender column.

View Answer

Q2. Which statement correctly demonstrates using a subquery as a scalar expression?

A. SELECT (

SELECT SUM (population) FROM Country

SELECT SUM (population) FROM Country

WHERE Code =’CAN’

)

B. SELECT SUM (population) FROM Country

WHERE Code =”USA”

+ (SELECT SUM (population) FROM Country

WHERE Code =.’CAN’

)

C. SELECT

(SELECT SUM (population) FROM Country

WHERE Code =’USA’

FROM country WHERE Code= ‘CAN’

)

D. (SELECT SUM (population) FROM Country

WHERE Code =”USA’

View Answer

Q3. You want to compare all columns of table A to columns with matching names in table B. You want to select the rows where those have the same values on both tables.

Which query accomplishes this?

A. SELECT * FROM tableA. tableB

B. SELECT * FROM tableA JOIN tableB

C. SELECT * FROM table A INNER JOIN tableB

D. SELECT * FROM tableA NATURAL JOIN tableB

E. SELECT & FROM tableA STRAIGHT JOIN tableB

View Answer

Q4. 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)

View Answer

Q5. Which three are valid identifiers for the user table in the mysq1 database?

A. myssq1. user

B. ‘mysq1. user’

C. ‘mysq1’. ‘user’

D. Mysq1. ‘user’

E. ‘’mysq1. User’’

View Answer

Q6. 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

View Answer

Q7. Which three database objects have non-case-sensitive names on all operating system?

A. Table

B. Column

C. Index

D. Stored procedure

E. Trigger

View Answer

Q8. Examine the structure and content of the MemberLocation table:

You want to have the field location returned in all letters (example: BERLIN). Which query would you use?

A. SELECT UPPER (Location) as location FROM MemberLocation

B. SELECT UPPER (BINARY location) as location FROM MemberLocation

C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation

D. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation

View Answer

Q9. Which two queries return a value of NULL?

A. SELECT NULL =NULL

B. SELECT NULL is NULL

C. SELECT NULL <= > NULL

D. SELECT 1 > NULL

E. SELECT COUNT (NULL);

View Answer

Q10. Which two keywords cannot be used in multi-table deletes?

A. USING

B. ORDER BY

C. LIMIT

D. IGNORE

E. JOIN

View Answer