Examine these SQL statements which execute successfully:
Which two statements are true after execution? (Choose two.)
Examine these SQL statements which execute successfully:
Which two statements are true after execution? (Choose two.)
After executing the given SQL statements, the primary key constraint (emp_emp_no_pk) will be enabled and IMMEDIATE. The statement does not specify deferment for the primary key; thus, it is enabled immediately. The foreign key constraint (emp_mgr_fk) will also be enabled and IMMEDIATE by default because there is no mention of disabling or deferring it in the given statements. Although there is a step that disables the primary key constraint, it is immediately followed by an enabling statement, setting it to its default state of being IMMEDIATE.
AD Cascade constraint will disable to primay key as well as foreign key.
AD. Due to the PK being disabled, the FK is disabled. PK afterwards is enabled again
AD is the correct answer
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.
is AD PK enable again