What does it mean by IMMEDIATE tho?
IMMEDIATE means the check will be done as soon as you make change in your session.
But DEFERRED means the check will be done only when you do commit.
A, D - true
Experimental – after executing provided commands, the state of constraints is following:
SQL> SELECT constraint_name,constraint_type,table_name,status,deferred FROM user_constraints WHERE table_name='EMP';
CONSTRAINT_NAME CONSTRAINT_TYPE TABLE_NAME STATUS DEFERRED
--------------- --------------- ---------- -------- ---------
EMP_EMP_NO_PK P EMP ENABLED IMMEDIATE
EMP_MGR_FK R EMP DISABLED IMMEDIATE
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.
Rafafm
3 months agonautil2
1 year, 4 months agoauwia
1 year, 6 months agoDarkseid1231
1 year, 6 months ago