50+ Best Oracle WebCenter Interview Questions and Answers

Last updated on 18th Nov 2021, Blog, Interview Questions

If you are preparing for Oracle WebCenter Interview, then you are at the right place. Today, we will cover some mostly asked Oracle WebCenter Interview Questions, which will boost your confidence. Oracle WebCenter Sites. Rapidly create, deploy, and manage a network of web properties, while delegating individual website management with Oracle WebCenter Sites. Therefore, Oracle WebCenter professionals need to encounter interview questions on Oracle WebCenter for different enterprise Oracle WebCenter job roles. The following discussion offers an overview of different categories of interview questions related to Oracle WebCenter to help aspiring enterprise Oracle WebCenter Professionals.

1.What is the Oracle Webcenter Portal?

Ans:

Oracle WebCenter Portal provides design time and runtime tools for building enterprise portals, transactional web sites, and social networking sites. It provides portal-specific features such as page hierarchies, navigation models, delegated security, customization, and others. Portals can also include features like portlets, content management system integration, personalization, social computing services, search, analytics etc.

2. What is Oracle Database SQL?

Ans:

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user’s request.

3. Which is better to learn Oracle or SQL?

Ans:

Oracle is typically more complex to manage, has a higher learning curve, and costs more to maintain. Both Oracle and SQL Server come with their own “dialect” of the SQL language that extends the basic functionality of SQL. Oracle uses PL/SQL (Procedural Language/SQL), while SQL Server uses T-SQL (Transact-SQL).

4.Name a few components used for run-time editing with Oracle Composer?

Ans:

Panel customizable, Show Detail Frame, Custom Actions, Layout Customizable.

5. What is MDS?

Ans:

MDS or Metadata Repository is the repository for metadata of certain deployed applications. When the user commits run-time changes, they are stored and deployed an MDS on the server.

6. What is the difference between portals and pagelets?

Ans:

Portals	Pagelets
Portlets were designed specifically for portals.	Pagelet is a reusable user interface component similar to a portlet.

7. What is JCR?

Ans:

JCR or Java Content Repository API adapters enable users to access data stored in content management systems, such as Oracle WebCenter Content, Oracle Portal, or even your file system, available to your application.

8. What is the use of PortalWebAssets in webcenter portal application?

Ans:

PortalWebAssets is used to separate all the static resources in the application like HTML, image files etc.

9. Can you rename the PortalWebAssets folder?

Ans:

Yes, It can be renamed.

10. Define configuring high availability for webcenter?

Ans:

11. Is it a mandate to configure security in your webcenter portal application always?

Ans:

No, if the developer does not configure the security in the webcenter, the adf security gets configured by default. As part of this a default username/password is automatically created. Also, it also provides default Login and Logout pages.

12. How do you decide whether the application should be deployed as an EAR or a WAR?

Ans:

If the application contains run-time customizations using MDS, it must be bundled as an EAR. For simple webcenter portal application with no such customizations, WAR can be created.

13. What is the purpose of jazn-data.xml?

Ans:

This file is used for defining the permissions and privileges for various groups of users on various task flows created in the application.

14. What are the policy stores and identity stores in OID?

Ans:

The Identity Store is used to store information about users and groups while the Policy Store is used to store information about security policies.

15. Does Oracle have a content management system?

Ans:

Oracle provides the only cloud native content management solution that supports every asset, user, and experience of your brand. With all of your content in one place, you can efficiently deliver experiences anywhere.

16. What is Oracle content management?

Ans:

Oracle Content Management is a market-leading, cloud native platform that manages all your enterprise documents. With it, you can significantly streamline the capture, routing, and discovery of business-critical documents throughout your organization.

17. What are the binding context and binding container?

Ans:

Binding context is a runtime map between the data controls and page definition of pages in the application which is used to access the binding layer. It is accessible through the EL expression in your jsp pages. The binding container is a request-scoped map that is used to instantiate the page bindings.

This is accessible through the EL expressions. Also, since it is a request-scoped map, it is accessible during every page request.

18. What are the different types of bindings in ADF?

Ans:

ADF contains the following types of bindings:

Attribute Bindings: This is binding to retrieve the value of a single view attribute in the iterator binding current view row. For eg; #{bindings.CustomerId.InputValue}

Tree Bindings: This is used for tables, tree tables, and trees. It is used to expose rows of a table in the iterator binding current range. Eg; All Customers-#{bindings.customers.labels.CustomerId}

