Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Which of the following updatable view restrictions is NOT valid? a . Set operators such as UNION, INTERSECT, and MINUS cannot be used. b .
Which of the following updatable view restrictions is NOT valid?
a Set operators such as UNION, INTERSECT, and MINUS cannot be used.
b The base table to be updated must be keypreserved; all values of the primary key must be kept unique.
c GROUP BY expressions or aggregate functions cannot be used.
d Updatable view must include the names of the base tables used in the view.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started