Oracle Exam 1Z0-909 Topic 12 Question 52 Discussion

Actual exam question for Oracle's 1Z0-909 exam

Question #: 52
Topic #: 12

[All 1Z0-909 Questions]

Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?

ASELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

BSELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;

CSELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

DSELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

ESELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

Show Suggested Answer

Suggested Answer: A

by Maira at Oct 20, 2024, 03:31 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Becky

1 months ago

This question is as clear as mud. I'm just going to draw a bunch of hashtags and call it a day.

upvoted 0 times

Nguyet

21 days ago

A) SELECT Name, Gender, Sport, REPEAT('#', GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

upvoted 0 times

...

Carmen

1 months ago

Hold up, is this a trick question? I bet the answer is A and D. REPEAT and RPAD, that's the way to go!

upvoted 0 times

Edison

3 days ago

Yeah, using REPEAT and RPAD functions would definitely create the bar graph shown in the image.

upvoted 0 times

...

Trinidad

16 days ago

I think you're right, A and D are the correct statements to generate the bar graph.

upvoted 0 times

...

Denny

2 months ago

Hmm, this is a tricky one. I think I'll go with C and E. CHAR_LENGTH and CONCAT seem like they could work, but I'm not 100% sure.

upvoted 0 times

Blair

12 days ago

Let's go with C and E then. It seems like the logical choice based on the graph.

upvoted 0 times

...

Ocie

19 days ago

I agree with you. C and E seem like the most plausible options to create the bar graph.

upvoted 0 times

...

Luis

21 days ago

I think C and E are the correct statements. CHAR_LENGTH and CONCAT could generate the bar graph.

upvoted 0 times

...

Rosenda

2 months ago

I'm pretty sure the answer is B and D. LENGTH and RPAD should do the trick for this visualization.

upvoted 0 times

Gussie

5 days ago

Great, B and D it is for generating this bar graph.

upvoted 0 times

...

Reyes

16 days ago

Let's go with B and D then, they seem to be the most appropriate choices.

upvoted 0 times

...

Rebbeca

18 days ago

I agree, using LENGTH and RPAD would generate the bar graph shown.

upvoted 0 times

...

Daryl

2 months ago

I think you're right, B and D seem like the correct options.

upvoted 0 times

...

Lorrine

2 months ago

Why do you think option E is correct?

upvoted 0 times

...

Sharmaine

2 months ago

The correct answers are D and E. Both RPAD and CONCAT can generate the bar graph by creating a string of '# ' repeated based on the GPA value.

upvoted 0 times

Joanne

2 months ago

No problem, happy to help!

upvoted 0 times

...

Brandee

2 months ago

That makes sense, thanks for clarifying.

upvoted 0 times

...

Jamey

2 months ago

RPAD and CONCAT can generate the bar graph by repeating '# ' based on the GPA value.

upvoted 0 times

...

Trevor

2 months ago

I think the correct answers are D and E.

upvoted 0 times

...

Novella

2 months ago

I disagree, I believe option E is the correct one.

upvoted 0 times

...

Lorrine

3 months ago

I think option A would generate the bar graph.

upvoted 0 times

...