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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different sql server versions you have worked on? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what is grd?
Can you redefine a table online?
which background process invoke at the time of upgradation tell me???
what are the differences of where and if in SAS?
What is dbcc? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Where would you look for errors from the database engine?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
