Which two statements art true about the instead of triggers’ (choose two.)
A.
Delete operations cannot be performed using the instead of triggers.
B.
The instead or triggers must be created to add or modify data through any view.
C.
The instead of triggers can be written only for views, and the before and after timing options are not valid.
D.
The check option for views Is not enforced when Insertions or updates to the view are performed by using the instead of trigger.
answer is B and C
are you sure about B and C because before your message it was C and D
You can add or modify data in a view without using instead of triggers. B is not a correct option.
for this question answer is B and C
sorry yar answer is C and D,,,i had checked the answer from this site
http://cmsaville.ca/documents/InsteadOfTriggers/Orc_InsteadOfTriggers.pdf
C & D is right ans.
verified from
http://docs.oracle.com/cd/E14072_01/appdev.112/e10472/triggers.htm#i1006376
C & D are right answers.
C and D.
For more info check the link below.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#i1006376
C and D
The INSTEAD OF option can be used only for triggers defined on views.
The BEFORE and AFTER options cannot be used for triggers defined on views.
The CHECK option for views is not enforced when inserts or updates to the view are done using INSTEAD OF triggers. The INSTEAD OF trigger body must enforce the check.
D isn’t correct? Good grief. Yeah, like a VIEW will automatically enforce its CHECK constraints when the table gets modified at the table itself instead of through the VIEW, NOT !
c d
About C, this is valid:
CREATE OR REPLACE TRIGGER instead_of_ddl
INSTEAD OF CREATE ON SCHEMA
BEGIN
NULL;
END;
The CREATE DDL event is the only DDL event that works with INSTEAD OF.
This violates: “The instead of triggers can be written only for views”
Regards
? some clarification
B is not correct. Tables behind simple views can be modified by DML statements.
c and d are correct
C D
Instead-of-triggers do NOT consider the “with check option”-clause of the view:
create or replace view emps_in_dept_10 as
select * from emp where deptno=10
WITH CHECK OPTION;
select empno from emps_in_dept_10;
7934
7782
update emps_in_dept_10 set deptno=20 where empno=7934;
… ORA-01402: … “view WITH CHECK OPTION where-clause violation” …
create or replace trigger tr_emps_in_dept_10
instead of update on emps_in_dept_10
begin
update emp set deptno=:new.deptno where empno=:new.empno;
end;
update emps_in_dept_10 set deptno=20 where empno=7934;
1 row affected
select empno from emps_in_dept_10;
7782
thanks Michael, nice explaination
Instead of triggers in oracle database are defined on views only
C & D.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#LNPLS20041
C D
C D
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#LNPLS20041
– The INSTEAD OF option can be used only for triggers defined on views.
– The BEFORE and AFTER options cannot be used for triggers defined on views.
– The CHECK option for views is not enforced when inserts or updates to the view are done using INSTEAD OF triggers. The INSTEAD OF trigger body must enforce the check.
cartierlovejesduas You dont know shit, and even worse, you dont understand shit. Go hide.
alhambra braccialetto oro bianco buon http://www.notiziedimarca.net/