Computer Science
Assertion (A): Aggregate functions in SQL operate on multiple set of values and return a single value as the output.
Reasoning (R): The aggregate functions are used to perform operations on a group of values. Some common aggregate functions are SUM(), MAX(), MIN(), etc.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
SQL Queries
1 Like
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
Aggregate functions (multiple-row functions) in SQL operate on multiple sets of values and return a single value as the output. Some common aggregate functions are SUM(), MAX(), MIN(), etc., which are used to perform operations on groups of values.
Answered By
3 Likes
Related Questions
Assertion (A): SQL queries are performed on a table created under a database.
Reasoning (R): The database is a folder created by the user in MySQL workbench. Thereafter, the tables are created in a database where various queries can be performed using SQL commands.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion (A): Cartesian product of two sets (A and B) is defined as the set of all possible ordered pairs denoted by (A + B).
Reasoning (R): The Cartesian product is also known as the cross product of two sets. The Cartesian product of two tables can be evaluated such that each row of the first table will be paired with all the rows in the second table.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
What is an Alternate Key ?
Write some characteristics of RDBMS.