What is the difference between TRANSLATE and REPLACE?
Translate is used for character by character substitution and Replace is used substitute a single character with a word.
How do we display rows from the table without duplicates?
Duplicate rows can be removed by using the keyword DISTINCT in the select statement.
What is the usage of Merge Statement?
Merge statement is used to select rows from one or more data source for updating and insertion into a table or a view. It is used to combine multiple operations.
What is NULL value in oracle?
NULL value represents missing or unknown data. This is used as a place holder or represented it in as default entry to indicate that there is no actual data present.
What is USING Clause and give example?
The USING clause is used to specify with the column to test for equality when two tables are joined.
[sql]Select * from employee join salary using employee ID[/sql]
Employee tables join with the Salary tables with the Employee ID.
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.
What Are The New Features In Mapviewer 11g?
Among the many new features and capabilities of MapViewer 11g are:
Certification on WebLogic Server version 10 and 10.3.
Powerful and open JavaScript/AJAX mapping API for interactive client side mapping.
Support for Safari desktop browser.
Support for ESRI Shape Files.
Support for Google Map tiles (requires a Google Maps API key).
Interface for 3rd party map tile servers (in JavaScript API).
Heatmaps.
Secure map rendering (role based map content display).
Support for OGC Web Feature Server themes and Annotation Text.
Improved Labeling, text styles, and feature rendering.
PDF output support.
Improved Non Spatial Data Provider and External Spatial Data Provider APIs.
Who Should Upgrade To 11g?
Customers who wish to take advantage of 11g’s new unified Oracle Universal Federation Framework.
Customers who wish take advantage of complimentary enterprise-class tools for system management, monitoring, auditing and reporting.
Customers who want to rapidly SSO-enable their federation partners using OpenSSO Fedlet.
Customers looking to accept identity from leading OpenID providers (Google, Yahoo, etc.) or interested in becoming an OpenID provider.
Customers who prefer to deploy OIF on best-of-breed Oracle WebLogic Server Platform.
Are 10g Customers Required To Upgrade?
Current OIF customers are not required to upgrade to 11g immediately.
Is It Possible To Upgrade From 10g To 11g?
Yes – the 11g installer automates the upgrade process from 10g to 11g.
Does Oracle Identity Federation Work With 10g Version Of Oracle Access Manager?
Yes – OIF 11g can work with both 10g and 11g versions of OAM.
Can Oracle Identity Federation 10g Run On Oracle Weblogic Server?
No – Customers who wish to deploy OIF on Oracle WebLogic Server, need to upgrade to 11g version.
Can Enterprise Manager Be Used To Manage Older Versions Of Oif?
No – Enterprise Manager Fusion Middleware Control can only be used to manage OIF 11g.
Oracle Identity Federation And Oracle Opensso Offer Similar Benefits. What Technology Should I Choose?
Oracle Identity Federation continues as Oracle’s strategic federation product.
Can Oracle Virtual Directory Manager 10g Be Used To Manage 11g Servers?
No – OVD Manager can only be used to manage 10g servers.
How Is Mapviewer Positioned In Fusion Middleware?
Fusion Middleware MapViewer is one of the J2EE components included in all editions of WebLogic Server, Oracle Application Server, JDeveloper/ADF, and TopLink.
Why Was Mapviewer Developed?
MapViewer was developed to simplify the development of applications that render and present location data as part of web, mobile, public sector and business applications. It is currently used by numerous Oracle applications and customer implementations.
How Is Mapviewer Licensed?
MapViewer is licensed as a feature of the all Fusion Middleware Application Server products (WebLogic Server and Oracle Application Server Editions) as well as the TopLink/ADF Deployment option.
How Is Mapviewer Delivered?
MapViewer is available for download from OTN and MyOracle Support (formerly Metalink). It will also be packaged on the Oracle Fusion Middleware Companion DVD for deployment in all supported, licensed environments. Supported deployment environments (J2EE servers) include: Oracle Weblogic Server, Oracle Application Server, and standalone OC4J.
Translate is used for character by character substitution and Replace is used substitute a single character with a word.
How do we display rows from the table without duplicates?
Duplicate rows can be removed by using the keyword DISTINCT in the select statement.
What is the usage of Merge Statement?
Merge statement is used to select rows from one or more data source for updating and insertion into a table or a view. It is used to combine multiple operations.
What is NULL value in oracle?
NULL value represents missing or unknown data. This is used as a place holder or represented it in as default entry to indicate that there is no actual data present.
What is USING Clause and give example?
The USING clause is used to specify with the column to test for equality when two tables are joined.
[sql]Select * from employee join salary using employee ID[/sql]
Employee tables join with the Salary tables with the Employee ID.
 |
| ATOS Most Frequently Asked Latest Oracle Interview Questions Answers |
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.
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.
What Are The New Features In Mapviewer 11g?
Among the many new features and capabilities of MapViewer 11g are:
Certification on WebLogic Server version 10 and 10.3.
Powerful and open JavaScript/AJAX mapping API for interactive client side mapping.
Support for Safari desktop browser.
Support for ESRI Shape Files.
Support for Google Map tiles (requires a Google Maps API key).
Interface for 3rd party map tile servers (in JavaScript API).
Heatmaps.
Secure map rendering (role based map content display).
Support for OGC Web Feature Server themes and Annotation Text.
Improved Labeling, text styles, and feature rendering.
PDF output support.
Improved Non Spatial Data Provider and External Spatial Data Provider APIs.
Who Should Upgrade To 11g?
Customers who wish to take advantage of 11g’s new unified Oracle Universal Federation Framework.
Customers who wish take advantage of complimentary enterprise-class tools for system management, monitoring, auditing and reporting.
Customers who want to rapidly SSO-enable their federation partners using OpenSSO Fedlet.
Customers looking to accept identity from leading OpenID providers (Google, Yahoo, etc.) or interested in becoming an OpenID provider.
Customers who prefer to deploy OIF on best-of-breed Oracle WebLogic Server Platform.
Are 10g Customers Required To Upgrade?
Current OIF customers are not required to upgrade to 11g immediately.
Is It Possible To Upgrade From 10g To 11g?
Yes – the 11g installer automates the upgrade process from 10g to 11g.
Does Oracle Identity Federation Work With 10g Version Of Oracle Access Manager?
Yes – OIF 11g can work with both 10g and 11g versions of OAM.
Can Oracle Identity Federation 10g Run On Oracle Weblogic Server?
No – Customers who wish to deploy OIF on Oracle WebLogic Server, need to upgrade to 11g version.
Can Enterprise Manager Be Used To Manage Older Versions Of Oif?
No – Enterprise Manager Fusion Middleware Control can only be used to manage OIF 11g.
Oracle Identity Federation And Oracle Opensso Offer Similar Benefits. What Technology Should I Choose?
Oracle Identity Federation continues as Oracle’s strategic federation product.
Can Oracle Virtual Directory Manager 10g Be Used To Manage 11g Servers?
No – OVD Manager can only be used to manage 10g servers.
How Is Mapviewer Positioned In Fusion Middleware?
Fusion Middleware MapViewer is one of the J2EE components included in all editions of WebLogic Server, Oracle Application Server, JDeveloper/ADF, and TopLink.
Why Was Mapviewer Developed?
MapViewer was developed to simplify the development of applications that render and present location data as part of web, mobile, public sector and business applications. It is currently used by numerous Oracle applications and customer implementations.
How Is Mapviewer Licensed?
MapViewer is licensed as a feature of the all Fusion Middleware Application Server products (WebLogic Server and Oracle Application Server Editions) as well as the TopLink/ADF Deployment option.
How Is Mapviewer Delivered?
MapViewer is available for download from OTN and MyOracle Support (formerly Metalink). It will also be packaged on the Oracle Fusion Middleware Companion DVD for deployment in all supported, licensed environments. Supported deployment environments (J2EE servers) include: Oracle Weblogic Server, Oracle Application Server, and standalone OC4J.