Examine this code: Examine this DML statement executed in the SCOTT schema: UPDATE emp SET comm = 1000 WHERE deptno= 20; What is the outcome after executing this statement?
A.
COMM is set to 1000 for all records in the EMP table where DEPTNO = 30.
B.
The statement executes successfully but no rows are updated.
C.
COMM is set to 1000 for all records in the EMP table where DEPTNO=20.
D.
The statement fails with error ORA-28115: policy with check option violation.
D -
For INSERT and UPDATE statements only, setting update_check to TRUE causes the server to check the policy against the value after INSERT or UPDATE.
The check applies only to the security relevant columns that are included in the policy definition. In other words, the INSERT or UPDATE operation will fail only if the security relevant column that is defined in the policy is added or updated in the INSERT or UPDATE statement.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Angelos_ang
2 years, 4 months agosudhirdavim
4 years, 1 month agoAdela_bg
4 years, 6 months agoprotonik2020
4 years, 5 months agochaoyuim
4 years, 7 months agoorakell
5 years, 2 months ago