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

Which SQL keyword is used to remove a table from the database?

A. DROP

B. REMOVE

C. TRUNCATE

D. DELETE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DROP TABLE is a DDL command that deletes the table and its structure from the database.

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

Question #2

In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?

A. Relation Instance

B. Relation Card

C. Relation Schema

D. Relation Domain

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

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

Question #3

Which of the following is a characteristic of the relational model?

A. All of the above

B. Relationships are represented through keys

C. Data is accessed via SQL

D. Data is stored in tables

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The relational model organizes data in tables, uses keys for relationships, and is queried using a language like SQL.

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

Explore All Database Management System (DBMS) MCQs