Top 20 Oracle Cloud Interview Questions & Answers

Ques: 1. What are the database related public cloud offerings in oracle cloud?

Answer:

Oracle public cloud offering comes with three database related services in the public cloud. They are as follows:

a) Schema as a Service (SAAS).

b) Database as a service (DAAS)– Also known as DBaaS, this public cloud is offered as both Infrastructure as a service IAAS and Platform as a Service PAAS.

c) Oracle database cloud Ex-Data service.

 

Oracle Fusion Applications interview Questions and Answers

 

Ques: 2. How will you provision an oracle database?

Answer:

As an oracle cloud dba, we collect requirements from customers and create it as per given requirements. In case your project needs a clone of production database immediately for testing and UAT purpose. for example, it can be done as per standard specification requirements often based on a template.

 

Oracle Accounts Payables Interview Questions and Answers

 

Ques: 3. Why should I choose oracle cloud over others, as there are many different cloud services available in market?
 

Answer:

Oracle cloud offers database as a service. Oracle database is the popular relational database company that has been in existence so long. With oracle databases supporting enterprise databases, this is a cloud service that can support databases that are used for testing, development, all the way up to live production databases. Oracle cloud offers high availability, scalability options offering business continuity, time save and lot more advantages. A cloud service from a database company to keep it simple.

 

Oracle ADF Interview Questions and Answers                                 

 

Ques: 4. what database management services are included in oracle cloud platform as service offering?

Answer:

Following database management services are included as part of Oracle cloud platform as a service PAAS: 

• Database
• Database backup 
• Big Data
• Big Data Cloud 
• Event Hub 
• MySQL 
• Autonomous NoSQL Database Cloud 
• Data hub
• Autonomous Data Warehouse Cloud.

 

Oracle Access Manager Interview Questions and Answers

 

Ques: 5. Where can you store your oracle database backup in oracle cloud?
 

Answer:

Oracle cloud objects storage solution that is reliable and scalable. As of information from oracle website this is a 8000TB storage that is used for storing and accessing the data in databases that are ever growing. This is storage used for storing oracle database backup data.
 

Oracle Fusion HCM Interview Questions and Answers

 

Ques: 6. What are the unique features of oracle cloud database backup management offering?
 

Answer:

This is a reliable and scalable object data storage from oracle cloud. Some unique features includes:

• Security – This solution comes with enterprise-grade data protection policies. The privacy policies are in enterprise grade as well. Oracle being the most popular enterprise database solution this cloud offerings from oracle are designed. 
• Reliability – Redundancy policies ensure high availability of data. 
• Scalability – Oracle cloud is a pay as you go model solution wherein you can choose to purchase universal credits, BYOL etc. Based on capacity and growing demands storage hardware is allocated making this a scalable solution. 
• Simplification by using existing RMAN for backups – Even with cloud oracle is still making use of RMAN backup for performing the database backups. This makes backup, restore and recovery operations transparent using RMAN.

 

Oracle SCM Interview Questions and Answers

 

Ques: 7. What is the difference between normal database and Oracle database cloud service?
 

Answer:

Oracle database cloud service is same as single-instance oracle database except for that database is deployed in cloud and computing resources including storage, power etc is provided by Oracle.

 

Oracle Financials Interview questions and Answers

 

Ques: 8. What are the two service levels available with oracle database cloud service?
 

Answer:

Oracle Database Cloud Service Virtual image wherein customer is responsible for installing software, maintenance of software. Customer has root privilege and full database administrative privilege.
 

Oracle Database Cloud Service wherein database deployment is easy using custom options provided online. Oracle database cloud service can perform automated backups. Customer is responsible for setting up maintenance operations, recovery operation setup in the event of failure.

Oracle PL/SQL Interview Questions and Answers

 

Ques: 9. Which component of Oracle cloud provides service console and REST API?
 

Answer:

Platform Service Manager the PSM component of Oracle cloud is responsible for this. This component is the one used in Oracle golden gate and Oracle Java cloud service as well.

 

Oracle SQL Interview Questions and Answers

 

Ques: 10. How does PSM interact with compute nodes to perform predefined cloud service actions like backup, patching?
 

Answer:

PSM uses secure shell the SSH in port 22 of compute nodes. Compute nodes hosts databases which as database deployments in oracle cloud terms. These cations can be initiated over web service console that uses PSM or REST API.

 

