FPSC - Database Administrator Model Papers -2026 — Test 13
Page 1 of 3
Question 1
Which statement defines a unified audit policy?
FPSC - Database Administrator Model Papers -2026
Question 2
Which package is used for fine-grained auditing (FGA)?
FPSC - Database Administrator Model Papers -2026
Question 3
Which column of DBA_USERS shows whether an account is OPEN, LOCKED or EXPIRED?
FPSC - Database Administrator Model Papers -2026
Question 4
Which Oracle feature masks sensitive column values in query results without changing stored data?
FPSC - Database Administrator Model Papers -2026
Question 5
Which Oracle option provides row-level access control using sensitivity labels?
FPSC - Database Administrator Model Papers -2026
Question 6
Which function returns details such as the session user from the application context?
FPSC - Database Administrator Model Papers -2026
Question 7
What does ALTER USER ali DEFAULT ROLE report_role; control?
FPSC - Database Administrator Model Papers -2026
Question 8
What is the effect of revoking a system privilege that was granted WITH ADMIN OPTION?
FPSC - Database Administrator Model Papers -2026
Question 9
Which statement removes a role from the database?
FPSC - Database Administrator Model Papers -2026
Question 10
Which type of attack does using least-privilege application accounts help limit?
FPSC - Database Administrator Model Papers -2026