Question 91 your developers have created table to

QUESTION: 91
Your developers have created table to store some of their program’s data. After
examining the slow Query Log, you see that they are using the LIKE operator and
40

SUBSTER () functions against a VARCHAR (10000) column quite often. An example
of the start of one row of data: ‘GREEN01020495888331993-12-10/2…’ What should
you do to improve the overall performance?
D
QUESTION: 92
An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE ‘%connect%’;
8 rows in set (0.00 sec) A look at the user privileges shows:
GRANT… TO ‘bob’@’%, example.com’ WITH MAX_USER_CONNECTIONS 0;
GRANT… TO ‘key’@’%, example.com’ WITH MAX_USER_CONNECTIONS 1;
GRANT… TO ‘joe’@’%, example.com’ WITH MAX_USER_CONNECTIONS 50;
What is a valid explanation for why one of the users is unable to connect to the
database?
41

A