Oracle RDMS Interview Questions and Answers

 

Ques: 11. How will you achieve high availability in Oracle Cloud Infrastructure?
 

Answer:

Attach block volume from availability domain 1 to a compute instance in availability domain 2 or vice versa. Distribute application servers across all availability domains within a region.

BI Publisher Interview Questions and Answers

 

Ques: 12. What are the components of backend set of a load balancer?

 

Answer:

a) Load balancing policy
b) list of backend servers
c) health check policy
d) SSL handling
e) session persistence configuration

Oracle 10g Interview Questions and Answers

 

Ques: 13. What are the many different database deployment model available with oracle cloud?
 

Answer:

Following are the many different types of database deployment models that come as part of oracle cloud:

• Oracle database cloud service. 
• Oracle database cloud service bare metal. 
• Oracle Database Exadata Cloud Service. 
• Oracle Database Exadata Cloud at Customer. 
• Oracle Database Exadata Express Cloud Service – Managed. 
• Oracle Database Schema Cloud Service – Managed.

 

Ques: 14. How can I try oracle cloud for free?
 

Answer:

Oracle cloud offers $300 in free credits. You can make use of this credit for building your test, development, production databases, compute options, containers, IoT, bigdata, API, chatbots, integrations and lots more that are valid for 30 days. Create a free account and try these features for free.

 

Ques: 15. How is internal communication between PSM and Oracle cloud compute nodes established?
 

Answer:

SSH key-value pairs are used for this communication in port 22. This key value pair is specific to each database deployment and used for internal communication purposes. This SSH is internal to Oracle and not accessible. If there is an issue here PSM communication with compute node fails.

  

Ques: 16. Who has access to the SSH keys used for PSM communication with compute nodes?
 

Answer:

Only owner of that project has this access. For security purposes even oracle support and operations are not granted this access unless explicitly shared by customers for troubleshooting purposes.

 

Ques: 17. Give some invalid REST API operations for DNS Zone in OCI:
 

Answer:

The below REST API operations are invalid in OCI:

a) ListZones.
b) GetZone.
c) CreateZone.
d) UpdateZone.
e) DeleteZone.

 

Ques: 18. In TCP level health check you send requests to the backend servers at a specific URL. How will you validate the response?

Answer:

a). based on status code.
b). based on entity data returned.
c). based on entity body returned.

Ques: 19. What load balancer components that are mandatory backend set components?

Answer:

a). Load balancing policy.
b). List of backend servers.
c). Health check policy.
d). TCP handling.
 

Ques: 20. What configurations must be made for the process of designing a load balancer to accept incoming traffic?

Answer:

a). Listener must be configured.
b). A certificate must be available.
c). A security list that is open on a listener port must be available.

Top 20 Hyperion Technical Interview Questions & Answers

                           Looking for Hyperion technical Interview Questions, the below questions and answer set helpful for experienced or freshers. A lot of opportunities you can find in many IT companies. You will have opportunity to move further in your career. these Hyperion Technical Interview Questions can be a good help as Hyperion Developer.

Ques: 1. What do you understand by Hyperion?

Ans: A database that allows you to access the data at a very fast pace. The Hyperion’s company was bought by Oracle in 2007 and Oracle continuously improving the product. Hyperion is also known as Business Intelligence and it focuses to support better business decision-making.

Hyperion is the market leader in Operational, Financial and Strategic Planning. It contains the applications for reporting, Planning, dashboards, Analysis, score carding, consolidation, Workspace, Master Data Management and Foundation.

So, a BI system can be called a decision support system (DSS). However, Business Intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, BI Uses technologies, processes, and application to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors.

Ques: 2. What is the significance of Attribute dimensions in report performance?

Ans: For very large number of attribute dimensions displayed in the report, the performance could extremely decrease. While filling the data, you have applied both the selection and the rejection criteria to the same record. The record will be rejected.

Attribute dimension highly impact the report performance as the attributes are calculated vigorously when referenced in the report.

Ques: 3. What is Hyperion Planning?

Ans: Hyperion Planning is a budgeting and forecasting application from Oracle formerly owned by Hyperion Solutions Corporation. Hyperion Planning uses Essbase (s multidimensional database product sold by Hyperion) as a database and calculation engine, a relational repository for business logic, and includes a web-based user interface. This software allows to add planning or forecast data to actuals. You can use Web Forms to add the planning data or use the Excel SmartView tool. Most of the Hyperion reporting tools work great with planning.

