Oracle Database Administration from Zero to Hero - Practice - Managing Users and User Security (Part 2 of 2)

This video tutorial covers managing user tablespace quotas and password settings in a database. It demonstrates creating a tablespace, setting user quotas, and handling errors when quotas are exceeded. The tutorial also explores password management settings in user profiles, including creating users with specific profiles and handling account locking due to failed login attempts. The session concludes with a summary and cleanup of the practice exercises.

What is the initial size of the tablespace created in the tutorial?

• 15 megabytes

• 5 megabytes

• 20 megabytes

• 10 megabytes

What error occurs when the tablespace reaches its maximum size?

• Memory allocation error

• Unable to extend table error

• Quota limit error

• Data overflow error

How many user profiles are available in the database?

• 5

• 4

• 3

• 2

Which profile has more restricted password limits than the default profile?

• GSM Prof

• Default Profile

• Ora Stig Profile

• DBCA Profile

What happens after four failed login attempts with the wrong password?

• The account is deleted

• The password is reset

• The account is locked

• The user is logged out

What must a user do if their account is locked due to failed login attempts?

• Wait for 24 hours

• Contact the administrator

• Create a new account

• Reset their password

What is the final step in the sub practice for managing database users?

• Create a new user

• Unlock the account

• Drop the created user

• Change the user profile