Kindly answer this below query have asked in an interview,
When we open database in restricted mode? User can connect the db or not?
Thanks in advance.
Oracle Startup, open, mount no mount
Special Parameterization files (SPFILE) All the changes that are made requires a reboot of Oracle database. In order to change certain parameters SPFILE is maintained. We need to explicitly...
Oracle Database Interview Questions and Answers
1. On which component can I open an SAP message if there are problems with the Oracle database?The following components are available:BC-DB-ORA: OracleBC-DB-ORA-DBA: BR*TOOLS for the database...
Database not Opening
We have an amazing situation that we don't have the lastdays backup (as backup was not properly taken up) The database gets mounted but don't get opened as one of the data file is missing. Is...