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 |
Give two examples of referential integrity constraints.
Which environment variables are absolutely critical in order to run the OUI?
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Explain how you would restore a database using RMAN to Point in Time?
When creating a user, what permissions must you grant to allow them to connect to the database?
what is a crs resource?
What does coalescing a tablespace do?
Explain about your sql server dba experience? : sql server DBA
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
how does an oracle clusterware manage crs resources?
what is the difference between hot backup n rman backup?
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)