Correct Answer: Group functions ignore the null values
Explanation:
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
PostgreSQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More PostgreSQL MCQ Questions
What do you infer from the following two lines?
1. host all 192.168.1.10 255.255.255.255 reject
2. host all 127.0.0.1 255.255.255.255 trust
Which of the following are not DCL operations?
What do you understand by the following PL/pgSQL declaration?
c_phone customer.contact_no%TYPE;
What is wrong in this query:
Select * from Orders where OrderID=(select OrderID from OrderItems where ItemQty>50)
A wholesale merchant shop needs a report about the sale where total sale of the day is more than $50,000. Which of the following will fulfill this requirement?
Which is NOT true of array indexes?
What is 'index bloat'?
By default, in what subdirectory of the database data directory are WAL logs contained?
In order to echo all input from script, you use the ________ psql command.
To restore a PostgreSQL backup created with pg_dump, the following may be used: