Database Management System Quiz

What does SQL stand for?

• Standard Query Language

• Simple Query Language

• Structured Question Language

• Structured Query Language

Which function calculates the average in SQL?

• AVG()

• MIN()

• SUM()

• COUNT()

What does the COUNT() function do?

• Calculates the sum

• Finds the maximum value

• Counts the number of rows

• Calculates the average

Which function returns the first non-null value in a list?

• CASE WHEN

• COALESCE()

• ABS()

• NULLIF()

What is the purpose of the ROUND() function?

• Raises a number to a power

• Returns the absolute value

• Rounds a number to a specified number of decimal places

• Calculates the square root

What does CTE stand for in SQL?

• Common Table Evaluation

• Common Type Expression

• Common Transaction Expression

• Common Table Expression

Which type of backup only backs up the files that have changed since the last backup?

• Differential Backup

• Incremental Backup

• Complete Backup

• Full Backup

What is the main objective of database security?

• To increase data volume

• To ensure the confidentiality of information

• To enhance data retrieval speed

• To ensure data redundancy

Which of the following is NOT a type of backup mentioned?

• Partial Backup

• Differential Backup

• Incremental Backup

• Full Backup

What does the ABS() function return?

• The maximum value

• The absolute value of a number

• The square root of a number

• The minimum value