Ques: 4. Can you Explain the Attributes?

Ans: Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the database in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data.

Ques: 5. What Are Filters in Hyperion?

Ans: A method of controlling access to database cells in Hyperion essbase. A filter is the most detailed level of security, allowing you to define varying access levels different users can have to individual database values. If you want to grant access to all dimensions, then you wouldn’t use a filter. Just grant read access for the database to the user and/or group. The only reason you would use a filter is if you wanted to restrict access.

Ques: 6. What do you understand by Dense and Sparse Dimensions?

Ans: Dense Dimension: A dimension which has the high probability that data exists for every combination of dimension members.

Sparse Dimension: A dimension which has low probability that data exists for every combination of dimension members.

Ques: 7. What do you understand by TB First and TB Last?

Ans: TB First: in the Sample. Basic database, the accounts member Opening Inventory is tagged as TB First. Opening Inventory consolidates the value of the first month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Jan.

TB Last: in the Sample. Basic database, the accounts member Ending Inventory is tagged as TB Last. Ending Inventory consolidates the value for the last month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Mar.

Ques: 8. What is the key difference between UDA’s and Attribute dimensions?

Ans: Attribute dimensions provides more flexibility than UDA’s. Attribute calculations dimensions which include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are calculate dynamically.

Ques: 9. How many primary build methods are available in Hyperion for building dimensions?

Ans: There are three primary build methods available for building dimensions. They are:

• Generation references 
• Parent-Child references 
• Level references

Ques: 10. What are the attributes in Hyperion?

Ans: Attributes are the classifications of a member in a dimension. You can select, and group the members based on their associated attributes. You can also specify an attribute when you perform calculations and use calculation functions.

Eg: The database in Sample Basic which has product dimension has some attributes like size, package type, and flavor. We can add these attributes to the dimensions where we can retrieve the data like for example to retrieve “Pepsi with 10 Oz with Cans” this is useful for generating reports.

Ques: 11. What are the three options specified in Username and Password management under the security tab in Essbase server properties?

Ans: 1. Login attempts allowed before username is disabled.
2. Number of inactive days before username is disabled.
3. Number of days before user must change password.

Ques: 12. What are two storage options available in Hyperion Essbase? What are the differences?

Ans: ASO (Aggregate Storage Option):

• If we have large number of dimensions (generally more than 10).
• Most of the dimensions are sparse.
• We cannot write back in ASO. I heard recently that ASO will also have the write back capability.

BSO (Block Storage Option)­:

• Dimensions are less and dense (recommended values for no of dim are between 4 and 8).
• We can write back hence much suited for planning applications. Financial applications are generally dense structures and normal analytical cubes are sparse. Here we also need to understand what these dense and sparse members are. When the intersections or cells of two dimensions mostly contain a value, it is dense.

Ques: 13. What is Oracle Hyperion Financial Management (HFM)?

Ans: Oracle Hyperion Financial Management, part of the Oracle EPM Suite, supports the collection, consolidation and reporting of financial results in multiple GAAPs as well as IFRS, and the reconciliation of differences among the various standards.

Oracle Hyperion Financial Management (HFM) is a comprehensive Web-based application that delivers global financial consolidation, reporting and analysis in a single, highly scalable software solution. Hyperion Financial Management can be deployed quickly to integrate data from multiple Oracle and non-Oracle transactional systems, provide top-side reporting that conforms to IFRS requirements, and help organizations make the transition to IFRS.

Ques: 14. What do you understand by LRO's( Linked Reporting Objects)?

Ans: They are specific objects like files, cell notes, or URL's associated with specific data cells of Essbase database. You can link multiple objects to a single data cell. These linked objects are stored in the server. These LRO's can be exported or imported with the database for backup and migration activities.

Ques: 15. Why do objects gets locked and when does this happens?

Ans: Objects gets locked to prevent users to make simultaneous and conflicting changes to Essbase database objects. By default, whenever an object is accessed through Administrative services console or Excel spreadsheet add-in, it gets locked.

Ques: 16. What is custom based macro?

Ans: Hyperion Essbase macros that we write with Essbase calculator functions and special macro functions. Custom-defined macros use an internal Essbase macro language that enables you to combine calculation function and operate on multiple input parameters.

