Give the stages of instance startup to a usable state where
normal users may access it.
Answer Posted / maqsood
- NOMOUNT
- MOUN
- OPEN
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you find out if a table can be redefined?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can a session indicate its interest in receiving alerts?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is a user-defined lock?
what are the differences of where and if in SAS?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
who owns the operating system files created by the utl_file package?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Query processing is slow(eg select query)how will u solve that
what is the use of recording information about current session?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA