Oracle 11g new features?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sam
online patching,Tables can changed to read only,In datapump
parameter compression can have following values 1)
data_only,2)metadata_only,3)all,4)none
| Is This Answer Correct ? | 1 Yes | 0 No |
How do you tell what your machine name is and what is its IP address?
how can you connect from 10g user to 11g user??
how can you process messages in order asynchronously?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
What the different types of replication and why are they used? : sql server DBA
What is RAID and what are different types of RAID configurations?
What is the default fill factor value? : sql server DBA
Hot backup procedure?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What authentication modes does sql server support? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)