How do you find the maximum value in a column named `salary`?

SELECT MAX(salary) FROM employees;

SELECT MAXIMUM(salary) FROM employees;

SELECT HIGHEST(salary) FROM employees;

SELECT TOP(salary) FROM employees;

How do you add a new column named `age` to an existing table `people`?

ALTER TABLE people ADD COLUMN age;

How do you delete records from the `orders` table where the `order_date` is before '2023-01-01'?

DELETE FROM orders WHERE order_date

DROP FROM orders WHERE order_date

REMOVE FROM orders WHERE order_date

ERASE FROM orders WHERE order_date

How do you update the `salary` of employees to 50000 where the `department` is 'IT'?

UPDATE employees SET salary = 50000 WHERE department = 'IT';

MODIFY employees SET salary = 50000 WHERE department = 'IT';

CHANGE employees SET salary = 50000 WHERE department = 'IT';

ALTER employees SET salary = 50000 WHERE department = 'IT';

What is the purpose of the JOIN clause in SQL?

To combine columns from different tables

How do you select data from two tables named `customers` and `orders` where `customers.customer_id` matches `orders.customer_id`?

SELECT * FROM customers JOIN orders ON customers.customer_id = orders.customer_id;

SELECT * FROM customers AND orders WHERE customers.customer_id = orders.customer_id;

SELECT * FROM customers, orders WHERE customers.customer_id = orders.customer_id;

SELECT * FROM customers UNION orders WHERE customers.customer_id = orders.customer_id;

How do you rename a column named `old_name` to `new_name` in the table `users`?

ALTER TABLE users RENAME COLUMN old_name TO new_name;

MODIFY TABLE users CHANGE COLUMN old_name TO new_name;

CHANGE TABLE users RENAME COLUMN old_name TO new_name;

ALTER TABLE users MODIFY COLUMN old_name TO new_name;

What is a primary key?

A column that uniquely identifies each row in a table

A column that contains duplicate values

A column that references another table

How do you create a new table named `employees` with columns `id`, `name`, and `department`?

CREATE TABLE employees(id INT, name VARCHAR(100), department VARCHAR(100));

NEW TABLE employees(id INT, name VARCHAR(100), department VARCHAR(100));

INSERT TABLE employees(id INT, name VARCHAR(100), department VARCHAR(100));

BUILD TABLE employees(id INT, name VARCHAR(100), department VARCHAR(100));

How do you select all records from the `students` table where the `lastname` starts with 'A'?

SELECT * FROM students WHERE lastname LIKE 'A%';

SELECT * FROM students WHERE lastname = 'A';

SELECT * FROM students WHERE lastname LIKE '%A%';

SELECT * FROM students WHERE lastname STARTS WITH 'A';

How do you retrieve all records from the `products` table where the `price` is between 100 and 500?

SELECT * FROM products WHERE price BETWEEN 100 AND 500;

SELECT * FROM products WHERE price > 100 AND price

SELECT * FROM products WHERE price >= 100 AND price

SELECT * FROM products WHERE price WITHIN 100 AND 500;

How do you add a foreign key constraint to an existing table named `orders`?

ALTER TABLE orders ADD CONSTRAINT fk_orders FOREIGN KEY(column_name) REFERENCES other_table(column_name);

ALTER TABLE orders ADD CONSTRAINT FOREIGN KEY;

ALTER TABLE orders ADD FOREIGN KEY;

ALTER TABLE orders ADD CONSTRAINT fk_orders FOREIGN KEY;

How do you retrieve the names of all students who have 'John' as their firstname?

SELECT * FROM students WHERE firstname = 'John';

SELECT * FROM students WHERE firstname LIKE 'John';

SELECT * FROM students WHERE firstname = 'John';

SELECT * FROM students WHERE firstname IS 'John';

How do you remove duplicate rows from a result set?

SELECT ALL * FROM table EXCEPT DUPLICATES;

SQL Multiple Choice Questions

Quiz

•

Other

•

University

•

Practice Problem

•

Medium

EC M

Used 1+ times

FREE Resource

SELECT * FROM customers ORDER DESC lastname;

SELECT * FROM customers SORT DESC lastname;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

Welding 141

Quiz

•

University

30 questions

SizzleBurger Trivia

Quiz

•

University

25 questions

Management 2

Quiz

•

University

25 questions

แบบทดสอบบทที่ 1

Quiz

•

University

25 questions

QUIS TPI: INSTRUMEN PENELITIAN - TRO 16B

Quiz

•

University

25 questions

QBT Trivia Night #3

Quiz

•

University

25 questions

Excel

Quiz

•

12th Grade - University

28 questions

MAWD 1.01 B

Quiz

•

KG - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Other

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

5 questions

Poetry Interpretation

Interactive video

•

4th Grade - University

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

15 questions

Review1

Quiz

•

University

15 questions

Pre1

Quiz

•

University

SQL Multiple Choice Questions

30 questions

What does SQL stand for?

Which SQL statement is used to retrieve data from a database?

How do you select all columns from a table named `students`?

Which clause is used to filter records in SQL?

How do you retrieve distinct values from a column named `city` in the `employees` table?

What keyword is used to sort the results in ascending order?

How do you sort the `customers` table by the `lastname` column in descending order?

Which SQL function is used to count the number of rows in a table?

How do you find the maximum value in a column named `salary`?

What clause is used to group rows that have the same values?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other