Samsung Electronics Most Frequently Asked Latest Oracle Interview Questions Answers
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.
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.
 |
| Samsung Electronics Most Frequently Asked Latest Oracle Interview Questions Answers |
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.
Post a Comment