Which of the following SQL statements demonstrates the correct usage of the UPPER() function to convert a column ‘name’ into uppercase? This question is required.*ASELECT name FROM employees WHERE name = UPPER(name);BSELECT UPPERfunction(name) FROM employees WHERE name = name;CSELECT UPPEROF(name) FROM employees WHERE name = LOWER(name);DSELECT UPPER(name) FROM employees;

Which of the following SQL statements correctly converts the product_name column in the products table to lowercase and displays it as lowercase_name? This question is required.*ASELECT LOWER(productname) AS lowercasename FROM products;BSELECT productname AS lowercasename FROM products WHERE productname = LOWER(productname);CSELECT productname AS LOWER(productname) FROM products;DSELECT productname AS lowercasename FROM products;

Which function helps in changing the text to uppercase in Excel?Answer( Please choose a correct answer )   CLEARLOWER()CAPITAL()UPPER()BIG()

Evaluate this SQL statement:SELECT first_name, commissionFROM employeeWHERE commission =(SELECT commissionFROM employeeWHERE UPPER(first_name) = 'SCOTT');What would cause this statement to fail?Select one:a.There is more than one employee with the first name Scott.b.The FIRST_NAME values in the database are in lowercase.c.Scalar function is not allowed in Subquery.d.All the given optionse.Scott has a zero commission value.

2.Question 2What is the result when .upper() is applied to a string?1 pointThe value of the string is reassigned to the value of the string in the line preceding it.A copy of the string is returned with all uppercase letters.The character that appears most frequently in the string is extracted from it and returned.The value of the string is reassigned to contain all uppercase letters.

Which query element should be uppercase? Select 5 correct answers.A. selectB. fromC. likeD. whereE. column nameF. table nameG. cast()