Question: How would you list the full set of tables in the currently selected database?

  1. SELECT \* FROM DATABASE;
  2. SHOW TABLES;
  3. LIST TABLES;
  4. SELECT ALL TABLES;

Answer: The correct answer of the above question is Option B:SHOW TABLES;