Oracle Exam 1Z0-908 Topic 7 Question 97 Discussion

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

Question #: 97
Topic #: 7

[All 1Z0-908 Questions]

Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)

AUPDATE world.country SET Name='all';

BUPDATE world.country SET Name='one' LIMIT 1;

CUPDATE world.country SET Name='new' WHERE Name='old';

DUPDATE world.country SET Name=CONCAT('New ',Name);

EUPDATE world.country SET Name='first' ORDER BY Name LIMIT

Show Suggested Answer

Suggested Answer: A, D, E

by Deja at Jan 25, 2025, 03:49 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Youlanda

2 hours ago

I bet the correct answers are B and C. The others seem a bit too risky or just plain silly.

upvoted 0 times

...

Clarence

1 days ago

Trying to update all the rows at once? That's a bold move, Cotton. Let's see if it pays off for them.

upvoted 0 times

...

Pamela

10 days ago

Ha! Ordering and limiting the UPDATE? That's a bold move. I'd steer clear of E, seems like a recipe for disaster.

upvoted 0 times

Eveline

2 hours ago

I agree, E does seem risky. I would go with A and C instead.

upvoted 0 times

...

Carisa

11 days ago

I think D is the way to go. Concatenating 'New ' to the existing name is a nice way to update the data without messing up the order.

upvoted 0 times

...

Lyla

19 days ago

But option B has a syntax error, so I think it's C and D.

upvoted 0 times

...

Erick

22 days ago

Hmm, this looks tricky. I'm not sure if I should go with B or C. Limiting to one row seems risky, but the WHERE clause in C seems safer.

upvoted 0 times

Maricela

2 days ago

User 1: I think you should go with option C. Using the WHERE clause is safer.

upvoted 0 times

...

Willow

23 days ago

I disagree, I believe jsmith can execute options B and D.

upvoted 0 times

...

Lyla

1 months ago

I think jsmith can execute options C and D.

upvoted 0 times

...