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

University

•

30 Qs

Similar activities

Inside the factory - Biscuits

1st Grade - University

•

25 Qs

Communication Systems, 18P4PH11

University

•

25 Qs

Chapter 10 Vocabulary Quiz

KG - University

•

25 Qs

DPM2023 - BUSINESS PRESENTATION SKILLS (TEST 1)

University

•

25 Qs

SELECTION - HRM

University

•

25 Qs

Manufacturing of sterile and non sterile products

University

•

25 Qs

Chapter 1 - Quiz 2

University

•

25 Qs

Introduction to Economics (2)

University

•

25 Qs

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

Image Analysis 1B Class 9: Bootcamp Review

Quiz

•

University

25 questions

Present Vegetable Dishes Quiz

Quiz

•

10th Grade - University

25 questions

REVIEW

Quiz

•

University

25 questions

Innovation Applied Learning Challenge - G7

Quiz

•

University

25 questions

BJT

Quiz

•

University

25 questions

PLTW - Section 1 Practice Test

Quiz

•

7th Grade - University

25 questions

Basics of Accounting

Quiz

•

University

25 questions

Basics of Robotics

Quiz

•

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