Ques: 17. What Are the types of partitioning options available in Hyperion Essbase?

Ans: Three types of partitioning options are available in Hyperion Essbase:

1. Replicated partition.
2. Transparent partition 
3. Linked partition.

Ques: 18. What Are the different types of Log Files in Hyperion?

Ans: There are many log files hyperion essbase, but the important log files are:

• Application log
• Essbase.log
• Configtool.log
• Eas_install.log
• Essbase server-install.log

Ques: 19. On what basis you will decide to invoke a serial or parallel calculation method?

Ans: If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.

Ques: 20. What is block locking system?

Ans:Analytic services (or Essbase Services) locks the block and all other blocks which contain the Children of that block while calculating this block is block locking system.

Top 20 JQuery Interview Questions and Answers

Ques: 1. How JQuery and JavaScript are different?

Answer:

JQuery simplifies the use of the JavaScript language. JavaScript is a language while JQuery is a library built in the JavaScript language that helps to use the JavaScript language.

AngularJS Interview Questions and Answers

Ques: 2. Can JQuery fulfill the need JavaScript?

Answer:

JQuery is not a replacement of JavaScript. JQuery is a different library which is written on the top of JavaScript. JQuery is a lightweight JavaScript library that emphasizes interaction between JavaScript and html.

AJAX interview Questions and Answers



Ques: 3. What are the effects methods used in JQuery?

Answer:

JQuery enables us to add effects on a web page. JQuery effects can be categorized into fading, sliding, hiding/showing and animation effects. JQuery provides many methods for effects on a web page. These are the effects methods used in JQuery:
    show() - It displays or shows the selected elements.
    hide() - It hides the matched or selected elements.
    toggle() - It shows or hides the matched elements. In other words, it toggles between the hide() and show() methods.
    fadeIn() - It shows the matched elements by fading it to opaque. In other words, it fades in the selected elements.
    fadeOut() - It shows the matched elements by fading it to transparent. In other words, it fades out the selected elements.

JavaScript Interview Questions and Answers



Ques: 4. What is the function of ajaxComplete() as JQuery Ajax event method?

Answer:

Whenever an Ajax request completes, JQuery triggers the ajaxComplete event. Any and all handlers that have been registered with the .ajaxComplete() method are executed at this time.

Node.js Interview Questions and Answers


Ques: 5. What is the difference between the ID selector and class selector in JQuery?

Answer:

ID selector and class selector are the same as they are in CSS. ID selector uses ID while the class selector uses a class to select elements. You use an ID selector to select just one element. If you want to select a group of elements, having the same CSS class, you can use the class selector.

Advance Java interview Questions and Answers


Ques: 6. What does dollar sign ($) mean in JQuery?

Answer:

Dollar sign is nothing but it's an alias for JQuery. Take a look at below JQuery code.

$(document).ready(function(){
});

over here $ sign can be replace with JQuery keyword.

JQuery(document).ready(function()){
});


Ques: 7. What is the difference between body.onload() and document.ready() function?

Answer:

Document.ready() function is different from body.onload() function for 2 reasons:
1. we can have more than one document.ready() function in a page where we can have only one body.onload() function.
2. document.ready() function is called as soon as DOM is loaded where body.onload() function is called when everything gets loaded on the page that includes DOM, images and all associated resources of the page.


Ques: 8. What is JQuery UI?

Answer:

JQuery UI is a set of user interface interactions, effects, widgets, and themes built on top of the JQuery JavaScript Library. JQuery UI works well for highly interactive web applications with many controls or for a simple page with a date picker control.


Ques: 9. What is the advantage of hosting a JQuery using a CDN?

Answer:

CDN stands for Content Delivery Network or Content Distribution Network. It is a large distributed system of servers deployed in multiple data centres across the internet. It provides the files from servers at a higher bandwidth that leads to faster loading time.

Advantages of using CDN are:

·       The JQuery library download time will be reduced. For example - Users in Europe will hit the CDN in Europe and users in the US will hit the US CDN. As a result, this will reduce the overall page load time.

·       The JQuery library will already be cached in the user’s browser if the user visited another website that references the same JQuery library. In this case, the user need not download the JQuery library.

Ques: 10. What is the difference between find and children methods?

Answer:

