What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?
Answer / Ajay Kumar Dewabansi
A password file stores encrypted passwords for users. While it's possible to authenticate users using the data dictionary tables, using a password file improves security as the actual passwords are not stored in plain text. Also, it simplifies administrative tasks by allowing centralized management of passwords.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the various benefits of using rac architecture?
Mention what are the main components of an oracle rac system?
How would you identify the shared_pool_size parameter that needs to be adjusted?
What do you understand by row chaining?
How do you recover a lost control file?
What are the different optimizers that are used to optimize database?
How is clustered index different from non-clustered index?
How oracle flex asm works?
What is a recovery catalog?
Mention what is new feature in oracle asm 12c?
What is the difference between single instance environment and rac environment?
What are the key characteristics of rac or why to use rac?