QA test - Module 2

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

• MAX()

• AVG()

• COUNT()

• SUM()

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

• MIN()

• COUNT()

• MAX()

• AVERAGE()

What does the SQL function UPPER() do?

• Converts a string to uppercase

• Removes all spaces from a string

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

• CONCAT()

• SUBSTR()

What does the SQL function NOW() return?

• The current date and time

• The number of rows in a table

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

• WHERE

• HAVING

• GROUP BY

• ORDER BY

What is the purpose of the SQL statement DELETE?

• Removes data from a table

• Adds new data

• Updates existing data

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

• INSERT INTO

• HAVING

• WHERE

What is a primary key in a database?

• A key used to open the database

• A unique identifier for each row in a table

• The main table in a database

• A key used for encryption

What does the acronym SQL stand for?

• Simple Query Language

• Structured Query Language

• System Query Language

• Secure Query Language