Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 7

Examine these SQL statements which execute successfully:

Which two statements are true after execution? (Choose two.)

    Correct Answer: A, E

    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.

Discussion
Chandra1104Options: AD

AD Cascade constraint will disable to primay key as well as foreign key.

Rik92Options: AD

AD. Due to the PK being disabled, the FK is disabled. PK afterwards is enabled again

Lee_jong_sukOptions: AD

AD is the correct answer

Andrew91

What does it mean by IMMEDIATE tho?

Lee_jong_suk

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.

twingOptions: AD

is AD PK enable again