Question: You need to make an exact copy of a table, with all columns and indexes. How can you get all of the information needed to accomplish this?

  1. create table
  2. clone table
  3. insert into
  4. show create table

Answer: The correct answer of the above question is Option D:show create table