How can we see the database version in os level
Answer Posted / kittu
]$ $ORACLE_HOME/OPatch/optach lsinventory -all
the above statement will display total oracle software locations
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
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.
Query processing is slow(eg select query)how will u solve that
Why would you call update statistics? : sql server DBA
What authentication modes does sql server support? : sql server DBA
what do you understand by flashback feature of oracle?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you schedule a job in database?
What the different components in replication and what is their use? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is the difference between clustered and non-clustered index? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit