Understanding Records and SQL Queries

What is a record in the context of databases?

• A single piece of data

• A collection of related fields

• A type of database

• A programming language

Which of the following is an example of a record type?

• Integer

• String

• Employee

• Boolean

What does the SQL SELECT statement do?

• Deletes data from a database

• Updates data in a database

• Retrieves data from a database

• Inserts data into a database

Which SQL keyword is used to filter records?

• ORDER BY

• WHERE

• GROUP BY

• JOIN

In SQL, how would you select all columns from a table named "Students"?

• SELECT * FROM Students;

• SELECT ALL FROM Students;

• SELECT COLUMNS FROM Students;

• SELECT FIELDS FROM Students;

What is the purpose of the WHERE clause in an SQL statement?

• To sort the results

• To filter the results

• To group the results

• To join tables

Which of the following SQL statements will select all records from the "Employees" table where the "Department" is "Sales"?

• SELECT * FROM Employees WHERE Department = 'Sales';

• SELECT * FROM Employees WHERE Department IS 'Sales';

• SELECT * FROM Employees WHERE Department LIKE 'Sales';

• SELECT * FROM Employees WHERE Department IN 'Sales';

What is a field in the context of a database record?

• A collection of records

• A single piece of data within a record

• A type of database

• A programming language

Which SQL statement is used to select only distinct values?

• SELECT UNIQUE

• SELECT DISTINCT

• SELECT DIFFERENT

• SELECT VARIED

How would you select the "Name" and "Age" columns from a table called "Users"?

• SELECT Name, Age FROM Users;

• SELECT Name AND Age FROM Users;

• SELECT Name OR Age FROM Users;

• SELECT Name + Age FROM Users;