Users Data Dictionary [Oracle]

User Connectivity
Configuring Oracle
NetClient PC Database
Oracle Net Basic Concepts
Finding Listener Service
Listener Control Program
Configuring Listener
Stop Restart Listener
Configuring OracleNet Client
Testing Client Connectivity
Testing OracleNet Connectivity
Check Default Domain
Connecting from Client
Oracle Net Conclusion
Password Files
Necessary Password Files
Password Creation Process
Placing | Naming PW File
Creating Password File
Remote Login Password
Connecting Internal Password
DBA Privileges
Different DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
OEM Architecture
Install OEM
Management Packs
Cloud Control Console
View Tablespace Info
Security Management Interface
Schema Object Interface
Oracle SQL Developer
SQL* Plus CLI
SQL Plus Reports
SQL Plus Column
SQL Plus Formatting
Formatting Numeric Columns
Oracle Date Columns
SQL Plus Scripting
SQL Plus Command
Suppress Repeating Columns
Line Page Break Reports
Report Headers Footers
Spooling Printing Report
Substitution Variables
Accept Prompt Commands
SQL Plus Editing Commands
SQL Plus Settings
SQL Plus Script
SQL Plus Conclusion
Creating Users
Manage Users
Before Creating User
Default Tablespaces
Temporary Tablespaces
Assign Disk Quotas
Creating Database User
OS Authentication
Granting Session Privileges
altering Database User
Changing User Password
Locking Users Account
Drop User
Data Dictionary User Info
Create manage Users
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges

1.	Which view is the primary source of information about database users? Please select the best answer.
	A.	`DBA_USERS_PRIMARY`
	B.	`DBA_USERS`
	C.	`DBA_USER_LIST`
	D.	`DBA_SYS_PRIVS`

2.	You have retrieved a list of tablespace quotas for a user and some quotas are a -1. What does a -1 mean here? Please select the best answer.
	A.	The user exceeded quota by creating too many objects and now has a negative balance.
	B.	The user is allowed to use up to 1 megabyte of space. Negative values represent megabytes.
	C.	The user has no limit on the amount of space that may be used. Negative values represent unlimited quota.
	D.	The user has not been assigned a quota on the tablespace. Negative values represent unassigned quotas.

3.	You need to see if a user can create objects in the tablespace named `USERS`. Which two things should you check? Please select all the correct answers.
	A.	Check the `DBA_TS_QUOTAS` view to see if the user has been assigned quota on that tablespace.
	B.	Check `DBA_USERS` to see if `USERS` is the default tablespace assigned to the user.
	C.	Check `DBA_SYS_PRIVS` to see if the user has been granted the `UNLIMITED TABLESPACE` privilege.
	D.	Check `DBA_TABLESPACES` to see if the user owns the tablespace.

4.	You run a query against `UNIFIED_AUDIT_TRAIL` selecting a column called `DB_USERNAME` and get an "invalid identifier" error. What is the most likely problem? Please select the best answer.
	A.	UNIFIED_AUDIT_TRAIL does not track usernames at all.
	B.	The correct column name is `DBUSERNAME`, with no underscore.
	C.	You must query `DBA_USERS` first to enable the username column.
	D.	Unified auditing must be explicitly enabled before this column becomes queryable.

5.	Before dropping a user with `CASCADE`, you want to know which foreign key constraints in other schemas will be dropped along with that user's tables. Which view should you query? Please select the best answer.
	A.	`DBA_DEPENDENCIES`
	B.	`DBA_OBJECTS`
	C.	`DBA_CONSTRAINTS`
	D.	`DBA_TAB_PRIVS`

Users and the Data Dictionary - Quiz