SQL: SELECT, INSERT, UPDATE, DELETE

Which SQL statement would you use to display all the records from a table called Students?

• SHOW * FROM Students;

• SELECT ALL FROM Students;

• SELECT * FROM Students;

• DISPLAY ALL FROM Students;

What is the purpose of the INSERT statement in SQL?

• To add new data to a table

• To change existing data in a table

• To delete data from a table

• To retrieve data from a table

What is the correct syntax to change a student’s grade to B in a table called Results where the studentID is 101?

• UPDATE Results SET grade = "B";

• UPDATE Results SET grade = "B" WHERE studentID = 101;

• CHANGE grade TO "B" IN Results;

• SET Results.grade = "B" FOR studentID = 101;

Which of the following would delete all records from the table Books?

• DELETE Books;

• REMOVE FROM Books;

• DELETE * FROM Books;

• DELETE FROM Books;

What is the purpose of a PRIMARY KEY in a database?

• To link two tables together

• To uniquely identify each record in a table

• To store multiple values in a single field

• To count the number of rows in a table

In a relational database, what does a FOREIGN KEY do?

• Ensures all data is unique in a table

• Links a table to another table using a field from the other table

• Prevents data from being updated

• Stores large amounts of text data

Which of the following is the correct data type to store a price like £15.99 in a database?

• INTEGER

• TEXT

• REAL

• BOOLEAN

In a database, what is the difference between an entity and an attribute?

• An entity is a single piece of data, and an attribute is a whole table

• An entity is a table, and an attribute is a column in the table

• An entity is a column, and an attribute is a row in a table

• An entity is a single record, and an attribute is the database itself

Which SQL statement would return the name and email of students who scored more than 80 in a table called Scores?

• SELECT name, email FROM Scores WHERE score >= 80;

• SHOW name AND email FROM Scores WHERE score > 80;

• SELECT name, email FROM Scores WHERE score > 80;

• FILTER name, email IN Scores BY score > 80;

A school database has two tables: Students and Courses. The Courses table has a field called studentID. What is the likely purpose of this field?

• To uniquely identify each course

• To store the name of the course

• To link the Courses table to the Students table

• To record the total number of courses