Action Bindings: This binding type is used when buttons or command links are dropped on the user interface and require an action to be performed on them. We can use data control operations on them, for eg, Create, Delete, First, Last, Commit, Rollback, etc.

Method Bindings: This binding is used when you want to use custom methods to be executed.

Iterator Binding: This binding is created by the application to access the ADF binding context. It contains a reference to the page bound data collection, helps access it, and iterates over its data objects.

19. What is Oracle content and Experience Cloud?

Ans:

Oracle Content and Experience Cloud is a cloud-based content hub that drives omni-channel content management and accelerates experience delivery. Powerful collaboration and workflow management capabilities streamline the creation and delivery of (multilingual) content and improve customer and employee engagement.

20. What is an overview of an oracle webcenter?

Ans:

21. What is a view scope?

Ans:

A view-state allocates a new viewScope when it enters. This scope may be referenced within the view-state to assign variables that should live for the duration of the state. This scope is useful for manipulating objects over a series of requests from the same view.

22. What is eloqua Oracle?

Ans:

Oracle Eloqua is a software as a service (SaaS) platform for marketing automation offered by Oracle that aims to help B2B marketers and organizations manage marketing campaigns and sales lead generation.

23. How do you define pagination in ADF?

Ans:

We define custom pagination in ADF by creating a custom table as a task flow using the af:iterator tag. This renders the collection of data just as a table renders it. Now we bind the value property of the iterator to the collection model from ADF bindings declaration and set the number of visible rows to, say 15.

24. What is Oracle cloud experience?

Ans:

Oracle Content Management is a cloud-based content hub to drive omni-channel content management and accelerate experience delivery. It offers powerful collaboration, workflow management, and development capabilities to streamline the creation and delivery of content and improve customer and employee engagement.

25. What is the difference between data bindings.cpx and data control.dcx?

Ans:

Data binding.cpx	Control.dcx
The DataBindings.cpx file contains the Oracle ADF binding context for your entire application and provides the metadata from which the Oracle ADF binding objects are created at runtime.	The DataControls.dcx file is created when you register data controls on the business services.

26. What is the life cycle of JSF?

Ans:

Restore View: The request comes to the FacesServet controller which extracts the view from this request.

Apply request values: The purpose of the apply request values phase is for each component to retrieve its current state. The components must first be retrieved or created from the FacesContext object, followed by their values.

Process validations: This phase makes use of the validators to validate the validation rules on the fields.

Update model values: In this phase, JSF updates the actual values of the server-side model, by updating the properties of your backing beans.

Invoke application: Here the JSF controller invokes the application action to handle Form submissions.

Render response: In this phase, JSF displays the view with all of its components in their current state.

27. What is the difference between setting an immediate=true on a button and immediate=true on a text field?

Ans:

When immediate is true on a button, the command’s action and ActionListeners, including the default ActionListener provided by the JavaServer Faces implementation, will be executed during the Apply Request Values phase of the request processing lifecycle, rather than waiting until the Invoke Application phase.

In the case of a text field, by default, values are converted and validated together in the Process Validators phase.

However, if you need access to the value of a component during Apply Request Values – for example, if you need to get the value from an actionListener on an immediate commandButton – then setting this to “immediate” makes that possible.

28. What does Oracle experience mean?

Ans:

Oracle Customer Experience Cloud (Oracle CX Cloud) is a suite of cloud-based tools for customer relationship management (CRM), sales, marketing, customer service, e-commerce and other tools, such as configure, price, quote (CPQ) tools. Like Microsoft, Oracle offers on-premises and cloud-based CRM technologies.

29. What Is The Difference Between Setting An Immediate=proper On A Button And Immediate=real On A Text Field?

Ans:

When on the spot is proper on a button, the command’s action and ActionListeners, including the default ActionListener furnished by the JavaServer Faces implementation, can be accomplished at some stage in Apply Request Values section of the request processing lifecycle, as opposed to ready until the Invoke Application phase.

In case of a textual content subject, with the aid of default, values are transformed and verified together in the Process Validators segment. However, in case you want get right of entry to to the fee of a issue in the course of Apply Request Values – as an instance, in case you want to get the fee from an actionListener on an instantaneous commandButton – then putting this to “on the spot” makes that viable.

