Top Posters
Since Sunday
w
3
w
3
e
3
3
r
3
g
2
2
b
2
M
2
V
2
f
2
c
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
lmalma lmalma
wrote...
Go to Answer
Posts: 491
Rep: 23 0
5 years 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
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 76 times
2 Replies
Replies
Answer verified by a subject expert
peaceout3000peaceout3000
wrote...
#1
Posts: 380
Rep: 63 0
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

lmalma Author
wrote...
#2
5 years ago
Smart ... Thanks!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  444 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 687
  
 348
  
 632
Your Opinion
Do you believe in global warming?
Votes: 488
Previous poll results: Do you trust social media networks with protecting your privacy?