What does the following SQL query do: SELECT MIN(dateOrdered) FROM orders?

Finds the earliest date in the dateOrdered column

Counts the number of dates in the dateOrdered column

Finds the latest date in the dateOrdered column

Sums up all the dates in the dateOrdered column

What does the AVG function do in SQL?

Calculates the average of values

Which of the following SQL statements correctly uses the COUNT function to count all rows in a table called employees?

SELECT COUNT(*) FROM employees;

SELECT COUNT(NULL) FROM employees;

SELECT COUNT(DISTINCT employee_id) FROM employees;

SELECT COUNT(employee_id) FROM employees;

Which of the following aggregate functions will return the highest value of a column named salary in a table named employees? (Select all that apply)

SELECT MAX(salary) FROM employees;

SELECT MAX(salary) AS highest_salary FROM employees;

SELECT MIN(salary) FROM employees;

SELECT AVG(salary) FROM employees;

What is the result of the following SQL query? SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 5;

Counts employees in each department and returns only departments with more than 5 employees.

Returns an error because HAVING cannot be used with COUNT(*).

Returns the count of all departments with exactly 5 employees.

Counts all employees in the database.

Which SQL statement correctly finds the average price of all products in the products table, excluding any rows where the price column is NULL?

SELECT AVG(price) FROM products WHERE price IS NOT NULL;

SELECT AVG(price) WHERE price IS NOT NULL FROM products;

SELECT AVG(price) FROM products;

SELECT AVG(price) FROM products WHERE price IS NULL;

What does a column in a relational model represent?

A unique identifier for each row

A specific attribute of the table's entity type

What is a potential issue with storing all information in a single table?

It would contain duplicate data

It would require less maintenance

What is the first step in the normalization process?

Achieving First Normal Form (1NF)

Achieving Fourth Normal Form (4NF)

Achieving Second Normal Form (2NF)

Achieving Third Normal Form (3NF)

What happens if the number of columns listed in an INSERT statement does not match the number of values provided?

a) The database will assign default values

b) The values will be filled in randomly

c) The extra columns will be ignored

What happens when you use the DELETE statement without a WHERE clause?

The command will produce an error

In an UPDATE statement, what is the purpose of the WHERE clause?

To specify which rows should be updated

To sort the data before updating

To limit the number of columns updated

To check for foreign key constraints

What happens if you try to insert a row with a foreign key that does not exist in the parent table?

The row will be inserted with a NULL value for the foreign key

The insertion will succeed, but with a warning

The row will be inserted, but the foreign key will be ignored

In the SQL statement UPDATE superheroes SET age = 37 WHERE age BETWEEN 35 AND 38;, which records will be updated?

Records with ages 35, 36, 37, and 38

Only records with age 35 and 38

In the SQL statement DELETE FROM superheroes WHERE hero_id > 3;, what records will be deleted?

Records with hero_id greater than 3

Only records with hero_id less than 3

Which of the following is a correct SQL statement to select all data from a table?

SELECT COLUMNS FROM table_name;

In SQL, what does the statement "SELECT * FROM customers" do?

Selects all columns from the customers table

Deletes all data from the customers table

Selects specific columns from the customers table

Updates all data in the customers table

What is the function of the SQL statement: SELECT * FROM customers WHERE contactLastName LIKE '%sh'?

Selects customers with last names containing 'sh'

Selects customers with last names starting with 'sh'

Selects customers with last names exactly 'sh'

Selects customers with last names ending with 'sh'

AND and OR both require all conditions to be true.

AND requires both conditions to be true, OR requires at least one

AND and OR both require all conditions to be true

AND requires at least one condition to be true, OR requires both

AND and OR both require at least one condition to be true

What is the effect of the condition MSRP

It selects records with MSRP less than 100.

It selects records with MSRP equal to 100.

It selects records with MSRP not equal to 100.

It selects records with MSRP greater than 100.

What is the primary use of the IN condition in SQL?

To check if a value is within a specified list

What is the primary purpose of a relational database?

To establish relationships between tables

To replicate data across tables

SQL Review Quiz

Authored by John Ulakovich

Information Technology (IT)

University

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

79 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which clause can specify rows for aggregate functions?

INSERT clause

WHERE clause

SELECT clause

DELETE clause

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What do aggregate queries construct from a table?

New tables

New cells

New columns

New rows

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which aggregate function is used to find the maximum value in a column?

AVG(value)

MIN(value)

MAX(value)

SUM(value)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What SQL keyword is used to provide more meaningful names to result sets?

ALIAS

TITLE

NAME

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Why might you use an ALIAS in a SQL query?

To provide more meaningful names

To make the query run faster

To delete duplicate data

To change the data type

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary use of the GROUP BY clause in SQL?

To sort records

To group records with the same values

To delete records

To filter records

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using aliases in SQL queries?

To rename columns or results

To rename tables

To join tables

To delete data

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

81 questions

Ulol gago tarantado tanga bastos walang modo siraulo

Quiz

•

University

77 questions

Project Management Quiz

Quiz

•

University

Popular Resources on Wayground

20 questions

STAAR Review Quiz #3

Quiz

•

8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

6 questions

Marshmallow Farm Quiz

Quiz

•

2nd - 5th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

19 questions

Classifying Quadrilaterals

Quiz

•

3rd Grade

12 questions

What makes Nebraska's government unique?

Quiz

•

4th - 5th Grade

Discover more resources for Information Technology (IT)

20 questions

Disney Trivia

Quiz

•

University

10 questions

GMAS ELA Review

Quiz

•

KG - University

9 questions

Week 9 Recitation

Quiz

•

University

26 questions

Customary Measurement

Quiz

•

KG - University

20 questions

Easter trivia

Quiz

•

12th Grade - Professi...