How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
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 |
What are the different types of constraints?
What is query syntax?
What is Difference between StoredProcedure and function?
How do you pronounce sql?
What are all the different normalization?
What are sql functions? Describe in brief different types of sql functions?
How do you retrieve the second highest salary from a table?
Difference between truncate, delete and drop commands?
What company owns postgresql?
There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
Is not equal in sql?
How do I view stored procedures?
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)