Select Database


  1. Which among the following is the correct syntax for showing all tables in the database?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    SHOWS TABLES;


  1. Which command is used to show all tables that are stored in a database?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: E

    None of these



  1. Which statement is used to select a default database?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    MySQL has the facility to use various statements specifically at the database level. For selecting a default database, the keyword or clause used is the ‘USE’ statement.