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 |
Explain the use of table functions.
what is ora 600?
What is a correlated sub-query? : sql server DBA
why we use cursors
Describe what redo logs are.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Compare and contrast TRUNCATE and DELETE for a table.
What is the default port no on which sql server listens? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what is meant by gateway
one datafile is lost in standy side how can you recover that??
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)