Oracle Certification Exam Question:
Download Questions PDF

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

Oracle Certification Interview Question
Oracle Certification Interview Question

Answer:

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

Download Oracle Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Which two statements are true regarding constraints? (Choose two.)
A. A foreign key cannot contain NULL values
B. A columns with the UNIQUE constraint can contain NULL values
C. A constraint is enforced only for the INSERT operation on a table
D. A constraint can be disabled even if the constraint column contains data
E. All constraints can be defined at the column level as well as the table level		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