CPSA EXAM SCRIPT FINAL PAPER 2026 SOLVED QUESTION SET GRADED A+

CPSA EXAM SCRIPT FINAL PAPER 2026
SOLVED QUESTION SET GRADED A+



◉Oracle : SELECT Commands. Answer: SELECT * FROM v$version; :
DB Version
(SELECT version FROM v$instance;)


SELECT instance_name FROM v$instance : Current DB
(SELECT name FROM v$database;)


SELECT DISTINCT owner FROM all_tables; : List DBs


SELECT user FROM dual; : Current User


SELECT username FROM all_users ORDER BY username; : List users


SELECT column_name FROM all_tab_columns; : List Columns


SELECT table_name FROM all_tables; : List Tables

,SELECT name, password, astatus FROM sys.user$; : List password
hashes


◉host.equiv (or .rhosts file) Structure. Answer: Allow any user to log
in from any host:


+


Allow any user from host with a matching local account to log in:


host


Allow any user from host to log in:


host +


Allow user from host to log in as any non-root user:


host user


Allow all users with matching local accounts from host to log in
except for baduser:

, host -baduser
host


Deny all users from host:


-host


Allow all users with matching local accounts on all hosts in a
netgroup:


+@netgroup


Disallow all users on all hosts in a netgroup:


-@netgroup


Allow all users in a netgroup to log in from host as any non-root
user:


host +@netgroup