0 — Test 635
Page 1 of 3
Question 1
Which statement lets all users refer to HR.EMPLOYEES simply as EMPLOYEES?
FPSC - Database Administrator Model Papers -2026
Question 2
Which view lists the synonyms owned by the current user?
FPSC - Database Administrator Model Papers -2026
Question 3
Which clause assigns a tablespace for a user's sort operations?
FPSC - Database Administrator Model Papers -2026
Question 4
What does PASSWORD EXPIRE do when used in ALTER USER?
FPSC - Database Administrator Model Papers -2026
Question 5
Which of the following is a system privilege?
FPSC - Database Administrator Model Papers -2026
Question 6
Why might a stored procedure fail with 'table or view does not exist' even though the owner has SELECT through a role?
FPSC - Database Administrator Model Papers -2026
Question 7
Which clause makes a PL/SQL unit run with the privileges of the caller?
FPSC - Database Administrator Model Papers -2026
Question 8
How can a role be protected so that it needs a password to be enabled?
FPSC - Database Administrator Model Papers -2026
Question 9
Which statement enables or disables roles in the current session?
FPSC - Database Administrator Model Papers -2026
Question 10
Which view shows object privileges that have been granted to users?
FPSC - Database Administrator Model Papers -2026