Font size
WorksheetsMYSQL QUIZ 1
Total questions: 25
Worksheet time: 16mins
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
Update the City column of all records in the Customers table. ______ Customers ___ City = 'Oslo';
(a)
The DELETE statement is used to delete existing records in a table is?
DROP Syntax
REMOVE Syntax
DELETE Syntax
UPDATE Syntax
Delete all the records from the Customers table where the Country value is 'Norway'. ______ ____ Customers _____ Country = ''Norway";
(a)
What is he LIMIT clause is used for?
The LIMIT clause is used to specify the number of records to return.
The LIMIT clause is used to specify the number of records to Show.
The LIMIT clause is used to specify the amount of records to return.
What the function to return the smallest value of the selected column?
MINUS()
MINS()
SMALL()
MIN()
The MAX() function returns the largest value of the selected column.
FALSE
TRUE
The COUNT() function returns the number of rows that matches a specified criterion.
TRUE
FALSE
The AVG() function returns the avengers value of a numeric column.
FALSE
TRUE
The SUM() function returns the total sum of a numeric column.
Maybe True
True
Maybe False
False
Returns all records from both tables is called by
FULL JOIN
JOIN
CROSS JOIN
INNER JOIN
Returns all records from the left table, and the matched records from the right table is called by
RIGHT JOIN
CROSS JOIN
LEFT JOIN
SIDE JOIN
Returns records that have matching values in both tables is called by
INNER JOIN
BOTH JOIN
LEFT JOIN
RIGHT JOIN
RDBMS is stand for?
Relationship Database Management System
Relation Database Management System
Relate Database Management System
Relational Database Management System
MySQL is developed, distributed, and supported by?
MariaDB Corporation
Oracle Corporation
Microfsoft Sql Server
Stikom El Rahma
Select all records where the City column has the value 'Berlin' or 'London'. _____ * FROM Customers _____ City = 'Berlin' __ _____ = '______';
(a)
