MYSQL QUIZ 1

MySQL is a widely used relational database management system (RDBMS)

MySQL is free and open-source.

When MYSQL first release?

Insert the missing statement to get all the columns from the Customers table. (a)   * FROM Customers;

Write a statement that will select the City column from the Customers table. ______ ____ ____ Customers;

(a)  

Select all records where the CustomerID column has the value 32. SELECT * FROM Customers _____ CustomerID _ __ ;

(a)  

Select all records from the Customers table, sort the result reversed alphabetically by the column City.

Select all records from the Customers table, sort the result alphabetically, first by the column Country, then, by the column City.

What is a NULL Value?

The UPDATE statement is used to modify the existing records in a table is?