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

Which of the following is a valid SQL numeric function?
A. FLOOR
B. ROUND
C. CEILING
D. All of the above
Answer: Option D
Solution (By JKSSB Mock Tests)
ROUND, CEILING, and FLOOR are common mathematical functions in SQL.

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 command is used to reverse or undo all modifications made during the current transaction that have not yet been committed?
A. SAVEPOINT
B. UNDO
C. REVERT
D. ROLLBACK

Correct Answer: Option D


Explanation:
The ROLLBACK command is a TCL statement used to undo transactions, restoring the database to its last committed or safe state.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What type of join produces a Cartesian product, matching every single row of the first table with every single row of the second table?
A. Cross Join
B. Inner Join
C. Left Join
D. Natural Join

Correct Answer: Option A


Explanation:
A Cross Join returns the Cartesian product of the two tables, multiplying the total number of rows from the first table by the number of rows in the second table.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which clause must be used instead of WHERE to filter or restrict rows after an aggregation or group-by operation has been performed?
A. HAVING
B. RESTRICT
C. WHERE CURRENT OF
D. WHEN

Correct Answer: Option A


Explanation:
The HAVING clause was added to SQL because the WHERE keyword cannot be applied to aggregate functions; it filters groups generated by the GROUP BY clause.

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