Both the methods are used to filter the child of the matched elements. Find method is used to find all levels down the DOM tree but children method searches only a single level down the DOM tree.


Ques: 11. What do you understand by JQuery.noConflict?

Answer:

JQuery no-conflict is an option given by JQuery to overcome the conflicts between the different js frameworks or libraries. When we use JQuery no-conflict mode, we are replacing the $ to a new variable and assigning to JQuery some other JavaScript libraries. Also use the $ (Which is the default reference of JQuery) as a function or variable name what JQuery has. And in our development life, we are not at all strict to only JQuery.


Ques: 12. Why there are two different version of JQuery library?

Answer:

JQuery library comes in 2 different versions:

1). Production
2). Deployment

The production version is quite useful at development time as JQuery is open source and if you want to change something then you can make those changes in production version.

But the deployment version is small version or compressed version so it is impossible to make changes in it. because it is compressed, so its size is very less than the production version which affects the page load time.

Ques: 13. Which are the popular JQuery CDN? and what is the advantage of using CDN?

Answer:

There are 3 popular JQuery CDNs:
1. Google
2. Microsoft
3. JQuery

Advantage of using CDN.
1. It reduces the load from your server.
2. It saves bandwidth. JQuery framework will load faster from these CDN.
3. The most important benefit is it will be cached, if the user has visited any site which is using JQuery framework from any of these CDN.


Ques: 14. How to remove a DOM Element using JQuery?

Answer:

Sometimes we get a requirement to delete all child nodes and remove DOM elements using JQuery to make a dynamic web page. In this scenario JQuery provides a couple of methods to remove DOM elements. Here are the options:

    empty()
    remove()
    html()

Ques: 15. What are JQuery Events?

Answer:

When we design dynamic web pages, we need to apply some events such as Mouse Click, for forms submit the form after a button click, change a color after a click, etc.

So in layman language, events are actions that are used for dynamic web pages. When we perform these actions on an HTML page, we can do whatever we want.

We use some event handlers to perform the action. Some important handlers are bind(), unbind(), blur(), off(), hover(), on(), one(), ready(), trigger() etc.


Ques: 16. What is Grouping?

Answer:

When more than one selector shares the same declaration, they may be grouped together via a comma-separated list; this allows you to reduce the size of the CSS (every bit and byte is important) and makes it more readable. The following snippet applies the same background to the first three heading elements.h1, h2, h3 {background: red;}


Ques: 17. What do you mean by Semantic HTML?

Answer:

Semantic HTML is a coding style where the tags embody what the text is meant to convey. In Semantic HTML, tags like <b></b> for bold, and <i></i> for italic should not be used, reason being they just represent formatting, and provide no indication of meaning or structure. The semantically correct thing to do is use <strong></strong> and <em></em>. These tags will have the same bold and italic effects, while demonstrating meaning and structure (emphasis in this case).


Ques: 18. What is the difference between eq() and get() methods in JQuery?

Answer:

eq() returns the element as a JQuery object. This method constructs a new JQuery object from one element within that set and returns it. That means that you can use JQuery functions on it.

get() return a DOM element. This method retrieves the DOM elements matched by the JQuery object. But as it is a DOM element and it is not a JQuery-wrapped object. So JQuery functions can't be used.


Ques: 19. What is difference between prop and attr?

Answer:

attr(): Get the value of an attribute for the first element in the set of matched elements. Whereas,.prop(): (Introduced in JQuery 1.6) Get the value of a property for the first element in the set of matched elements.

Attributes carry additional information about an HTML element and come in name="value" pairs. Where Property is a representation of an attribute in the HTML DOM tree. once the browser parse your HTML code, corresponding DOM node will be created which is an object thus having properties.

attr() gives you the value of element as it was defines in the html on page load. It is always recommended to use prop() to get values of elements which is modified via javascript/JQuery , as it gives you the original value of an element's current state. Find out more here.


Ques: 20. Can we execute/run multiple Ajax request simultaneously in JQuery?

Answer:

Yes, it is possible to execute multiple Ajax request simultaneously or in parallel. Instead of waiting for first ajax request to complete and then issue the second request is time consuming. The better approach to speed up things would be to execute multiple ajax request simultaneously.

Using JQuery.when() method which provides a way to execute callback functions based on one or more objects, usually Deferred objects that represent asynchronous events.