Which of the following statements are true about a view?
Each correct answer represents a complete solution. Choose all that apply.
A.
A sub query that is used in a complex view definition cannot contain joins or group functions.
B.
The OR REPLACE option is used to change the definition of an existing view without dropping
and recreating it.
C.
The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns
displayed through the view.
D.
A view can be dropped and then re-created.