Relational Database Week 06

What can you use the LENGTH text function for in SQL?

• To add extra spaces to your string

• To return the character length of the selected data

• To delete characters from a string

• To concatenate two strings together

What can be included as a primary key if it wasn't specified at the time of table creation?

• Any candidate key column

• Any column with integer data

• The first column of the table by default

• A column with NULL values

What is the function of the CASE statement in SQL?

• Change text from lower to upper case

• Perform mathematical calculations

• Evaluate conditions and return appropriate values

• Sort data in ascending order

Which function can be combined with the MAX function to return the length of the longest string in the data?

• LTRIM

• RTRIM

• LENGTH

• UPPER

What is the advantage of using a CASE statement in categorizing data?

• Multiple categories to be assigned to a record simultaneously.

• It provides flexibility in defining multiple conditions and corresponding actions.

• It ensures faster execution compared to other conditional statements.

• It automatically validates data.

What control structure is the CASE statement similar to?

• WHILE-DO loop

• FOR loop

• IF-THEN-ELSE control structure

• Conditional operator

What happens if record evaluates as true in a CASE expression with multiple conditions?

• The first true condition's result is returned.

• The last true condition's result is returned.

• All true conditions' results are returned.

• An error is raised.

What is the purpose of the ELSE case in the CASE statement?

• It defines the default action if none of the preceding conditions are met.

• It specifies an additional condition for the CASE statement.

• It terminates the CASE statement.

• It indicates the end of the CASE statement block.

What SQL keyword is used to sort the data that's returned in a SELECT statement?

• WHERE

• ORDER BY

• CASE

• SET

In a SELECT statement, what is the default order when using ORDER BY?

• Descending from Z to A

• Random order

• Ascending from A to Z

• Ascending from 9 to 0