MENU
Consider the Orders relation shown in the exhibit. Which of the following SQL statements
would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No
108 is listed?
Suggested Answer: B
Get Premium 1D0-541 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
7 comments · newest first
KA
Karl
11 months ago
A looks weird, but I think it’s just the formatting.
ZA
Zachary
12 months ago
Wait, is D even valid SQL? Seems off.
BE
Beatriz
12 months ago
C won't work, it updates all rows.
LA
Laquanda
1 year ago
Totally agree, B is the way to go!
LI
Linsey
1 year ago
B is the correct syntax for the update.
QU
Queen
1 year ago
I'm a bit confused on this one. I'm not sure if OmniScript is the right choice for the email notification, since it's more for interactive processes. Maybe a combination of DataRaptor Turbo Extract, DataRaptor Load, and a custom Apex class or Flow would work better?
TA
Tayna
1 year ago
Okay, let me think this through step-by-step. We need to rebuild the indexes, so it's likely one of the "reIndex" or "createIndex" commands. I'm leaning towards option D, db.collection.createIndex({author:l}).reIndex(), since that seems to combine the index creation and rebuilding.