30. What is an introduction for the Oracle Webcenter?

Ans:

31. What is Oracle CX unity?

Ans:

Oracle CX Unity provides B2B and B2C brands with a complete customer intelligence platform for managing all their customer data. It brings together online, offline, and third-party customer data sources and then applies built-in machine learning to prescribe the optimal experience within existing business processes.

32. What Is The Purpose Of Faces-config.Xml?

Ans:

Use the faces-config.Xml document to check in a Framework application’s resources, which include custom validators and controlled beans, and to define all page-to-page navigation guidelines.

33. In Which Xml Do You Configure The Skin For Your Framework Application?

Ans:

trinidad-config.Xml

34. What Is The Purpose Of Adfc-config.Xml?

Ans:

The adfc-config.Xml report is the configuration record for an ADF unbounded project flow. This file includes metadata about the sports and managed flows contained within the unbounded venture flow.

35. What is Caching?

Ans:

Caching is a technique used to cache site pages.

36. What is the difference between CSElement & Template & SiteEntry?

Ans:

• CSElement is to execute common business logic & we cannot cache cselement
• SiteEntry is for caching the CSElement
• Template will create both the CSElement & SiteEntry

37. What is a Satellite Server?

Ans:

A : Satellite Server is a caching application.

types of Satellite Server:

Co-resident

co-resident Satellite Server is installed on the same computer

Remote

Remote Satellite Server hosts are fast, inexpensive caches of WebCenter Sites pages. They reduce the load on the WebCenter Sites host, dramatically increase the speed of page delivery to your site visitors, and provide a simple and inexpensive way to scale your WebCenter Sites system Handling HTTP Requests When the load balancer routes an HTTP request for a page to Satellite Server, Satellite Server either serves the page if the page is in its cache, or if the page is not cached, it forwards the HTTP request to WebCenter Sites. The basic chain of events is the following:

1. Satellite Server checks its cache.

2. What happens next depends on whether the page is in the Satellite Server cache:

38. What is the FTCS tag?

Ans:

FTCS stands for future tense Content server.

• Each WebCenter Sites element or template begins and ends with the ftcs tag. This tag creates the WebCenter Sites context, alerting WebCenter Sites that code contained within the opening and closing ftcs tags will contain WebCenter Sites tags and access ICS methods.
• If you use the WebCenter Sites user interface or the Oracle WebCenter Sites Explorer tool to create elements and templates, the opening and closing ftcs tags are automatically added after the standard directives. You must code within the opening.

39. What Is Active Directory?

Ans:

A domain is defined as a logical group of network objects (computers, users, devices) that share the same Active Directory database. A tree can have multiple domains.

40. What is an Oracle webcenter content for 10g users?

Ans:

41. What Is Domain Controller?

Ans:

• A domain controller (DC) or network domain controller is a Windows-based computer system that is used for storing user account data in a central database. It is the centrepiece of the Windows Active Directory service that authenticates users, stores user account information and enforces security policy for a Windows domain.
• A domain controller allows system administrators to grant or deny users access to system resources, such as printers, documents, folders, network locations, etc., via a single username and password.

42. What Is Ldap?

Ans:

A GLDAP (Light-Weight Directory Access Protocol) determines how an object in an Active Directory should be named. LDAP is the industry standard directory access protocol, making Active Directory widely accessible to management and query applications. Active Directory supports LDAPv2 and LDAPv3.

43. Where Is The Ad Database Stored?

Ans:

The AD database is stored in C:WindowsNTDSNTDS.DIT.

44. What is the difference between Trinidad config and Trinidad. skins

Ans:

Trinidad config	Trinidad skins
The Trinidad. config file is created when you create a WebCenter portal application. This is used to register the skin-family you are going to use for your entire application.	Trinidad. skins are used when we use the skin as a Jar file. This file provides a mapping between the Skin Id and the actual path where the skin exists.

45. What Is Garbage Collection?

Ans:

Garbage collection is the online defragmentation of the Active Directory which happens every 12 hours.

46.What Are Lingering Objects?

Ans:

• A lingering object is a deleted AD object that still remains on the restored domain controller in its local copy of Active Directory. They can occur when changes are made to directories after system backups are created.
• When restoring a backup file, Active Directory generally requires that the backup file be no more than 180 days old. This can happen if, after the backup was made, the object was deleted on another DC more than 180 days ago.

