Question: later versions of mysql support the native json data type for storing json documents. What is a drawback of json columns?

  1. inefficient for storing json documents
  2. cannot be indexed directly
  3. documents cannot be validated when stored in json columns
  4. cannot be normalized

Answer: The correct answer of the above question is Option B:cannot be indexed directly