What is VArray?
VArray is an oracle data type used to have columns containing multivalued attributes and it can hold bounded array of values.
How do we get field details of a table?
Describe <Table_Name> is used to get the field details of a specified table.
What is the difference between rename and alias?
Rename is a permanent name given to a table or a column whereas Alias is a temporary name given to a table or column. Rename is nothing but replacement of name and Alias is an alternate name of the table or column.
What is a View?
View is a logical table which based on one or more tables or views. The tables upon which the view is based are called Base Tables and it doesn’t contain data.
What is a cursor variable?
A cursor variable is associated with different statements which can hold different values at run time. A cursor variable is a kind of reference type.
How to display row numbers with the records?
Display row numbers with the records numbers –
Select rownum, <fieldnames> from table;
1
Select rownum, <fieldnames> from table;
This query will display row numbers and the field values from the given table.
What Are The Key New Features?
Multiple federation protocols in a unified, extensible and customizable architecture delivered via Oracle Universal Federation Framework (OUFF).
Oracle OpenSSO Fedlet - simple, lightweight SAML 2.0 component for Service Providers.
OpenID 2.0 support.
OOTB integration modules for multiple authentication providers (including Infocard, OAM, OSSO, etc.).
Advanced support for authentication mechanisms.
Support for Oracle WebLogic Server.
Single systems management and administration UI interface.
Enterprise-ready operational management and monitoring delivered via integration with Enterprise Manager Fusion Middleware Control.
Centralized Fusion Middleware logging, auditing, and reporting.
Unified Identity Management installer.
From Which Programming Languages Can The Mapviewer Api Be Called?
The MapViewer XML API can be called from any programming language that can submit and receive XML to/from WebLogic Server or Oracle Application Server (i.e. HTML forms, Java, C, OCI, Pro*C, PL/SQL, etc.). MapViewer will return an XML response that contains a URL to the map image, and additional metadata. MapViewer also provides a thin Java client API for interacting with the rendering engine through the HTTP protocol. MapViewer also provides a powerful and complete JavaScript/ AJAX API for developing highly interactive and performing web mapping applications. This API can be invoked from any web programming languages from HTML to PHP to ASP.NET.
Can Mapviewer Be Used Independently Of Oracle Fusion Middleware?
MapViewer is licensed only with Oracle Fusion Middleware product. It requires a J2EE container, JDBC, XML parsers and other components supplied with Oracle Fusion Middleware products. In addition, MapViewer applications can be deployed in any standard J2EE container provided the customer has sufficient licenses of Fusion Middleware products (WebLogic Server, Oracle Application Server, and/or TopLink/ADF Deployment option).
What Are The Benefits Of This Version?
Oracle Identity Federation 11g delivers the industry's most comprehensive implementation of federation standards delivered via Oracle Universal Federation Framework - unified, extensible and customizable architecture for rapid deployment in any multi-vendor environment.
OIF is the only federation solution on the market that comes deployed on a complimentary Oracle WebLogic - best-of-breed application server container in a default configuration.
Additionally, OIF 11g is the only federation solution on the market that comes with complimentary enterprise-class tools for monitoring, auditing and reporting in a default configuration.
Oracle Identity Federation 11g helps customers to quickly achieve cross-domain SSO by providing a complete end-to-end federation deployment package, including a simple and lightweight deployment option for Service Providers – Oracle OpenSSO Fedlet.
What Is Oracle Virtual Directory?
Oracle Virtual Directory provides a unified identity service to applications by aggregating without consolidation.
This allows applications to be deployed more quickly by enabling customers to re-use existing identity stores.
And by re-using existing identity stores – customers see a greater ROI on existing identity stores as well reduced compliance costs.
What Is Mapviewer?
MapViewer is a Java-based visualization tool that is used to render, in map form, location based content and spatial data stored using the spatial feature of Oracle Database. It includes It can also render map and related content from ESRI Shape Files, real-time XML feeds such as GeoRSS, and geographic web services including themes from OpenGeospatial Consortium Web Feature Services.
MapViewer can be used to:
Create customized maps that show geographic features such as roads, city areas, waterways and other transportation networks.
Display map themes such as national, state and local boundaries.
Visualize business data (e.g. population demographics, psychodemo graphics, sales metrics, etc.), to portray and explore relationships that can often best be expressed graphically as geographic maps.
Complement an applications workflow, providing interaction with mapped data.
Deliver custom maps over the Internet as a component of JDeveloper or as a standalone tool.
VArray is an oracle data type used to have columns containing multivalued attributes and it can hold bounded array of values.
How do we get field details of a table?
Describe <Table_Name> is used to get the field details of a specified table.
What is the difference between rename and alias?
Rename is a permanent name given to a table or a column whereas Alias is a temporary name given to a table or column. Rename is nothing but replacement of name and Alias is an alternate name of the table or column.
What is a View?
View is a logical table which based on one or more tables or views. The tables upon which the view is based are called Base Tables and it doesn’t contain data.
What is a cursor variable?
A cursor variable is associated with different statements which can hold different values at run time. A cursor variable is a kind of reference type.
 |
