Font size
WorksheetsMySQL
Total questions: 20
Worksheet time: 7mins
What does SQL stand for?
Structured Query Language
Structured Question Language
Strong Question Language
None of the above
Which of the following can add a row to a table?
Add
Insert
Update
Alter
What does DML stand for?
Data Manipulation Language
Data Modeling Language
Data Markup Language
Data Migration Language
Which of the following is not a keyword of MYSQL?
Select
Top
Group
Insert
Which of the following query is correct to get Current Date from Query?
A. SELECT DATE ( NOW() ) as today;
B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;
A. SELECT DATE ( NOW() ) as today;
B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;
Both A and B
None
Which of the following is not a valid aggregate function?
COUNT
MIN
COMPUTE
MAX
SQL is not case sensitive. SELECT is the same as select.
TRUE
FALSE
The _________ statement is used to delete a table.
DROP TABLE
DELETE TABLE
DEL TABLE
REMOVE TABLE
Which one of the following sorts rows in SQL?
SORT BY
ALIGN BY
GROUP BY
ORDER BY
The SQL statement that queries or reads data from a table is __________ .
USE
SELECT
READ
QUERY
Which SQL statement is used to return only different values?
SELECT DISTINCT
SELECT UNIQUE
SELECT DIFF
SELECT DIFFERENT
With SQL, how do you select all the columns from a table named "Persons"?
SELECT * FROM Persons
SELECT Persons
SELECT [all] FROM Persons
SELECT *.Persons
In a LIKE clause, you can ask for any 6 letter value by writing
LIKE ______ (that's six underscore characters)
LIKE ...... (that's six dots)
LIKE .{6}
LIKE ??????
Which SQL statement is used to update data in a database?
MODIFY
ALTER
SAVE
UPDATE
SQL can be used to:
Create database structures only.
Query database data only.
Modify database data only.
All of the above can be done by SQL.
The SQL keyword BETWEEN is used:
For ranges.
To limit the columns displayed.
As a wildcard.
None of the above
Which statement is used to delete an existing row from the table?
DELETE
WHERE
MODIFY
None of these
Which clause is used to “Filters out unwanted data”?
FROM
SELECT
ORDER BY
WHERE
Which is the default order of sort in ORDER BY clause?
Ascending
Descending
Write a query to display first_name and last_name of all employees who have their first_name starting with 'A'.
Select first_name from employess where first_name LIKE '%A';
Select first_name from employess where first_name LIKE "'A'%";
Select first_name from employess where first_name LIKE 'A%';
Select first_name from employess where first_name LIKE '%A%';
