Which of the following is a valid SQL function to convert a string to uppercase? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid SQL function to convert a string to uppercase?

A. TO_UPPER()

B. UCASE()

C. UPPER()

D. Both A and C

Answer: Option D

Solution (By JKSSB Mock Tests)

UPPER() is standard SQL; some DBMS also support UCASE().

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

In SQL, which clause is used to filter rows before grouping?

A. WHERE

B. HAVING

C. ORDER BY

D. GROUP BY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
WHERE is used to filter individual rows before aggregation and grouping.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Which SQL clause is used to filter groups after grouping?

A. HAVING

B. WHERE

C. GROUP BY

D. ORDER BY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
HAVING is used to filter groups based on aggregate conditions, applied after GROUP BY.

This question belongs to: Computer Database Management System (DBMS)

Question #3

What is the purpose of the SQL 'GROUP BY' clause?

A. To group rows that have the same values in specified columns into summary rows

B. To join tables

C. To sort the result set

D. To filter rows

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
GROUP BY organizes data into groups based on the values of one or more columns, often used with aggregate functions.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs