Oracle Exam 1Z0-1096-23 Topic 10 Question 26 Discussion

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Kristeen

10 months ago

D is the way to go. Honestly, who would even consider C? That's just silly.

upvoted 0 times

...

Ruthann

10 months ago

I think A is the correct answer. It will return the marital status and the median credit limit for each group.

upvoted 0 times

Gladys

10 months ago

C) It will return the marital status and credit limit of each customer.

upvoted 0 times

...

Simona

10 months ago

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

upvoted 0 times

...

Jacqueline

11 months ago

I'm going with B. The MEDIAN function can't be used on a VARCHAR2 column like cust_marital_status.

upvoted 0 times

Arlen

10 months ago

I'm going with B. The MEDIAN function can't be used on a VARCHAR2 column like cust_marital_status.

upvoted 0 times

...

Jame

10 months ago

B) It will return an error.

upvoted 0 times

...

Ashleigh

11 months ago

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

upvoted 0 times

...

Caitlin

11 months ago

I believe the answer is C, as it is grouping by marital status.

upvoted 0 times

...

Lauran

11 months ago

Definitely D. The MEDIAN function will give us the median credit limit for each marital status group.

upvoted 0 times

Allene

11 months ago

User 2

upvoted 0 times

...

Lavera

11 months ago

User 1

upvoted 0 times

...

Kattie

11 months ago

I agree with Xochitl, because the command uses the MEDIAN function.

upvoted 0 times

...

Xochitl

11 months ago

I think the answer is D.

upvoted 0 times

...