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

9 months ago

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

upvoted 0 times

...

Ruthann

9 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

8 months ago

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

upvoted 0 times

...

Simona

8 months ago

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

upvoted 0 times

...

Jacqueline

9 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

9 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

9 months ago

B) It will return an error.

upvoted 0 times

...

Ashleigh

9 months ago

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

upvoted 0 times

...

Caitlin

9 months ago

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

upvoted 0 times

...

Lauran

9 months ago

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

upvoted 0 times

Allene

9 months ago

User 2

upvoted 0 times

...

Lavera

9 months ago

User 1

upvoted 0 times

...

Kattie

10 months ago

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

upvoted 0 times

...

Xochitl

10 months ago

I think the answer is D.

upvoted 0 times

...