Which of the following is a valid use of a wildcard character in the LIKE clause?

% to represent any sequence of characters

_ to represent any single character

Which of the following SQL queries uses the IN operator correctly?

SELECT * FROM employees WHERE department IN ('HR', 'Finance');

SELECT * FROM employees WHERE department = ('HR', 'Finance');

SELECT * FROM employees WHERE department LIKE 'HR, Finance';

SELECT * FROM employees WHERE department = 'HR' OR department = 'Finance';

What does the following SQL query do? SELECT name, age FROM employees WHERE age > 30 AND department = 'HR';

Selects names and ages of all employees in the HR department who are older than 30

Selects names and ages of all employees older than 30

Selects employees who are either older than 30 or in the HR department

Selects all employees older than 30 regardless of department

Which of the following is true about the HAVING clause?

It is used to filter records after grouping

It is used to filter records before grouping

It cannot be used with aggregate functions

It can be used only with ORDER BY

What does the following SQL command do? ALTER TABLE employees ADD COLUMN salary DECIMAL(10, 2);

Adds a new column named salary to the employees table

Modifies the data type of the salary column in the employees table

Deletes the salary column from the employees table

Renames the salary column in the employees table

Which of the following is the correct syntax to create a new table?

CREATE TABLE table_name (column1 datatype, column2 datatype);

NEW TABLE table_name CREATE (column1 datatype, column2 datatype);

How do you filter records based on a pattern using LIKE in MySQL?

Use wildcards % and _ to represent multiple and single characters respectively

Use NOT NULL for pattern matching

Use DISTINCT to get unique patterns

What is the function of the DISTINCT keyword in a SELECT statement?

It removes duplicates from the result set

Which of the following queries will return the names of employees whose age is between 25 and 40?

SELECT name FROM employees WHERE age BETWEEN 25 AND 40;

SELECT name FROM employees WHERE age >= 25 AND age <= 40;

SELECT name FROM employees WHERE age IN (25, 40);

What does the following SQL query do? SELECT * FROM employees ORDER BY salary DESC;

Returns all employees ordered by their salary in descending order

Returns all employees ordered by their salary in ascending order

Returns only the employees with the highest salary

Returns employees whose salary is above a certain threshold

Which of the following statements will return the count of all records from the orders table?

SELECT count(order_id) FROM orders;

What is the result of the following query? SELECT name, department FROM employees WHERE department = 'IT' OR department = 'HR';

Returns all employees in the IT department and HR department

Returns all employees in the IT department or HR department

Returns employees whose department is neither IT nor HR

Returns employees who work in other departments

What will the following query do? SELECT * FROM products WHERE price BETWEEN 100 AND 500;

It returns all products priced between 100 and 500

It returns all products priced above 100

It returns all products priced exactly 100 and 500

It returns all products priced below 100 and above 500

Which of the following queries is correct to select employees with NULL in the phone_number column?

SELECT * FROM employees WHERE phone_number IS NULL;

SELECT * FROM employees WHERE phone_number = NULL;

SELECT * FROM employees WHERE phone_number NOT NULL;

SELECT * FROM employees WHERE phone_number != NULL;

What does the HAVING clause do in SQL?

Filters records before grouping

Specifies the columns to be included in the result set

Sets a limit on the number of rows returned

Which of the following queries will return employees who have made a sale greater than the average sale amount? SELECT name FROM employees WHERE sale_amount > (SELECT AVG(sale_amount) FROM sales);

It will return employees whose sale amount is greater than the average

It will return all employees who have made any sale

It will return all employees with a NULL sale amount

It will return employees who have made the highest sales

Which of the following SQL queries will return the second highest salary from the employees table? SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

It returns the second highest salary from the employees table

It returns the highest salary from the employees table

It returns the third highest salary from the employees table

It returns all salary records from the employees table

Which of the following queries will sort the results by salary in ascending order? SELECT name, salary FROM employees ORDER BY salary ASC;

It sorts employees by salary in ascending order

It sorts employees by salary in descending order

It sorts employees by name in ascending order

It sorts employees by salary in alphabetical order

F1-Quiz

Authored by ELLAINE CERVANTES

Computers

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

28 questions

Show all answers

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following clauses is used to filter rows returned by a SQL query?

SELECT

ORDER BY

WHERE

GROUP BY

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What will the following query return?
SELECT DISTINCT city FROM customers;

All the cities in the customers table

Only unique cities from the customers table

All customers in the customers table

Unique customer IDs

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which keyword is used to sort the result set in ascending or descending order?

SORT BY

ORDER BY

GROUP BY

FILTER BY

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following clauses is used to group rows that have the same values?

GROUP BY

ORDER BY

WHERE

HAVING

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

Which of the following SQL queries will return rows where the column status is not null?

WHERE status IS NULL

WHERE status != NULL

WHERE status NOT NULL

WHERE status IS NOT NULL

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

What is the result of the following query?
SELECT name FROM students WHERE grade IS NOT NULL;

It will return all students whose grades are NOT NULL

It will return all students with a grade of 'NULL'

It will throw an error

It will return all students, regardless of their grade

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following statements will delete a record from a table?

DELETE FROM table_name WHERE condition;

REMOVE FROM table_name WHERE condition;

REMOVE table_name WHERE condition;

DELETE table_name WHERE condition;

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

Aptitude Competition(FY)

Quiz

•

University

25 questions

QUIZ 4

Quiz

•

University

23 questions

Hardware in Multimedia

Quiz

•

University

25 questions

UAS Sistem Digital 2020/2021

Quiz

•

University

24 questions

2B. Active Reconnaissance - Enumeration

Quiz

•

University

25 questions

Atividade sobre Modelos de Processo de Software

Quiz

•

University

25 questions

Module 3 - Security Architecture

Quiz

•

University

25 questions

Algorithms are not magic - AQA A Level Computer Science

Quiz

•

8th Grade - 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 Computers

30 questions

Quiz 1 Review

Quiz

•

University

F1-Quiz

Which of the following clauses is used to filter rows returned by a SQL query?

What will the following query return?SELECT DISTINCT city FROM customers;

Which keyword is used to sort the result set in ascending or descending order?

Which of the following clauses is used to group rows that have the same values?

Which of the following SQL queries will return rows where the column status is not null?

What is the result of the following query?SELECT name FROM students WHERE grade IS NOT NULL;

Which of the following statements will delete a record from a table?

Which SQL operator is used to search for a specified pattern in a column?

Which of the following is a valid use of a wildcard character in the LIKE clause?

Which of the following SQL queries uses the IN operator correctly?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

What will the following query return?
SELECT DISTINCT city FROM customers;

What is the result of the following query?
SELECT name FROM students WHERE grade IS NOT NULL;