Which of the following is a valid SQL numeric function? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What is the purpose of the SQL COALESCE function?
Correct Answer: Option C
Explanation:
COALESCE returns the first non-NULL value among its arguments, often used to provide a default value.
COALESCE returns the first non-NULL value among its arguments, often used to provide a default value.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is not an aggregate function in SQL?
Correct Answer: Option D
Explanation:
DESC is a keyword for sorting order, not an aggregate function.
DESC is a keyword for sorting order, not an aggregate function.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is a column in a relational database table formally called?
Correct Answer: Option C
Explanation:
A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.
A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!