What is new features in Oracle 11g?
Enhanced Finer Grained Dependency Management. DDL With the WAIT Option (DDL_LOCK_TIMEOUT) Invisible Indexes. Cross-Session PL/SQL Function Result Cache.
Which among the following is the new features of Oracle Database?
It introduces two new functions, XMLQUERY and XMLTABLE. You can use the XQuery language from an SQL client to query Oracle XML DB repository documents, XML views over relational data, and XMLType data, whether persistent or generated.
What is the latest version of Oracle 11g?
0.3) New Features and Enhancements.
What are Oracle features?
Features of Oracle In a multiuser database, it is required to control data consistency and concurrency which are contemplated by Oracle. Availability: Real-time applications require high data availability. High performing computing environments are configured to provide all-time data availability.
What is new features in Oracle 12c?
Oracle Database 12c has a new feature called “Identity Columns” which are auto-incremented at the time of insertion (like in MySQL). SQL> create table dept (dept_id number generated as identity, dept_name varchar);
What is the best feature of Oracle Database 11g?
Perhaps its best feature is that it is built-in; all you have to do is turn it on. More likely than not, you didn’t. In Oracle Database 11g, the password management function has new and improved verification logic.
What is Oracle Enterprise Manager in Database 11g?
In Oracle Database 11 g, Oracle Enterprise Manager contains all the tools to perform these tasks. Here is a screenshot of the Server tab of the Database Homepage. Note the section titled Security at the lower right hand side.
What’s new in Oracle 11g Release 2?
This is the age of v6-style IP addressing and Oracle has caught up. In 11g Release 2 you can use IPv6-style addresses in addition to the legacy IPv4 style. This applies to the packages where IP addresses are referenced.
How do I make security decisions in Oracle Database 11g?
In previous versions most security operations are made through a tool called Oracle Security Manager. In Oracle Database 11 g, Oracle Enterprise Manager contains all the tools to perform these tasks. Here is a screenshot of the Server tab of the Database Homepage. Note the section titled Security at the lower right hand side.