Answers

Question and Answer:

  Home  Oracle Certification

⟩ Explain Which two statements are true regarding views? (Choose two.) A. A subquery that defines a view cannot include the GROUP BY clause B. A view is created with the subquery having the DISTINCT keyword can be updated C. A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated D. A Data Manipulation Language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

C. A view that is created with the subquery having the pseudo column ROWNUM keyword cannot

be updated

D. A Data Manipulation Language (DML) operation can be performed on a view that is created

with the subquery having all the NOT NULL columns of a table

 149 views

More Questions for you: