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 difference between clustered and non-clustered index? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you get actual data change values from previous transactions in oracle?
What authentication modes does sql server support? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is grd?
What is a system database and what is a user database? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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?
Explain materialized views and how they are used.
what do you understand by flashback feature of oracle?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
. 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?
what do you understand by fine-grained auditing?