November 2023
To switch from an init.ora file to a spfile, we should create spfile from pfile command then shutdown instance and...
- Interview
- November 30, 2023
Hot backup is also recognized as an online backup because the backup happens while the database is active and running....
- Interview
- November 30, 2023
The main four types of backups in Oracle are: (ⅰ) COLD Backup (ⅱ) HOT Backup (ⅲ) Import – Export Backup...
- Interview
- November 30, 2023
There are two types of synonyms: public and private. A public synonym isn’t part of any schema. A public synonym...
- Interview
- November 30, 2023
A synonym is an identifier that can be used to reference another database object in a SQL statement. A table, view,...
- Interview
- November 30, 2023
A DBA has the authority to create new users, remove the existing users, or modify any of the environment variables...
- Interview
- November 30, 2023
