Mark is interviewing for the role of a database developer. To help with the revisions, he made himself a quiz. Help him answer the questions.
Consider the following query:
SELECT UPPER(FullName), LOWER(City) FROM EmployeeDetails;
Which of the following statement is correct for the given query?
1
Shows name and city from EmployeeDetails table.
2
Shows name in upper-case and city in lower-case from EmployeeDetails table.
3
Shows name and city from EmployeeDetails table where the first character of name is upper-case and the first character of city is lower-case.
4
Shows name and city from EmployeeDetails table if the name is in upper-case and the city is in lower-case.