WGU D192 - Section 2 - Managing users Questions With Correct Answers!!

Password-Authenticated Users - Answer-database-authenticated accounts - encrypted password is stored in the data dictionary Externally Authenticated Users - Answer-Authenticated through the operating systems, not the database Globally Authenticated Users - Answer-uses a security service suchas KERBEROS or RADIUS What happens if a TABLESPACE is not specified during account creation? - Answer-they are assigned to the default TABLESPACE DATABASE_PROPERTIES - Answer-used to view current default tablespace and temporary tablespace Space Quota - Answer-not set by default, this is the amount of space a user can consume DROP USER username CASCADE; - Answer-will drop the user and all objects owned by that user DBA_USERS_WITH_DEFPWD - Answer-dictionary view that shows the database user accounts crated by Oracle that use a default password Object Privileges - Answer-A system privilege is the right to perform a particular action or to perform an action on any object of a particular type. Objects include tables, views, materialized views, indexes, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages. System Privileges - Answer-permissions to database-level operations, connecting to the data base, creating users, altering the database, consuming unlimited amounts of tablespace, and querying all tables in the database Role Privileges - Answer-permissions granted to a user by a way of a roleTable Object privilege: SELECT - Answer-the table owner permits the grantee to query the specified table with a select statement Table Object privilege: INSERT - Answer-allows the user to create new rows in a specified table using the INSERT statement Table Object privilege: UPDATE - Answer-allows user to modify existing rows with the MODIFY statement Table Object privilege: DELETE - Answer-allow uses to delete rows with the DELETE statement Admin Table Privilege: ALTER - Answer-allows user to add, modify or rename columns, to move a table to a different tablespace or rename a table Admin Table Privilege: DEBUG - Answer-allows user to access trigger code via the debugger Admin Table Privilege: INDEX - Answer-allows users to create new indexes, the owner of a table does not need this privilege to create an index Admin Table Privilege: REFERENCES - Answer-allows user to create foreign key constraints View Object Privilege: SELECT - Answer-allows user to query a view View Object Privilege: INSERT - Answer-allows user to insert rows to a view