MYSQL QUIZ 1

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

• TRUE

• DOUBTFUL

• FALSE

MySQL is free and open-source.

• DOUBTFUL

• TRUE

• FALSE

When MYSQL first release?

• 1998

• 1997

• 1996

• 1995

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 * FROM Customers ORDER BY City ASC;

• SELECT * FROM Customers ORDER BY CIty DESC;

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

• SELECT * FROM Customers ORDER BY Country, City;

• SELECT * FROM Customers ORDER BY City, Country;

What is a NULL Value?

• A field with a NULL value is a field with 0 value.

• A field with a NULL value is a field wit value.

• A field with a NULL value is a field with no value.

• A field with a NULL value is a field with INULL DARATISTA

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

• SELECT Syntax

• INSERT INTO

• DELETE Syntax

• UPDATE Syntax