60:00
0/30 Attempted
Your Progress
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Score 0
Marks 0

FPSC - Database Administrator Model Papers -2026 — Test 6

Page 1 of 3

Review Skipped Questions

0
Question 1
Which statement changes a user's password?
FPSC - Database Administrator Model Papers -2026
Question 2
Which statement drops a user together with all objects the user owns?
FPSC - Database Administrator Model Papers -2026
Question 3
What is a schema?
FPSC - Database Administrator Model Papers -2026
Question 4
Which privilege allows a user to query any table in any schema?
FPSC - Database Administrator Model Papers -2026
Question 5
Which Oracle object sets password and resource limits for users?
FPSC - Database Administrator Model Papers -2026
Question 6
Which profile parameter sets the number of failed logins before an account is locked?
FPSC - Database Administrator Model Papers -2026
Question 7
Which clause allows a user to store objects in a tablespace?
FPSC - Database Administrator Model Papers -2026
Question 8
Which privilege allows administrative operations such as starting up and shutting down the database?
FPSC - Database Administrator Model Papers -2026
Question 9
Which utility creates the password file used for remote SYSDBA authentication?
FPSC - Database Administrator Model Papers -2026
Question 10
What is the purpose of database auditing?
FPSC - Database Administrator Model Papers -2026