1. Explain MySQL architecture. – The front layer takes care of network connections and security authentications the middle layer does the SQL query parsing and then the query is handled off to the

Which will be faster out of these two queries – one with OR or one with INWhere does MyISAM cache table recordsWhich will be faster out of queries with explicit INNER JOIN and implicit oneIs InnoDB