MySQL Database
Q) Let’s consider the database table City from the world MySQL database. What are the correct SQL statements to view the table columns and settings? a) DESC City; b) VIEW City; c) DESCRIBE City; d) SHOW City; Choose the correct options. Answer Explanation The options b and d are NOT correct. The statements are not […]
Q) What is the statement to list the available MySQL databases? a) LIST DATABASES; b) SHOW DATABASES; c) SHOW DATABASES: d) SHOW DATABASES \G Choose all the correct options. Explanation Let’s understand why some options are incorrect and the then learn the correct options and reasons for them. Incorrect Options Options a) and c) are […]
Overview A Relational Database Management System( RDBMS) organizes and stores information in the form to tables. The Relational model and store information about real world things in a database table. Database Table A table is an ordered collection of one or more columns and an unordered collection of zero or more rows. Each column in […]
