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

26 questions

Planning a Network Infrastructure

Quiz

•

KG - Professional Dev...

26 questions

War Games Film Quiz

Quiz

•

Professional Development

29 questions

COMPTIA ITF

Quiz

•

1st Grade - Professio...

25 questions

CompTIA A+ Certification Practice Test 11

Quiz

•

Professional Development

25 questions

PRE - Quiz J&T Hari 3

Quiz

•

Professional Development

25 questions

ML-overall

Quiz

•

University - Professi...

25 questions

LIVITERA QUIZBEE 2024

Quiz

•

Professional Development

30 questions

Google Sheets Toolbar Quiz

Quiz

•

7th Grade - Professio...

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

10 questions

How to Email your Teacher

Quiz

•

Professional Development

6 questions

3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET

Quiz

•

Professional Development

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

22 questions

Multiplying Exponents with the Same Base

Quiz

•

9th Grade - Professio...

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

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