Cognizant Most Frequently Asked Latest Oracle Interview Questions Answers
What Features Does Mapviewer Provide?
MapViewer is a programmable tool for rendering simple maps using spatial data managed by Oracle Spatial and/or Oracle Locator. MapViewer includes components that perform cartographic rendering, interactive scrollable maps, and a map definition tool to manage map metadata and portrayal information.
What Is Oracle Opensso Fedlet?
Oracle OpenSSO Fedlet (Fedlet) is feature of OIF 11g. It is a compact, easy to deploy SAMLv2 Service Provider implementation. It includes a small software package and a simple file-based configuration, embeddable into a Service Provider's Java EE or .NET application. Fedlet establishes SSO between an Identity Provider and a Service Provider without requiring a fully featured federation product on the Service Provider side. Deploying Oracle OpenSSO Fedlet does not require extensive knowledge of SAML.
Who Can Use Oracle Opensso Fedlet?
Fedlet is available to OIF 11g customers. OIF 11g customers can also distribute Fedlet to their partner’s organizations.
Can Oracle Opensso Fedlet Be Used With 10g Version Of Oif?
No – Customers who wish to distribute Fedlet to their federation partners need to upgrade to OIF 11g.
Can Oracle Opensso Fedlet Be Used With Oracle Opensso?
No – Customers who wish to distribute Fedlet to their federation partners need to migrate to OIF 11g.
Do Oracle Identity Federation And Fedlet Work With Homegrown And 3rd-party Implementation Of Samlv2?
Yes – OIF and Fedlet can be configured to work with proprietary and 3rd party SAMLv2 implementations, as long as the implementation is in compliance with SAMLv2 specification and supports the required SAMLv2 features.
What Is Oracle Identity Federation?
What Features Does Mapviewer Provide?
MapViewer is a programmable tool for rendering simple maps using spatial data managed by Oracle Spatial and/or Oracle Locator. MapViewer includes components that perform cartographic rendering, interactive scrollable maps, and a map definition tool to manage map metadata and portrayal information.
What Is Oracle Opensso Fedlet?
Oracle OpenSSO Fedlet (Fedlet) is feature of OIF 11g. It is a compact, easy to deploy SAMLv2 Service Provider implementation. It includes a small software package and a simple file-based configuration, embeddable into a Service Provider's Java EE or .NET application. Fedlet establishes SSO between an Identity Provider and a Service Provider without requiring a fully featured federation product on the Service Provider side. Deploying Oracle OpenSSO Fedlet does not require extensive knowledge of SAML.
Who Can Use Oracle Opensso Fedlet?
Fedlet is available to OIF 11g customers. OIF 11g customers can also distribute Fedlet to their partner’s organizations.
Can Oracle Opensso Fedlet Be Used With 10g Version Of Oif?
No – Customers who wish to distribute Fedlet to their federation partners need to upgrade to OIF 11g.
Can Oracle Opensso Fedlet Be Used With Oracle Opensso?
No – Customers who wish to distribute Fedlet to their federation partners need to migrate to OIF 11g.
 |
| Cognizant Most Frequently Asked Latest Oracle Interview Questions Answers |
Do Oracle Identity Federation And Fedlet Work With Homegrown And 3rd-party Implementation Of Samlv2?
Yes – OIF and Fedlet can be configured to work with proprietary and 3rd party SAMLv2 implementations, as long as the implementation is in compliance with SAMLv2 specification and supports the required SAMLv2 features.
What Is Oracle Identity Federation?
Oracle Identity Federation is a complete, enterprise-level and carrier-grade solution for secure identity information exchange between partners. With OIF organizations can do more business online by allowing their business partners secure access to protected applications. OIF significantly reduces the need to create and manage unnecessary identities in an enterprise directory and lowers the ongoing costs of partner integrations through support of industry federation standards. Oracle Identity Federation protects existing IT investments by integrating with a wide variety of data stores, user directories, authentication providers and applications.
What are privileges and Grants?
Privileges are the rights to execute SQL statements – means Right to connect and connect. Grants are given to the object so that objects can be accessed accordingly. Grants can be provided by the owner or creator of an object.
What is the difference between $ORACLE_BASE and $ORACLE_HOME?
Oracle base is the main or root directory of an oracle whereas ORACLE_HOME is located beneath base folder in which all oracle products reside.
What is the fastest query method to fetch data from the table?
Row can be fetched from table by using ROWID. Using ROW ID is the fastest query method to fetch data from the table.
What is the maximum number of triggers that can be applied to a single table?
12 is the maximum number of triggers that can be applied to a single table.
How to display employee records who gets more salary than the average salary in the department?
This can be done by this query –
Select * from employee where salary>(select avg(salary) from dept, employee where dept.deptno = employee.deptno;
1
Select * from employee where salary>(select avg(salary) from dept, employee where dept.deptno = employee.deptno;
What do you mean by GROUP BY Clause?
A GROUP BY clause can be used in select statement where it will collect data across multiple records and group the results by one or more columns.
What is a sub query and what are the different types of subqueries?
Sub Query is also called as Nested Query or Inner Query which is used to get data from multiple tables. A sub query is added in the where clause of the main query.
There are two different types of subqueries:
Correlated sub query
A Correlated sub query cannot be as independent query but can reference column in a table listed in the from list of the outer query.
Non-Correlated subquery
This can be evaluated as if it were an independent query. Results of the sub query are submitted to the main query or parent query.
What is cross join?
Cross join is defined as the Cartesian product of records from the tables present in the join. Cross join will produce result which combines each row from the first table with the each row from the second table.