SQL Questions Quiz

What SQL statement is used to create a new table called 'cars' with the columns 'brand' and 'model'?

• CREATE DATABASE cars (brand VARCHAR(255), model VARCHAR(255));

• CREATE TABLE cars (brand VARCHAR(255), model VARCHAR(255));

• CREATE cars TABLE (brand VARCHAR(255), model VARCHAR(255));

• CREATE NEW TABLE cars (brand VARCHAR(255), model VARCHAR(255));

How would you select all columns from the 'customers' table?

• SELECT all FROM customers;

• SELECT * FROM customers;

• SELECT customers FROM *;

• SELECT ALL COLUMNS FROM customers;

What clause is used to filter the results of a query in PostgreSQL?

• ORDER BY

• GROUP BY

• WHERE

• HAVING

How would you order the results of the 'products' table by the 'price' field from lowest to highest?

• SELECT * FROM products ORDER BY price DESC;

• SELECT * FROM products ORDER BY price ASC;

• SELECT * FROM products SORT BY price;

• SELECT * FROM products GROUP BY price;

What operator is used to compare if a value is within a specific set of values?

• BETWEEN

• LIKE

• IN

• EXISTS

What is the aggregation function that returns the total number of rows in a result set?

• SUM()

• COUNT()

• AVG()

• TOTAL()

What SQL statement is used to delete a table called 'orders'?

• DELETE TABLE orders;

• DROP TABLE orders;

• REMOVE TABLE orders;

• TRUNCATE TABLE orders;

How would you insert a new record into the 'employees' table with the values 'John Doe' for 'name' and 'Manager' for 'position'?

• INSERT INTO employees (name, position) VALUES ('John Doe', 'Manager');

• ADD INTO employees (name, position) VALUES ('John Doe', 'Manager');

• INSERT INTO employees VALUES ('John Doe', 'Manager');

• INSERT employees (name, position) VALUES ('John Doe', 'Manager');

What SQL statement is used to update the 'salary' field to 50000 in the 'staff' table for the employee with 'id' 3?

• MODIFY staff SET salary = 50000 WHERE id = 3;

• UPDATE staff SET salary = 50000 WHERE id = 3;

• CHANGE staff SET salary = 50000 WHERE id = 3;

• SET salary = 50000 IN staff WHERE id = 3;

How would you select the records from the 'orders' table where the order date ('order_date') is between '2023-01-01' and '2023-12-31'?

• SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

• SELECT * FROM orders WHERE order_date > '2023-01-01' AND order_date < '2023-12-31';

• SELECT * FROM orders WHERE order_date IN ('2023-01-01', '2023-12-31');

• SELECT * FROM orders WHERE order_date = '2023-01-01' TO '2023-12-31';