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
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 are the different types of database compression introduced in sql server 2008? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : 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
how can you create a user-defined lock?
Why would you call update statistics? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
. 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?
how does an oracle clusterware manage crs resources?
What happens on checkpoint? : sql server DBA
what is the role of dip user in our database?
What is dcl? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?