Interested to Buy Any Domain ? << Click Here >> for more details...
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
- 1 Answers
- 5500 Views
- Flextronics, I also Faced
- E-Mail Answers
Answer / yasaswini
the major differences between Oracle9i and Oracle10g:
Major changes to SQL optimizer internals
Oracle Grid computing
AWR and ASH tables incorporated into Oracle Performance
Pack and Diagnostic Pack options
Automated Session History (ASH) materializes the Oracle
Wait Interface over time
Data Pump replaces imp utility with impdp
Automatic Database Diagnostic Monitor (ADDM)
SQLTuning Advisor
SQLAccess Advisor
Rolling database upgrades (using Oracle10g RAC)
dbms_scheduler package replaces dbms_job for scheduling
| Is This Answer Correct ? | 4 Yes | 0 No |
query to retrive the employees whose sal is greater than avg sal
What does sql stand for?
what is the stuff function and how does it differ from the replace function? : Sql dba
Define select, insert, create, delete, update, drop keywords
What is a stored procedure in sql with example?
What is difference between sql function and stored procedure?
What is #table in sql?
What is triggering circuit?
Cite the differences between execution of triggers and stored procedures?
IF i write before / after insert / update trigger and i do rollback what will happen?
when normalization is required
Mention what pl/sql package consists of?
-
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)
