Question 91 your developers have created table to

This preview shows page 2 - 5 out of 7 pages.

QUESTION:91Your developers have created table to store some of their program’s data. Afterexamining the slow Query Log, you see that they are using the LIKE operator and40
SUBSTER () functions against a VARCHAR (10000) column quite often. An exampleof the start of one row of data: ‘GREEN01020495888331993-12-10/2…’ What shouldyou do to improve the overall performance?D
QUESTION:92An 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 thedatabase?
41
A

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 7 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture