Final Quiz Async 3

What is the correct syntax for inserting a single row into a table named employees?

• INSERT INTO employees (id, name, salary) VALUES (1, 'John', 50000);
  
  

• INSERT employees VALUES (1, 'John', 50000);
  

• ADD TO employees (id, name, salary) (1, 'John', 50000);

• INSERT ROW employees (id, name, salary) (1, 'John', 50000);

Which keyword is used to insert multiple rows in a single INSERT statement?

• MANY ROWS

• BATCH INSERT

• MULTIPLE VALUES

• 1. Separate VALUES clauses with commas

Which SQL statement retrieves all columns from a table named customers?

• SELECT ALL FROM customers;

• SELECT * FROM customers;  

• GET * FROM customers;

• FETCH ALL customers;

How do you select only the name and email columns from a table users?

• SELECT name, email FROM users;  

• SELECT (name, email) FROM users;

• GET name AND email FROM users;

• SELECT COLUMNS name, email FROM users;

Which clause filters records in a SELECT query?

• FILTER BY

• HAVING

• WHERE

• CONDITION

What is the correct syntax to find employees with a salary greater than 50000?

• SELECT * FROM employees WHERE salary > 50000;  

• SELECT * FROM employees IF salary > 50000;

• SELECT * FROM employees HAVING salary > 50000;

• SELECT * FROM employees CHECK salary > 50000;

How do you retrieve records where age is greater than 30 and salary is less than 60000?

• SELECT * FROM employees WHERE age > 30 OR salary < 60000;

• SELECT * FROM employees WHERE age > 30 AND salary < 60000;  

• SELECT * FROM employees WHERE age > 30, salary < 60000;
  
  

• SELECT * FROM employees WHERE age > 30 && salary < 60000;

Which query finds customers from either 'New York' or 'Los Angeles'?

• SELECT * FROM customers WHERE city = 'New York' AND city = 'Los Angeles';

• SELECT * FROM customers WHERE city IN ('New York', 'Los Angeles');

• SELECT * FROM customers WHERE city = 'New York' OR city = 'Los Angeles';

• Both b and c  

Which operator checks if a value is within a specified range?

• IN

• LIKE

• BETWEEN  

• EXISTS

What does the LIKE operator with % do?

• Matches exact values

• Matches any sequence of characters  

• Matches a single character

• Performs arithmetic operations