How can we see the database version in os level
Answer Posted / suman
]$echo $ORACLE_HOME
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How would you go about verifying the network name that the local_listener is currently using?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What purpose does the model database server? : sql server DBA
What is a correlated sub-query? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what are the performance views in an oracle rac environment?
What is the difference between clustered and non-clustered index? : sql server DBA
what is a user-defined lock?
What is dbcc? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What are the different types of indexes available in sql server? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the importance of a recovery model? : sql server DBA