Cyient Most Frequently Asked Latest Oracle Interview Questions Answers
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.
What are temporal data types in Oracle?
Oracle provides following temporal data types:
Date Data Type – Different formats of Dates
TimeStamp Data Type – Different formats of Time Stamp
Interval Data Type – Interval between dates and time
How do we create privileges in Oracle?
A privilege is nothing but right to execute an SQL query or to access another user object. Privilege can be given as system privilege or user privilege.
[sql]GRANT user1 TO user2 WITH MANAGER OPTION;[/sql]
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 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.
What are temporal data types in Oracle?
Oracle provides following temporal data types:
Date Data Type – Different formats of Dates
TimeStamp Data Type – Different formats of Time Stamp
Interval Data Type – Interval between dates and time
How do we create privileges in Oracle?
A privilege is nothing but right to execute an SQL query or to access another user object. Privilege can be given as system privilege or user privilege.
[sql]GRANT user1 TO user2 WITH MANAGER OPTION;[/sql]
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.
 |
| Cyient Most Frequently Asked Latest Oracle Interview Questions Answers |
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.
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).