Which of the following is a valid SQL numeric function? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid SQL numeric function?

A. CEILING

B. ROUND

C. All of the above

D. FLOOR

Answer: Option C

Solution (By JKSSB Mock Tests)

ROUND, CEILING, and FLOOR are common mathematical functions in SQL.

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

A Primary Key in RDBMS must be:

A. Always a foreign key

B. Duplicate values allowed

C. Can have null values

D. Unique and not null

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A primary key uniquely identifies each record and cannot contain null values.

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

Question #2

In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?

A. Ellipse

B. Rectangle

C. Diamond

D. Triangle

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.

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

Question #3

What type of entity cannot be uniquely identified by its own attributes alone and must rely on a relationship with a parent entity?

A. Associative Entity

B. Weak Entity

C. Abstract Entity

D. Strong Entity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Weak Entity is an entity that does not possess its own primary key and depends on an identifying relationship with a strong (owner) entity.

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

Explore All Database Management System (DBMS) MCQs