SQL Fundamentals Quiz for Students

What is the primary goal of database normalisation?

• To increase data redundancy

• To reduce data redundancy

• To make the database larger

• To decrease data integrity

What does the SQL command `SELECT` do?

• It deletes data from a table

• It updates data in a table

• It retrieves data from a table

• It inserts data into a table

Which SQL clause is used to filter records?

• WHERE

• FROM

• SELECT

• JOIN

What is the correct SQL statement to create a new table named "Students"?

• CREATE TABLE Students;

• CREATE Students TABLE;

• CREATE TABLE Students ();

• CREATE Students;

What is the purpose of the `PRIMARY KEY` constraint in SQL?

• To allow duplicate values in a column

• To uniquely identify each record in a table

• To create a foreign key relationship

• To store large binary data

Which SQL function is used to count the number of rows in a table?

• COUNT()

• SUM()

• AVG()

• MAX()

What is the default value of a column if no value is specified during the insertion of a new record?

• NULL

• 0

• ''

• 1

Which SQL statement is used to update data in a table?

• INSERT INTO

• UPDATE

• DELETE

• SELECT

What is the purpose of the `FOREIGN KEY` constraint in SQL?

• To ensure that all values in a column are unique

• To link two tables together

• To store large text data

• To automatically increment a column value

Which of the following is a numeric data type in SQL?

• CHAR

• DATE

• INTEGER

• TEXT