Top Posters
Since Sunday
25
24
23
22
22
22
22
21
21
21
21
20
New Topic  
wrote...
Posts: 123
2 months ago
SQL views are always updatable when ________.

• the view is based on a single table with no computed columns, and all non-null columns are present in the view

• the view is based on any number of tables, with or without computed columns, and the INSTEAD OF trigger is defined for the view

• the view is based on multiple tables, the update is being done on the most subordinate table, and the rows of that table can be uniquely identified

• Both the view is based on a single table with no computed columns, and all non-null columns are present in the view and the view is based on any number of tables, with or without computed columns, and the INSTEAD OF trigger is defined for the view are correct
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 5 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 112
Rep: 8 0
2 months ago
Sign in or Sign up in seconds to unlock everything.
Both the view is based on a single table with no computed columns, and all non-null columns are present in the view and the view is based on any number of tables, with or without computed columns, and the INSTEAD OF trigger is defined for the view are correct
1
Related Topics
wrote...
2 months ago
Smart ... Thanks!
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  442 People Browsing
 129 Signed Up Today
Your Opinion
Which of the following is the best resource to supplement your studies:
Votes: 48

Previous poll results: Do you believe in global warming?
Related Images
 9295
 336
 41