FPSC - Database Administrator Model Papers -2026 — Test 4
Page 1 of 3
Question 1
What does ON DELETE CASCADE do in a foreign key?
FPSC - Database Administrator Model Papers -2026
Question 2
What does ON DELETE SET NULL do?
FPSC - Database Administrator Model Papers -2026
Question 3
Which statement adds a primary key to an existing table?
FPSC - Database Administrator Model Papers -2026
Question 4
Which statement drops a constraint?
FPSC - Database Administrator Model Papers -2026
Question 5
Which data dictionary view lists constraints on the user's tables?
FPSC - Database Administrator Model Papers -2026
Question 6
In USER_CONSTRAINTS, which CONSTRAINT_TYPE value represents a foreign key (referential) constraint?
FPSC - Database Administrator Model Papers -2026
Question 7
Which error occurs when you insert a duplicate value into a primary key column?
FPSC - Database Administrator Model Papers -2026
Question 8
Which statement disables a constraint temporarily?
FPSC - Database Administrator Model Papers -2026
Question 9
What is a DEFERRABLE constraint?
FPSC - Database Administrator Model Papers -2026
Question 10
What does Oracle automatically create when you define a PRIMARY KEY or UNIQUE constraint?
FPSC - Database Administrator Model Papers -2026