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.
What is Restricted Mode of Instance Startup ?
An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED...
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...