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. All of the above

B. ROUND

C. FLOOR

D. CEILING

Answer: Option A

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

Share Report

Which of the following database concepts deals with grouping a set of SQL statements into a single logical unit of execution?

A. View definition

B. Indexing

C. Normalization

D. Transaction

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Transaction is a sequence of one or more SQL operations treated as a single, indivisible unit of work that must either succeed completely or fail completely.

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

Question #2

Share Report

What is the concept of referential integrity?

A. Ensuring that no null values exist

B. Ensuring that foreign key values match primary key values in the referenced table

C. Ensuring data is normalized

D. Ensuring that all primary keys are unique

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Referential integrity ensures that relationships between tables remain consistent, meaning foreign key values must have corresponding primary key values.

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