NEW
Font size
Worksheets5155495A332053514C
Total questions: 10
Worksheet time: 6mins
What does Data Manipulation Language (DML) refer to in SQL?
Commands used to create and delete database structures.
Commands used to manage data stored inside database tables.
Software used to install the MySQL server.
Rules for naming variables in a PHP script.
Which core DML command is used to add new records to a table?
SELECT.
UPDATE.
INSERT.
DELETE.
What is a critical requirement when using the UPDATE or DELETE commands to ensure only specific records are affected?
An ORDER BY clause.
A WHERE clause.
The LIMIT keyword.
A semicolon at the beginning of the line.
When inserting records, what must the values match regarding the specified columns?
Only the data type, regardless of order.
Only the order, regardless of data type.
Both the order and the data type.
Neither; MySQL automatically sorts the values.
Which clause is used to organize query results in ascending (ASC) or descending (DESC) order?
WHERE.
GROUP BY.
ORDER BY.
SORT BY.
If you want to retrieve exactly 5 records from a table, which clause should you use?
LIMIT.
FILTER.
STOP.
TOP.
In pattern matching with the LIKE keyword, what does the % wildcard represent?
Exactly one character.
Any number of characters.
Only numerical characters.
The end of a semicolon.
Which operator allows you to check if a value exists within a specific list of options, such as city IN ('Pasig', 'Taguig')?
BETWEEN.
OR.
IN.
LIKE.
What is the purpose of using "Aliases" (the AS keyword) in a SELECT statement?
To permanently rename the columns in the database.
To rename columns in the output for clearer presentation and readability.
To hide data from unauthorized users.
To combine two tables into one.
Which logical operator is used to ensure that a record is retrieved only if both specified conditions are true?
OR.
NOT.
AND.
BOTH.
