How can we see the database version in os level
Answer Posted / james alalade
sqlplus -v
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what are the performance views in an oracle rac environment?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Where would you look for errors from the database engine?
Explain materialized views and how they are used.
Why would you use sql agent? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What types of replication are supported in sql server? : 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
how can you implement fine-grained auditing?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA