What is a primary key in a database?

A unique identifier for each row in a table

A key used to open the database

In a LEFT JOIN, which table's data will be fully included in the result set?

Neither table's data is included

In the context of database design, what is normalization?

The process of organizing data to reduce redundancy and improve data integrity

The process of removing old tables

The process of removing unused Primary keys

What is a database, and why is it important in software development?

A database is a structured collection of data, and it's essential for storing and retrieving data in applications and systems.

A database is a piece of software that helps with code testing.

What is SQL injection, and why is it a security concern for databases?

SQL injection is a security vulnerability where malicious SQL code is injected into user input, potentially compromising the database

SQL injection is a technique for speeding up SQL queries.

What is SQL Workbench, and how does it assist database developers and administrators?

SQL Workbench is a versatile SQL client tool that provides a unified interface for connecting to various database systems, executing SQL queries, and managing database objects. It assists developers and administrators by streamlining database-related tasks.

SQL Workbench is a database management system created by Microsoft.

You have a table named "products" with a column "price." How would you retrieve all products with a price less than $50?

SELECT * FROM products WHERE price < 50;

SELECT * FROM products WHERE price > 50;

SELECT * FROM products HAVING price < 50;

SELECT * FROM products WHERE price = 50;

How would you update the "status" column in a table named "orders" to change all instances of "Pending" to "Shipped"?

UPDATE orders SET status = 'Shipped' WHERE status = 'Pending';

ALTER TABLE orders MODIFY status = 'Shipped' WHERE status = 'Pending';

MODIFY orders SET status = 'Shipped' WHERE status = 'Pending';

Select right SQL query to retrieve all the customers (first name and last name) who have made at least one purchase.

SELECT first_name, last_name FROM customers WHERE EXISTS (SELECT 1 FROM orders WHERE customers.customer_id = orders.customer_id);

SELECT first_name, last_name FROM customers WHERE order_count > 0;

SELECT first_name, last_name FROM customers WHERE order_id IS NOT NULL;

SELECT first_name, last_name FROM customers HAVING COUNT(*) > 0;

Write an SQL query to retrieve the products (product name and price) that have a price greater than $50.

SELECT product_name, price FROM products WHERE price > 50;

SELECT product_name, price FROM products HAVING price > 50;

SELECT product_name, price FROM products WHERE price >= 50;

SELECT product_name, price FROM products WHERE price < 50;

Write an SQL query to retrieve the most expensive product (product name and price).

SELECT product_name, price FROM products ORDER BY price DESC LIMIT 1;

SELECT product_name, MAX(price) FROM products;

SELECT product_name, price FROM products WHERE price = (SELECT MAX(price) FROM products);

SELECT price FROM products WHERE price IN (SELECT MAX(price) FROM products);

Write an SQL query to retrieve all the employees (first name and last name) who work in the "HR" department.

SELECT first_name, last_name FROM employees WHERE department = 'HR';

SELECT first_name, last_name FROM employees WHERE department_name = 'Human Resources';

SELECT first_name, last_name FROM employees WHERE department_id = 3;

SELECT first_name, last_name FROM employees WHERE department = 'Finance';

Write an SQL query to find the total number of products in the "Electronics" category.

SELECT COUNT(*) AS product_count FROM products WHERE category = 'Electronics';

SELECT COUNT(product_id) AS product_count FROM products WHERE category_id = 2;

SELECT COUNT(*) AS product_count FROM products WHERE category_name = 'Electronics';

SELECT SUM(quantity) AS product_count FROM products WHERE category = 'Electronics';

Write an SQL query to retrieve the names (first name and last name) of customers whose last name starts with the letter "S."

SELECT first_name, last_name FROM customers WHERE last_name LIKE 'S%';

SELECT first_name FROM customers WHERE last_name = 'S%';

SELECT first_name, last_name FROM customers WHERE last_name LIKE '%S%';

SELECT first_name, last_name FROM customers WHERE last_name = '%S%';

QA test - Module 2

Authored by Aleksei Zolochevskyi

Computers

Professional Development

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

MAX()

AVG()

COUNT()

SUM()

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which SQL function is used to find the max value in a column?

MIN()

COUNT()

MAX()

AVERAGE()

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What does the SQL function UPPER() do?

Converts a string to uppercase

Removes all spaces from a string

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which SQL function is used to extract a portion of a string?

CONCAT()

SUBSTR()

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What does the SQL function NOW() return?

The current date and time

The number of rows in a table

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which SQL keyword is used to filter rows in a SELECT statement?

WHERE

HAVING

GROUP BY

ORDER BY

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What is the purpose of the SQL statement DELETE?

Removes data from a table

Adds new data

Updates existing 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

25 questions

WEBZEN MCQ

Quiz

•

Professional Development

25 questions

The Best Minecraft Quiz Ever!!!!!

Quiz

•

1st Grade - Professio...

25 questions

ICDL for Afghan girls

Quiz

•

Professional Development

25 questions

DW-Cuestionario4

Quiz

•

Professional Development

26 questions

Macromedia Flash

Quiz

•

8th Grade - Professio...

25 questions

CompTIA Network+ Revision: Cables

Quiz

•

University - Professi...

25 questions

Chapter 1 - SDLC Review

Quiz

•

Professional Development

25 questions

review

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Grade 3 Simulation Assessment 1

Quiz

•

3rd Grade

22 questions

HCS Grade 4 Simulation Assessment_1 2526sy

Quiz

•

4th Grade

16 questions

Grade 3 Simulation Assessment 2

Quiz

•

3rd Grade

19 questions

HCS Grade 5 Simulation Assessment_1 2526sy

Quiz

•

5th Grade

17 questions

HCS Grade 4 Simulation Assessment_2 2526sy

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

24 questions

HCS Grade 5 Simulation Assessment_2 2526sy

Quiz

•

5th Grade

20 questions

Math Review

Quiz

•

3rd Grade

Discover more resources for Computers

20 questions

Block Buster Movies

Quiz

•

10th Grade - Professi...

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

10 questions

Lead Awareness Health Hazards

Quiz

•

Professional Development

QA test - Module 2

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

Which SQL function is used to find the max value in a column?

What does the SQL function UPPER() do?

Which SQL function is used to extract a portion of a string?

What does the SQL function NOW() return?

Which SQL keyword is used to filter rows in a SELECT statement?

What is the purpose of the SQL statement DELETE?

Which SQL statement is used to insert new data into a table?

What is a primary key in a database?

What does the acronym SQL stand for?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers