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

Contribute your Thoughts:

Submit Cancel

8 days ago

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

upvoted 0 times

...

20 days ago

Why do you think option E is correct?

upvoted 0 times

...

20 days 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

3 days ago

I think the correct answers are D and E.

upvoted 0 times

...

21 days ago

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

upvoted 0 times

...

22 days ago

I think option A would generate the bar graph.

upvoted 0 times

...