FPSC - Database Administrator Model Papers -2026 — Test 12
Page 1 of 3
Question 1
In an updatable join view, DML is allowed on columns of which table?
FPSC - Database Administrator Model Papers -2026
Question 2
Which view shows which columns of a view can be updated?
FPSC - Database Administrator Model Papers -2026
Question 3
Which refresh option updates a materialized view automatically whenever the base table changes are committed?
FPSC - Database Administrator Model Papers -2026
Question 4
How can a view improve security?
FPSC - Database Administrator Model Papers -2026
Question 5
Which clause makes a view definition include only rows of a specific department?
FPSC - Database Administrator Model Papers -2026
Question 6
In a session, what must you call before using CURRVAL of a sequence?
FPSC - Database Administrator Model Papers -2026
Question 7
Why can gaps appear in sequence-generated numbers?
FPSC - Database Administrator Model Papers -2026
Question 8
What does the CYCLE option of a sequence do?
FPSC - Database Administrator Model Papers -2026
Question 9
Which view lists the sequences owned by the current user?
FPSC - Database Administrator Model Papers -2026
Question 10
Which statement lets all users refer to HR.EMPLOYEES simply as EMPLOYEES?
FPSC - Database Administrator Model Papers -2026