47.Why Do We Use Dhcp?

Ans:

Dynamic Host Configuration Protocol assigns dynamic IP addresses to network devices allowing them to have a different IP address each time they are connected to the network.

48. How Can We Remove Lingering Objects?

Ans:

Windows Server 2003 and 2008 have the ability to manually remove lingering objects using the console utility command REPADMIN.EXE.

49. What Is Inter-portlet Communication?

Ans:

Inter-portlet verbal exchange is executed while an movement in one portlet triggers a response inside the second portlet. It’s a verbal exchange bridge among two portlets. For example, one portlet includes a checkbox containing a listing of products. When I pick a product from the list and click on submit, the other portlet presents the details of the respective product.

50. Define portal oracle webcenter?

Ans:

51. Why Should You Not Restore A Dc That Was Backed Up 6 Months Ago?

Ans:

When restoring a backup file, Active Directory generally requires that the backup file be no more than 180 days old. If you attempt to restore a backup that is expired, you may face problems due to lingering objects.

52.Give An Example Of Systems You Have Been Working With As An Administrator?

Ans:

These typically are: Windows and Linux, which support either Asset Management or GIS. Typical duties include engineering, support and maintenance, and research for the purpose of innovation and upgrading

53. What Are The Personal Characteristics Of A System Administrator?

Ans:

System administrators are experts at handling hardware and software. They are quick with both their hands and their head. They can work alone, but they know when and how to communicate with others, whether to report problems, learn information needed to fix problems, or instruct employees regarding technical issues.

54.What Role Do Characteristics Such As Assertiveness And Problem Solving Play In The Career Of A System Administrator?

Ans:

Analytical thinking and problem solving is crucial to be able to analyze software or hardware malfunction. They are also necessary to be able to improve or upgrade systems so that they suit company needs. Assertiveness also plays a role because administrators have to make decisions. They decide on solutions, security measures, and things like system upgrades.

55. Team-work Part Of A System Administrator’s Typical Day?

Ans:

Administrators are typically called in to offer technical support for teams working on a project. Support might mean technical troubleshooting or the development and explanation of technological strategy with regards to the project goals and means.

56. What Is Voip?

Ans:

VOIP :Short for Voice Over Internet Protocol, a category of hardware and software that enables people to use the Internet as the transmission medium for telephone calls by sending voice data in packets using IP rather than by traditional circuit transmissions.

57.What Is Loop Back?

Ans:

Loopback address is 127.0.0.1, An address that sends outgoing signals back to the same computer for testing.

58. What Is a Proxy Server?

Ans:

A proxy server is a computer that acts as a gateway between a local network (e.g., all the computers at one company or in one building) and a larger-scale network such as the Internet. Proxy servers provide increased performance and security. In some cases, they monitor employees’ use of outside resources.

59. Explain about MDS Repository Directory?

Ans:

When users did some personalization to their blog and they wish to see the saved content on the next day. In order to achieve this we have a directory called MDS repository directory. It is used to preserve or delete customizations before each run.

60. What are web center sites?

Ans:

61. What is Resource Catalog?

Ans:

Resource catalog is used to store some reusable components like pages, taskflow, images, etc,. which can be added at run time.

62. What is the Portal Web Assets project?

Ans:

It is a project by default that comes whenever we create a webcenter application. It is used to store the static content of the particular project like images, HTML. We can also run this project on other servers independently in order to reduce the burden on the main application server.To do so we have to remove the dependencies.

63. What is the difference between an action and an active listener?

Ans:

Action	Action listener
Actions are designed for business logic and participate in navigation handling, whereas action listeners typically perform user interface logic and do not participate in navigation handling.	Action listener is a class that wants to be notified when a command component fires an action event

64. What is Oracle Composer?

Ans:

Oracle Webcenter provides both run time and design time tools for building portal applications/social networking websites/transactional sites,etc.. Webcenter provides some privileges to admin and users of the particular portal application to perform these customizations.In order to enable the Run time editing we need a tool called Oracle Composer Read: OTT List

65.Difference between varchar and varchar2 data types?

Ans:

Varchar can store upto 2000 bytes and varchar2 can store upto 4000 bytes. Varchar will occupy space for NULL values and Varchar2 will not occupy any space. Both are differed with respect to space.

66. In which language Oracle has been developed?

Ans:

Oracle has been developed using C Language.

