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
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is a system database and what is a user database? : sql server DBA
What happens on checkpoint? : sql server DBA
how can you find out if a table can be redefined?
who owns the operating system files created by the utl_file 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.
Where would you look for errors from the database engine?
What are the different sql server versions you have worked on? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is fill factor? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is dbcc? : sql server DBA
what is the diffrence between core dba and apps dba?