This Quiz contains totally 25 Questions each carry 1 point for you.
1. Which of the following is the first step in designing a database for a small business?
Identifying tables and relationships
Creating a data dictionary
Normalizing the data
Defining primary keys
Correct!
Wrong!
2. What is the purpose of a primary key in a database table?
It uniquely identifies each row in a table.
It ensures data integrity and enforces uniqueness.
It establishes relationships between tables.
It defines the structure of the table.
Correct!
Wrong!
3. Which normal form eliminates repeating groups in a table?
First normal form (1NF)
Second normal form (2NF)
Third normal form (3NF)
Fourth normal form (4NF)
Correct!
Wrong!
4. Which SQL statement is used to insert data into a table?
SELECT
UPDATE
DELETE
INSERT
Correct!
Wrong!
5. Which SQL clause is used to filter rows based on a condition?
SELECT
WHERE
FROM
GROUP BY
Correct!
Wrong!
6. Which SQL keyword is used to retrieve unique values from a column?
UNIQUE
DISTINCT
GROUP BY
HAVING
Correct!
Wrong!
7. Which SQL statement is used to update existing data in a table?
SELECT
INSERT
UPDATE
ALTER
Correct!
Wrong!
8. Which SQL function is used to calculate the average of a column?
AVG()
SUM()
COUNT()
MAX()
Correct!
Wrong!
9. Which SQL clause is used to sort the result set in ascending or descending order?
ORDER BY
GROUP BY
HAVING
WHERE
Correct!
Wrong!
10. Which SQL statement is used to delete data from a table?
SELECT
INSERT
UPDATE
DELETE
Correct!
Wrong!
11. Which type of join returns only the matching rows between two tables?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Correct!
Wrong!
12. Which SQL function is used to find the highest value in a column?
AVG()
SUM()
COUNT()
MAX()
Correct!
Wrong!
13. Which SQL statement is used to add a new column to an existing table?
SELECT
INSERT
UPDATE
ALTER
Correct!
Wrong!
14. Which SQL clause is used to combine multiple conditions in a WHERE clause?
OR
AND
NOT
XOR
Correct!
Wrong!
15. Which SQL statement is used to create a new table?
SELECT
INSERT
UPDATE
CREATE
Correct!
Wrong!
16. Which SQL keyword is used to retrieve rows from multiple tables?
UNION
JOIN
COMBINE
MERGE
Correct!
Wrong!
17. Which SQL function is used to count the number of rows in a table?
AVG()
SUM()
COUNT()
MAX()
Correct!
Wrong!
18. Which SQL clause is used to limit the number of rows returned by a query?
LIMIT
OFFSET
TOP
WHERE
Correct!
Wrong!
19. Which SQL statement is used to rename a table?
SELECT
INSERT
UPDATE
ALTER
Correct!
Wrong!
20. Which SQL operator is used to check if a value matches a pattern?
LIKE
IN
BETWEEN
EXISTS
Correct!
Wrong!
21. Which SQL function is used to convert a value to uppercase?
UPPER()
LOWER()
INITCAP()
UCASE()
Correct!
Wrong!
22. Which SQL clause is used to group rows based on a column?
GROUP BY
ORDER BY
HAVING
WHERE
Correct!
Wrong!
23. Which SQL statement is used to add a constraint to a table column?
SELECT
INSERT
UPDATE
ALTER
Correct!
Wrong!
24. Which SQL function is used to concatenate two or more strings?
CONCAT()
JOIN()
MERGE()
ADD()
Correct!
Wrong!
25. Which SQL clause is used to filter aggregated results in a query?
GROUP BY
ORDER BY
HAVING
WHERE
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
MYSQL Practice Project – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...