67. What is RAW datatype?

Ans:

RAW datatype is used to store values in binary data format. The maximum size for a raw in a table in 32767 bytes.

68. What is the use of the NVL function?

Ans:

The NVL function is used to replace NULL values with another or given value. Example is NVL(Value, replace value)

69. Whether any commands are used for Months calculation? If so, What are they?

Ans:

In Oracle, months_between function is used to find the number of months between the given dates. Example is –Months_between(Date 1, Date 2)

70. What is oracle webcenter content?

Ans:

71. What are nested tables?

Ans:

Nested table is a data type in Oracle which is used to support columns containing multi valued attributes. It also hold entire sub table.

72. What is COALESCE function?

Ans:

COALESCE function is used to return the value which is set to be not null in the list. If all values in the list are null, then the coalesce function will:

• return NULL.
• Coalesce(value1, value2,value3,…)

73. What is BLOB datatype?

Ans:

A BLOB data type is a varying length binary string which is used to store two gigabytes memory. Length should be specified in Bytes for BLOB.

74. How do we represent comments in Oracle?

Ans:

Comments in Oracle can be represented in two ways –

Two dashes(–) before beginning of the line – Single statement

/*—— */ is used to represent it as comments for block of statement

75. What is the difference between visible property and render property?

Ans:

Visible property	Render property
The visible property is set to true/false based on the requirement whether we want to see the field on the page or not at run time. The field or component still exists on the page, though hidden.	The field or component still exists on the page, though hidden. The render property is used to conditionally load the component based on criteria.

76. What is DML?

Ans:

Data Manipulation Language (DML) is used to access and manipulate data in the existing objects. DML statements are insert, select, update and delete and it won’t implicitly commit the current transaction.

77. What is the difference between TRANSLATE and REPLACE?

Ans:

Translate is used for character by character substitution and Replace is used to substitute a single character with a word.

78. How do we display rows from the table without duplicates?

Ans:

Duplicate rows can be removed by using the keyword DISTINCT in the select statement.

79.What is the usage of Merge Statement?

Ans:

Merge statement is used to select rows from one or more data sources for updating and insertion into a table or a view. It is used to combine multiple operations.

80. Define understanding the oracle web center?

Ans:

81. What is the NULL value in oracle?

Ans:

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.

82. The USING clause is used to specify the column to test for equality when two tables are joined?

Ans:

[sql]Select * from employee join salary using employee ID[/sql]
Employee tables join with the Salary tables with the Employee ID.

83. What is key preserved table?

Ans:

A table is set to be a key -preserved table if every key of the table can also be the key of the result of the join. It guarantees to return only one copy of each row from the base table.

84. What is the WITH CHECK OPTION?

Ans:

The WITH CHECK option clause specifies check level to be done in DML statements. It is used to prevent changes to a view that would produce results that are not included in the sub query.

85. What is the use of Aggregate functions in Oracle?

Ans:

Aggregate function is a function where values of multiple rows or records are joined together to get a single value output. Common aggregate functions are:

• Average
• Count
• Sum

86. What do you mean by GROUP BY Clause?

Ans:

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.

87. What are validators and converters?

Ans:

Validators	Converters
Validators and Convertors are used to provide conversion and validation capabilities to the ADF input components respectively.	Converters convert the values on ADF forms to the type in which the application accepts them after the values are edited on the form and submitted. Validators are used to impose validations on the input components.

88. What is a subquery and what are the different types of subqueries?

Ans:

Sub Query is also called a Nested Query or Inner Query which is used to get data from multiple tables. A subquery is added in the where clause of the main query.

There are two different types of subqueries:

Correlated subquery

Correlated subquery cannot be an independent query but can reference columns in a table listed in the front 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.

89. What is cross join?

Ans:

Cross join is defined as the Cartesian product of records from the tables present in the join. Cross join will produce a result which combines each row from the first table with each row from the second table.

90. How to integrate with oracle web center sites?

Ans:

91. What are temporal data types in Oracle?

Ans:

Oracle provides following temporal data types:

Date Data Type – Different formats of Dates

TimeStamp Data Type – Different formats of TimeStamp

Interval Data Type – Interval between dates and time

92. How do we create privileges in Oracle?

Ans:

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]

93. What is VArray?

Ans:

VArray is an oracle data type used to have columns containing multivalued attributes and it can hold a bounded array of values.