MySQL Practice Test 9

1. Which string function returns the index of the first occurrence of substring?

2. The MySQL double dashed comment style is the same as the SQL standard.

3. “CREATE VIEW …” command is used to create which type of table in Mysql?

4. Multiple statement execution is disabled by default.

5. When linking to a static MySQL C client library, the client library and the client application can use different compiler options.

6. Is there any error in executing the following MySQL command?

SELECT emp_id, ‘ACTIVE’,
       emp_id * 3.145,
       UPPER (lname)
       FROM Employee;

7. What sets up an association between one or more MyISAM tables and the named key cache?

8. What is the exec_stmt_ssl written in?

9. The statement that constructs a branching flow-control construct is _____________

10. What is the need of “column Aliases” in “SELECT” clause?