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
how to restore files with rman?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Why would you call update statistics? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what are the differences of where and if in SAS?
What are statistics, under what circumstances they go out of date, how do you update them?
What is a correlated sub-query? : sql server DBA
Can you redefine a table online?
what are the performance views in an oracle rac environment?
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
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA