Oracle Interview Questions and Answers

Introduction

Oracle is a Texas-based software company dealing in computer technology operations. It is known for its database software and technology, cloud engineered systems and enterprise software products. The company also builds tools for database development.

It is necessary to know about Oracle when you are seeking a job in an IT company. Oracle interview questions play an important role here. Your Oracle Interview experience suddenly gets better when you know about the basic things about Oracle. Oracle develops software for various functions that support smooth functioning in the IT sector. Oracle ATG, Oracle 11g, ORACLE Demantra are few software applications one should know for a good command in the interview. All these applications are necessary from an interview point of view.

In this article, you can find the following things:

• Oracle ATG interview questions and answers
• Oracle 11g Interview Questions and answers
• Oracle Demantra interview questions and answers

These questions will surely assist you in knowing things better and enhancing your confidence.

Oracle ATG Interview Questions and Answers

Organisations all around the world are getting benefitted from Oracle’s ATG software. It is a web commerce application designed to provide a personalised experience to the customers. Due to the advent of online shopping, this particular application is gaining importance. One should know things about this software for appearing for an interview in some related field. Some questions related to the software are:

1. What can you tell about ATG and its core?

The abbreviation ATG stands for Art Technology Framework. The use of this software is by the online shopping websites to improve their website performance. A good shopping experience leads to an increase in sales and thus improving the business. ATG helps in providing a personalised experience to the customers. Many features can be added to the website using ATG to attract customers. These features include automated recommendations, live help service, content personalisation, marketing, merchandising etc. All of this at the end assists in improving the shopping experience. ATG works on the J2EE standards.

Dynamic Application  Framework (DAF) is the core of ATG. DAF executes a component development model based on Java Beans and Java Server Pages (JSP). This helps to create mobile applications along with traditional computer applications.

2. What can you tell us about ATG Repositories and their types?

For this Oracle interview question, your answer could be; The interface between your database and your ATG application is known as a repository. At the macro level, any web application comprises two components that are source code and a database.To modify your source code, you can use the database. The repository is that interface that allows you to do so.

In other words, a repository gives us a user-friendly interface that helps us in accessing the data in our database. It helps in improving the source code. Our data is made available to us in the form of a Java Object.

There are two kinds of repositories available. They are as follows:

• SQL Repository: This Repository uses the General SQL Adapter (GSQ). The function of this repository is to map between ATG and the data stored in the SQL database.
• Versioned Repository: SQL Repository extension that is used in ATG Content Administration is known as a Versioned Repository. Every set of data has a different version in this repository. When new data is entered, the previous one remains intact. A new space emerges for the latest data with a different version number. It is an effective way of managing things.

3. What knowledge do you have regarding pipelines and their types?

The pipeline is an execution manager. It is known to provide modular code execution. ATG commerce uses pipelines frequently for various executive functions. The tasks that are accomplished by using pipelines are loading an Order, saving an Order, and checking out an order.

The two types of pipelines used by ATG in Dynamo are as follows:

• DAS Servlet Pipeline: JHTML requests are handled by using this pipeline.
• DAF Servlet Pipeline: This pipeline is used to handle JSP requests.

4. Tell us something about the nucleus in ATG?

The nucleus is a container for different components of ATG. A nucleus component is nothing more than a configuration file that uses Java Class and is associated with a .properties file extension. The use of a nucleus is to create and initialise component instances on request. The management of the component class is also through the nucleus. It discovers the properties file for the component. By this, it relinquishes the class file of the component. The nucleus is essential for the proper functioning of ATG.

5. Can you tell us about caching and enumerate its different modes?

The type of memory used often to improve the speed of data is known as a cache. The data required for any process usually remains in the main memory. But temporarily, this data is transferred to the cache memory if it is used very often. Caching is the process of saving and obtaining data from the cache.

The five different modes of caching are:

• Simple
• Locked
• Distributed
• Distributed JMS
• Distributed Hybrid

6. What are the types of cache found in ATG? Elaborate.

There are two types of cache present in ATG. They are:

• Item cache: It is the cache that holds value for the repository items. Various repository item IDs are present here.
• Query cache: The repository IDs are present in the query cache for the items that match particular queries in the cache.

(Please pay attention to what the Oracle interview question states if the interviewer has asked you to elaborate, then go ahead and elaborate.)

7. What can you tell us about a droplet in ATG? Also, can you tell us about the input parameters for each droplet?

Droplets work as the backbone of the front-end content for all applications of ATG. Droplets assist in weaving the dynamic content into Java Server Pages effortlessly. A person with no knowledge about JavaScript can also perform this task efficiently with the droplets. It becomes easy to control the rendering of dynamic content with droplets.

The input parameters for each droplet are as follows:

• Array
• Element Name
• Index Name

8. What all things do you know about ATG DPS?

The answer to this Oracle interview question could be; DPS is an abbreviation for Dynamo Personalisation System. The data in the user profile is analysed, and personalised content appears in front of the user. All this is according to the business rules and for the better experience of the user. The prime motive of ATG is to provide personalised material to the user and enhance their interest in the site.

The components of ATG DPS are:

• User Profile Management System
• Content Targeting System
• Targeted email System

9. What can be the possible performance issues you can face with ATG?

Performance issues refer to the problems faced when the processing of the tasks is not taking place at the expected or previously observed speed. Some common performance issues are listed below:

• The response time can be slow.
• There can be an issue with CPU utilisations.
• SQL queries that are running for very long can create a problem.
• When the database activities are at a high level, the performance gets slowed down.
• Slow CA deployments can create problems.

10. Can you tell us about the use of Price Lists?

This is one of the most asked Oracle interview questions.Price Lists help to target specific prices to a targeted group of users. Price Lists can be effective in implementing business to business pricing. Every customer can have unique pricing based on contracts, RFQs and pre-negotiation prices. The management of Price Lists is through a single interface ACC which consists of a list of SKU IDs, Product IDs, and configurable SKU IDs. Multiple lists can be created and managed with this feature. Name, Base Price List, Creation Date, Last Modified Date, Start Date, End Date are some of the features seen in every Price List.

These are the common Oracle ATG Interview Questions. These questions are important if you are going to give interviews. You can probably get your dream job if you know this much about ATG. With the advancements in technology, the use of ATG has become common, and it is necessary to know about it. These questions will give you an orientation about the software.

Oracle 11g Interview Questions and Answers

Oracle 11g Interview Questions have a special place in the interviews of various IT companies. In the technical tests, campus placements or job universities, Oracle 11g questions are frequent. One should know about this to have a good Oracle interview experience.

Oracle 11g is software used to exchange information between the partners securely. It is of great assistance in the business. It has a design to reduce the need to manage and create unnecessary identities. Due to the expanding benefits of the software, knowledge about it becomes more necessary. Some of the questions related to Oracle 11g are here:

11. Tell us something about Oracle Identity Federation and list some of its benefits?

To answer this Oracle interview question, you could say; Oracle Identity Federation is a solution that enables the secure exchange of data between business partners. It is a complete, enterprise-level, career-grade package. The OIF allows the organisations to provide their partners with secure access to any protected software online.

The need of creating various identities in an enterprise directory becomes less. The cost of partner integrations also comes down.OIF can integrate with several user directories, data stores, and authentication providers that help in protecting IT investments.

Oracle Universal Federation framework is unified, extensible, and customisable.It allows rapid deployment in any multi-vendor environment.

OIF comes deployed on a complimentary oracle Web Logic that is a best-of-breed application server container in a default configuration.

OIF 11g comes with complimentary enterprise-class tools for monitoring, auditing and reporting in a default configuration.

12. Enumerate some of the features of Oracle 11g?

Some new features of Oracle 11g are:

• Oracle Universal Federation Framework (OUFF) provides Multiple federations protocols in a unified, extensible and customisable architecture.
• It provides a simple, lightweight SAML 2.0 component for service providers known as Oracle OpenSSO Fedlet.
• Open ID 2.0 support is also present.
• OOTB integration modules are present for the multiple authentication providers.
• Authentication mechanisms have advanced support.
• The Identity management installer is unified.
• The UI interface is for single systems management and administration.

13. Who should upgrade to Oracle 11g?

This is a frequently asked Oracle interview question. Some of the reasons for which the customers should upgrade to Oracle 11g are:

• Customers who want to have the advantages of Oracle 11g should switch to it.
• The customers can take advantage of complimentary enterprise-class tools for system management, monitoring, auditing and reporting CA; upgrade to Oracle 11g.
• Customers who want to SSO enable their partners can do so by upgrading. Up-gradation can give access to open SSO Fedlet.
• Customers who want to deploy OIF on Web Logic Server Platform.
• Customers who wish to become open ID Providers.

14. Can you tell us something about the Oracle OpenSSO Fedlet?

The Oracle OpenSSO Fedlet is a feature of Oracle 11g. It is a SAMLv2 Service Provider. This compact and easy to use Fedlet is embeddable into a service provider’s NET application or Java EE . It includes a little software package and a small file-based configuration. Fedlet is used to establish SSO between a Service Provider and an Identity Provider.

15. Tell us about Oracle Virtual Open Directory and list some of its benefits?

You could answer this Oracle interview question by saying; The applications are deployed more quickly with the use of OVD. It occurs by enabling the customers to re-use existing identity stores. When existing identity stores are re-used, customers see an increased ROI on existing identity stores and reduced compliance costs. 

Some of the benefits of OVD are listed here:

• The aggregation of identity sources takes place without consolidation with the help of OVD.
• OVD 11g comes with enterprise-class monitoring and reporting in the default configuration. It is the only virtual directory in the market that comes with these features.

16. What do you know about a Map Viewer?

Map Viewer is a visualisation tool. This JAVA-based tool is used to render, in map form, location-based content and spatial data stored using the spatial feature of the Oracle database. It also supports rendering content from real-time XML feeds, ESRI Shape Files such as GeoRSS, and geographical web services. It also includes themes from Open Geospatial Consortium Web Feature Services.

some of the uses of Map Viewer are:

• It is used to create customised maps that show geographical features such as roads, city areas, transportation networks etc. 
• It can also display map themes such as national, local and several others.
• Business data like Population demographics, sales metrics etc., can be visualised using Map Viewer. 
• It is used to complement the workflow of an application, providing interaction with mapped data.

17. List some of the new features of Map Viewer 11g?

Many new features have been added to Map Viewer 11g. Some of them are:

• Use of JavaScript that is powerful and open for interactive client-side mapping.
• Support for Safari Desktop Browser is provided in the new version of Map Viewer.
• Support for ESRI shape Files and support for Google Maps Files are the new features added in the Map Viewer 11g.
• Interface for third party tiles is present in the new version.
• Heat maps have been introduced.
• Labelling, text styles and feature rendering are improved.
• Improved versions of External Spatial Data Provider and  Non-Spatial Data Provider APIs are present in the Map Viewer 11g.
• PDF output support is a new feature.
• Secure map rendering is possible with the new version of Map Viewer.

18. Tell us something about the development, licensing and delivery of the MapViewer?

• Development: The motive behind the development of Map Viewer was to simplify the development of applications that render and present location data as part of the web, mobile, public sector and business applications. Many Oracle applications and customer implementations use Map Viewer.
• Licensing: Map Viewer is licensed as a tool for all Fusion Middleware Application Server products. It can also be licensed for TopLink/ADF Deployment option. 
• Delivery: Map Viewer is available for download at OTN and MyOracle support. 

19. List some programming languages from which the Map Viewer API can be called?

This is an important Oracle interview question. Any programming language that can receive and submit XML to/from Oracle Application server or WebLogic server can call the Map Viewer. Map Viewer will send an XML response that contains a URL to the map image and additional metadata. A thin Java client is provided by the Map Viewer. It is to interact with the rendering engine through HTTP protocol. This tool provides powerful and complete JavaScript. It helps in developing highly interactive and performing web map applications. This API can be provoked from several languages. These languages include everything from HTML to PHP to ASP.NET.

20. Is MapViewer used independently or with Oracle Fusion Middleware?

Map Viewer can never be licensed independently. It can only be licensed as a feature of the Oracle Fusion Middleware products. It also requires a JDBC, XML parser, J2EE container, and other components so that it can be licensed along with the Fusion Middleware products. If the customer has enough licensing for Fusion Middleware products, then the Map Viewer applications can be deployed in any J2EE container.

These are the commonly asked Oracle 11g questions. Everything today is shifting to online-based systems. With these advancements, the environment provided for the exchange should also be safe. It will make things simple and reliable. Here comes the role of Oracle 11g, which helps the companies to achieve all this. Also, before hiring an employee, the companies want to make sure that the candidate knows about the basic stuff regarding Oracle 11g, open SSO Fedlet and others. 

Most of the frequently asked questions are mentioned above. These questions can improve your Oracle interview experience along with increasing the chances of getting the job.

Oracle Demantra Interview Questions and Answers

Among the several tools provided by Oracle, Oracle Demantra is one. This feature helps in demand management and supply chain management. It is a necessary tool needed to fulfil the needs of customers. If the management of customers is not proper, it can lead to the loss of customers. The companies work with customers only. The knowledge of Oracle Demantra is needed to get a job at an IT company. One should know about all the basics of this feature. The Oracle Demantra interview questions and answers that can help to have a good oracle interview experience are listed below.

21. Tell us something about Oracle Demantra and list some of the Demantra applications?

This is a crucial Oracle interview question. Oracle manufactures a supply chain management and demand management tool marketed as Oracle Demantra. It has a significant role in enabling an automated forecast process. This process maps the demand forecasting in opposition to factors such as customer commitments, supply restrictions, and inventory counts. Low inventory costs, High service levels, lower distribution cost, and greater customer satisfaction are some of the benefits that can be easily eradicated by deploying Oracle Demantra. 

Some of the Demantra applications are:

• For trade planning; It becomes easy and predictable.
• For demand management
• For trade promotion optimization  
• For deduction and settlement management
• For advanced forecasting and demand modelling

22. What are the advantages of Demantra implementation?

Benefits that can be eradicated from Oracle Demantra are:

• The quality and quantity of the service provided improve. 
• The customer is satisfied.
• The inventory costs fall. 
• The distribution cost is also significantly decreased.

23. List some features and benefits of Oracle Demantra?

This is an important and tough Oracle interview question. Some feature and benefits of Oracle Demantra are:

• Oracle Demantra is the best tool for demand management. It allows you to sense, plan for and proactively respond to demand by sharing a one-number plan that aligns your organisation across departments and users. 
• It also helps you in modelling new products based on the life-cycle of the old products. The flexibility of manufacturing new products or their better versions to supersede the existing products is also available.
• The real-time Sales and Operations planning feature of Oracle Demantra helps in planning and managing things. The planners and managers take command of the daily planning process. 
• The foundation for a responsive sale and operation-planning process is also provided by Oracle Demantra Real-time sales and operation-planning feature. It enables the emerging and current best practices in demand-driven adaptive planning.
• You can get unparalleled accuracy and sophistication in volume forecasting, post-event evaluation and  pre-event simulation at your fingertips with the Predictive trade planning feature of Oracle Demantra.

24. What will you do if you face any issues in starting the web server on Demantra?

This Oracle interview question is that of an advanced one. You could answer this Oracle interview question by saying;  If any issues are starting the web server, you need to revisit and explore the Collaborator.log file. This log file is found in the Collaborator Demantra log folder in the Oracle Demantra Web server.  Every individual web server will have logs in different directories. These logs are specified in the respective web server documentation and can help us to dig in further.

25. What happens when RVWR can’t write to the disk?

The further process depends on the fact that the writing error has occurred. 

• If the restore point is guaranteed, the database crashes to ensure that the restore point guarantee is not voided.
• If there is no guarantee and it is a primary database, the flashback mode will be turned off automatically for the database allowing it to operate normally.
• If there is no guarantee and it is a Standby database, the database will hang until the cause of the write failure is not fixed.

26. What are the basic requirements to enable a flashback database?

The requirements to enable flashback database are:

• Your database must be running in ACHIEVELOG mode. This is because achieved logs are used in flashback database operation. 
• You must have a flash recovery area enabled. This is because Flashback logs can be stored only in the Flashback recovery area.
• The flash recovery area must be stored in a clustered file system or an ASM for real application clusters databases.

27. Can a backup of flashback logs be created using RMAN?

No, using RMAN backup of Flashback logs can’t be created. If the command BACKUP RECOVERY AREA is used, then some contents of the FRA can be backed up. The files that can be backed up are full and control file auto backups, data file copies, incremental backup sets, and archived redo logs. Flashback files are transient files, so they can’t be backed up using RMAN. They are not essential for media recovery.

28. Is there any need to shut down and mount the database to switch on the flashback?

This is an important and tough Oracle interview question. ALTER DATABASE FLASHBACK ON is an online function of Oracle 11g. In Oracle 10g Release 2, the database must be mounted. Opening the database is not necessary. 

When the flashback is turned on, Oracle starts to save the before images of the database blocks before they are changed. With this feature, the database can be flash-backed to the exact point of time when the flashback mode was being switched off.

29. What is the background process to write flashback logs?

Yes, there is a separate background process to write flashback logs. RVWR (Recovery writer that is also known as Flashback Writer) was introduced in Oracle 10g. 

Flashback Writer is used to write flashback data from the flashback buffer in SGA to the flashback database logs on the disk.

30. What are the common errors with the Simulation engine or Demantra batch?

This is an important and tough Oracle interview question. The key engine logs can be found only under the root drive of the machine, at the place where the engine is launched. The folder that has all the logs is usually named Engine2k somewhere.

Make sure that there should be Engine2k logs in this folder. Engine2k logs are the logs that show the actual forecasting and splitting that the engine does. 

If you want to write Master Engine Manager logs in this folder, you need to go to the Engine Administrator and change the Engine Manager log from SDL to FILE. 

You should never re-register the engine after making this change.

Some of the important Oracle Demantra Questions are present here. Oracle Demantra is the best solution to manage the demands and chain supply. The cost of delivery and execution is reduced if Oracle Demantra is used judiciously. The demands can also be fulfilled easily and in an organised way. This feature has become a necessity of many companies. Oracle Demantra is the one that helps to fulfil these functions. 

Many companies look for candidates who know about these operations. If you are going for an interview, you should know about the operations like the flashback, RVWR, RMAN etc. It will help you have a good impression of the interviewers and ultimately crack the interview.

Conclusion

Oracle is such a company that is deep-rooted in the field of computer technology. You will frequently come across Oracle Applications being used in various companies. To get employed in the IT sector, along with the knowledge, you need to be skilled enough. You should know all about the basic operations of the various Oracle-based applications. 

The expression of knowledge is another necessary aspect. You need to express your knowledge in an integrated and brief manner so that the person in front of you judges you accurately. These Oracle interview questions will give you a direction so that you can integrate your knowledge and express it in the best possible way.  Your Oracle interview experience will be good if you take help with these questions. These Oracle interview questions are framed in a manner so that you can crack the interview.

More Resources: Part time jobs in Trichy from Home | Part time jobs in Nagpur for students | Java Interview questions & answers for 2 to 3 years experience | Interview Questions and answers for MBA Fresher