SQL Summative Test (G10 - ICT 1)

Which of the following is the correct syntax for selecting all records from a table named "Customers"?

• SELECT * IN Customers;
• SELECT ALL FROM Customers;
• SELECT * FROM Customers;
• SELECT ALL IN Customers;

Which of the following is the correct syntax for selecting only distinct values from the "Country" column in the "Employees" table?

• SELECT UNIQUE Country FROM Employees;
• SELECT DIFFERENT Country FROM Employees;
• SELECT DISTINCT Country FROM Employees;
• SELECT UNIQUE VALUES Country FROM Employees;

Which of the following is the correct syntax for selecting all records from a table named "Students" where the value of the "Age" column is greater than or equal to 18?

• SELECT * FROM Students WHERE Age >= 18;
• SELECT * FROM Students WHERE Age => 18;
• SELECT * FROM Students WHERE Age > 18;
• SELECT * FROM Students WHERE Age 18;

Which of the following is the correct syntax for selecting all records from a table named "Products" where the value of the "Price" column is between 10 and 20, inclusive?

• SELECT * FROM Products WHERE Price BETWEEN 10 AND 20;
• SELECT * FROM Products WHERE Price IN (10, 20);
• SELECT * FROM Products WHERE Price > 10 AND Price < 20;
• SELECT * FROM Products WHERE Price BETWEEN 20 AND 10;

Which of the following is the correct syntax for selecting all records from a table named "Suppliers" where the value of the "CompanyName" column starts with "A"?

• SELECT * FROM Suppliers WHERE CompanyName LIKE '%A';
• SELECT * FROM Suppliers WHERE CompanyName = 'A';
• SELECT * FROM Suppliers WHERE CompanyName IN ('A');
• SELECT * FROM Suppliers WHERE CompanyName LIKE 'A%';

Which of the following is the correct syntax for updating the value of the "City" column to "Seattle" for all records in a table named "Employees"?

• UPDATE Employees SET 'Seattle' WHERE City;
• UPDATE Employees SET City WHERE 'Seattle';
• UPDATE Employees 'Seattle' WHERE City;
• UPDATE Employees SET City = 'Seattle';

Which of the following is the correct syntax for deleting all records from a table named "Students"?

• DELETE Students WHERE Records=All;
• TRUNCATE TABLE Students;
• TRUNCATE Students;
• DELETE FROM Students;

Which of the following is the correct syntax for selecting the top 5 records from a table named "Customers"?

• SELECT * FROM TOP 5 Customers ;
• SELECT * FROM Customers WHERE ROWNUM <= 5;
• SELECT * FROM Customers FETCH FIRST 5 ROWS ONLY;
• SELECT * FROM Customers LIMIT 5;

Which of the following is the correct syntax for selecting the minimum value of the "Price" column in a table named "Products"?

• SELECT MIN Price FROM Products;
• SELECT MINIMUM(Price) FROM Products;
• SELECT MIN(Price) FROM Products;
• SELECT MINIMUM Price FROM Products;

Which of the following is the correct syntax for counting the number of records in a table named "Employees"?

• SELECT COUNT FROM Employees;
• SELECT NUMBER OF RECORDS FROM Employees;
• SELECT COUNT(*) FROM Employees;
• SELECT LENGTH FROM Employees;