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

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

Question #: 28
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 Luisa at Aug 26, 2024, 08:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Willodean

2 months ago

D, all the way. Though I'm a bit disappointed they didn't throw in a question about the MEAN function. That's my specialty, you know.

upvoted 0 times

Louis

1 months ago

A) It will return a customer's marital status and credit limit grouped by marital status

upvoted 0 times

...

Louis

1 months ago

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

upvoted 0 times

...

Louis

2 months ago

A) It will return a customer's marital status and credit limit grouped by marital status

upvoted 0 times

...

Lili

3 months ago

D, for sure. I'm just wondering if the credit limits are all in whole numbers or if there are some decimal places involved. Wouldn't want to get tripped up on that!

upvoted 0 times