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
how does an oracle clusterware manage crs resources?
What is a system database and what is a user database? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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?
how to restore files with rman?
What is fill factor? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is transparent data encryption? : sql server DBA
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.
how can you enable flashback feature?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).