- #Difference between oracle 10g and 11g interview questions full#
- #Difference between oracle 10g and 11g interview questions Offline#
It offers several supporting grid computing features of the likes of automatic load balancing, resource sharing, etc. Along with other tools and features, Oracle 10g provides an application server and a database management system (DBMS). Oracle 10g is a computing product group belonging to Oracle's grid.
They will be referred to through to SQL statements or as conditions in SQL statements. The hidden columns, after being assigned, will not be available through a generic query. Invisible columns are capable of being defined in a table in Oracle 12c. The hidden column feature is not present in Oracle 11g. are some practical and useful enhancements introduced in Oracle 11g as new features.
#Difference between oracle 10g and 11g interview questions Offline#
The online and offline methods of migrating table partitions and subpartitions can be easily implemented in oracle 12c. Table partitions and subpartitions movementĬomplex, time-consuming procedural logic has to be written by users for moving partitions/ subpartitions from one tablespace to another. Oracle 12c supports the In-memory aggregation concept. This version of Oracle does not support the In-memory aggregation concept. The table has to be added to the memory so that high-speed data can be accessed easily by the users.
#Difference between oracle 10g and 11g interview questions full#
In-memory tables are used for full table scans and are supported by Oracle 11g. Big table cache provides significant performance benefits in terms of workloads that were earlier limited by I/O response time or throughput. The automatic big table caching serves to be a new concept in Oracle 12C. This new version of Oracle’s cache mechanism, referred to as big table cache, improves upon the performance metric for a full table scan. Additionally, it is not possible to implement Full Database caching in this version of Oracle. The In-memory parallel query statement does not work to perfection with multiple scans contended for the cache memory in Oracle 11g. LISTAGG and Nth_value are some new features and services in Oracle 11g.Īpprox_count_distinct () is a new feature in 12c it offers an approximation of distinct count aggregation. It does not consider the performance tuning of data in the given tables. Despite the creation of more than one index, only one column is capable of being used at any given point of time. Multiple indexes may be created on the same column. Additionally, the ideal index tool can be used in Oracle 11g. It is possible to create just a single index on any one table column. Differences between Oracle 11g and Oracle 12c Basis of differentiation
0 kommentar(er)
