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

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;

Select the correct answerAll keywords in Python are in _________OptionsUPPER CASENone of the mentionedCapitalizedlower case

Question 1You want to select author's last name from a table, but you only remember the author’s last name starts with the letter B, which string pattern can you use? 1 pointSELECT lastname from author where lastname like ‘B#’ SELECT lastname from author where lastname like ‘B%’ SELECT lastname from author where lastname like ‘B$’ None of the above

Select the correct answerAll keywords in Python are in _________Optionslower caseCapitalizedNone of the mentionedUPPER CASE