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

11 hours ago

I think option A would generate the bar graph.

upvoted 0 times

...