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
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