| Accenture Most Frequently Asked Latest Oracle Interview Questions Answers |
Display row numbers with the records numbers –
Select rownum, <fieldnames> from table;
1
Select rownum, <fieldnames> from table;
This query will display row numbers and the field values from the given table.
What Are The Key New Features?
Multiple federation protocols in a unified, extensible and customizable architecture delivered via Oracle Universal Federation Framework (OUFF).
Oracle OpenSSO Fedlet - simple, lightweight SAML 2.0 component for Service Providers.
OpenID 2.0 support.
OOTB integration modules for multiple authentication providers (including Infocard, OAM, OSSO, etc.).
Advanced support for authentication mechanisms.
Support for Oracle WebLogic Server.
Single systems management and administration UI interface.
Enterprise-ready operational management and monitoring delivered via integration with Enterprise Manager Fusion Middleware Control.
Centralized Fusion Middleware logging, auditing, and reporting.
Unified Identity Management installer.
From Which Programming Languages Can The Mapviewer Api Be Called?
The MapViewer XML API can be called from any programming language that can submit and receive XML to/from WebLogic Server or Oracle Application Server (i.e. HTML forms, Java, C, OCI, Pro*C, PL/SQL, etc.). MapViewer will return an XML response that contains a URL to the map image, and additional metadata. MapViewer also provides a thin Java client API for interacting with the rendering engine through the HTTP protocol. MapViewer also provides a powerful and complete JavaScript/ AJAX API for developing highly interactive and performing web mapping applications. This API can be invoked from any web programming languages from HTML to PHP to ASP.NET.
Can Mapviewer Be Used Independently Of Oracle Fusion Middleware?
MapViewer is licensed only with Oracle Fusion Middleware product. It requires a J2EE container, JDBC, XML parsers and other components supplied with Oracle Fusion Middleware products. In addition, MapViewer applications can be deployed in any standard J2EE container provided the customer has sufficient licenses of Fusion Middleware products (WebLogic Server, Oracle Application Server, and/or TopLink/ADF Deployment option).
What Are The Benefits Of This Version?
Oracle Identity Federation 11g delivers the industry's most comprehensive implementation of federation standards delivered via Oracle Universal Federation Framework - unified, extensible and customizable architecture for rapid deployment in any multi-vendor environment.
OIF is the only federation solution on the market that comes deployed on a complimentary Oracle WebLogic - best-of-breed application server container in a default configuration.
Additionally, OIF 11g is the only federation solution on the market that comes with complimentary enterprise-class tools for monitoring, auditing and reporting in a default configuration.
Oracle Identity Federation 11g helps customers to quickly achieve cross-domain SSO by providing a complete end-to-end federation deployment package, including a simple and lightweight deployment option for Service Providers – Oracle OpenSSO Fedlet.
Oracle Virtual Directory provides a unified identity service to applications by aggregating without consolidation.
This allows applications to be deployed more quickly by enabling customers to re-use existing identity stores.
And by re-using existing identity stores – customers see a greater ROI on existing identity stores as well reduced compliance costs.
What Is Mapviewer?
MapViewer is a Java-based visualization tool that is used to render, in map form, location based content and spatial data stored using the spatial feature of Oracle Database. It includes It can also render map and related content from ESRI Shape Files, real-time XML feeds such as GeoRSS, and geographic web services including themes from OpenGeospatial Consortium Web Feature Services.
MapViewer can be used to:
Create customized maps that show geographic features such as roads, city areas, waterways and other transportation networks.
Display map themes such as national, state and local boundaries.
Visualize business data (e.g. population demographics, psychodemo graphics, sales metrics, etc.), to portray and explore relationships that can often best be expressed graphically as geographic maps.
Complement an applications workflow, providing interaction with mapped data.
Deliver custom maps over the Internet as a component of JDeveloper or as a standalone tool.