How can we see the database version in os level
Answer Posted / vivek
Run sqlplus command and check.
$sqlplus username/password@connection string
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
which background process invoke at the time of upgradation tell me???
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Where would you look for errors from the database engine?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps 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 is the importance of a recovery model? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is a correlated sub-query? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you schedule a job in database?
how can you implement fine-grained auditing?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
when does an alert gets signaled?