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 |
What is the dataguard background process??
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
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 are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
wat is global index and local indes
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
when does an alert gets signaled?
Explain about your sql server dba experience? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
Oracle (3253)
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)