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

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

Question #: 8
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 Dick at Oct 02, 2023, 11:43 AM

Limited Time Offer

25%