Answer Posted / kittu
1) ORACLE_BASE has been introduced
2) ADR(Automatic Diagnostic Repository) added ( instead of udump, bdump, cdump in oracle 10g)
3) Case sensitive passwords
4) Data recovery advisor in RMAN
5) For db cloning in RMAN "from active database" command
6) SYSASM system level privilege has been introduced
7) New initialization parameter memory_target (instead of sga_target & pga_target)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
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?
What is transparent data encryption? : sql server DBA
What is replication? : sql server DBA
What are the recovery models for a database? : sql server DBA
What is a system database and what is a user database? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What happens on checkpoint? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
how does an oracle clusterware manage crs resources?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are the different ways you can create databases in sql server? : sql server DBA
what do you understand by fine-grained auditing?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
