Multiple Choice
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? 
A) UPDATE Sales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108) ;
B) UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;
C) SET Sales_Rep_No = 110;
D) WHERE Sales_Rep_No = 108
Correct Answer:
Verified
Correct Answer:
Verified
Q57: What is a data dictionary?<br>A) A system
Q58: The exhibit shows a table called Activity
Q59: Consider the Project relation shown in the
Q60: Consider the entity-relation (ER) diagram shown in
Q61: Consider the table shown in the exhibit.
Q63: Your database administrator has disallowed a group
Q64: Your company must choose which type of
Q65: Which mechanism provides database users with controlled
Q66: Which database architecture is best suited to
Q67: What is the highest normal form of