Oracle MySQL Quiz

Which of the following is the correct way to end a SQL statement?

• .

• :

• ;

• !

Which SQL command is used to create a new database?

• CREATE TABLE

• CREATE DATABASE

• NEW DATABASE

• MAKE DATABASE

Which data type is used to store whole numbers in MySQL?

• VARCHAR

• TEXT

• INT

• FLOAT

What does the NOT NULL constraint do?

• Prevents duplicate values

• Ensures a column cannot have Empty value

• Automatically generates values

• Links tables together

Which clause is used to filter records in SQL?

• SELECT

• WHERE

• ORDER BY

• GROUP BY

Which operator is used to combine multiple conditions in a WHERE clause?

• OR

• AND

• BOTH

• A and B

Which keyword is used to check if a value is within a range?

• BETWEEN

• RANGE

• IN

• LIMIT

Which keyword is used to check if a value matches any value in a list?

• BETWEEN

• IN

• MATCH

• LIKE

Which clause is used to group rows that have the same values?

• ORDER BY

• GROUP BY

• HAVING

• JOIN

Which function returns the number of rows?

• SUM()

• COUNT()

• MAX()

• AVG()