Oracle Exam 1Z0-1096-23 Topic 12 Question 15 Discussion

Actual exam question for Oracle's 1Z0-1096-23 exam

Question #: 15
Topic #: 12

Examine the SQL command: SQL> SELECT CUST_MARITAL_STATUS,MEDIAN(CUST_CREDIT_LIMIT) FROM SH.CUSTOMERS GROUP BY CUST_MARITAL_STATUS; Which statement is true about running this command where the table has columns cust_maritax._status3 (VARCHAR2) and cust_credit_limit (number) with 100k rows of non-null data?

AIt will return a customer's marital status and credit limit grouped by marital status

BIt will return an error.

CIt will return the marital status and credit limit of each customer.

DIt will return the median value of customer credit limit grouped by marital status.

Show Suggested Answer

Suggested Answer: D

Running this command will return the median value of customer credit limit grouped by marital status2.

The MEDIAN function is an aggregate function that returns the middle value of a numeric column for each group or partition.If the number of values is even, it returns the average of the two middle values2.

The GROUP BY clause is used to divide the rows of a table into groups that have the same values in the specified columns.The aggregate functions are applied to each group separately and the result is returned for each group3.

by Louvenia at Mar 10, 2024, 12:00 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-1096-23 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Veronica

6 months ago

I believe A) is incorrect because it specifically mentions MEDIAN(CUST_CREDIT_LIMIT) which indicates it will calculate the median.

upvoted 0 times

...

France

6 months ago

But why not A)? It seems like it could return the marital status and credit limit grouped by marital status.

upvoted 0 times

...

Gaston

7 months ago

I agree with Veronica, the command calculates the median credit limit for each marital status.

upvoted 0 times

...

Veronica

7 months ago

I think the answer is D) It will return the median value of customer credit limit grouped by marital status.

upvoted 0 times

...