Interview Questions.

Question 1. Tell Me It Is Said That Smile And Patience Are Two Vital Aspects Of A Sales Job. What Is Your Opinion?

Answer :

Yes, it's far clearly right. 

You ought to have a nice persona so as to galvanize your consumer. Make positive which you speak to them with a grin in your face. It will create a pleasant environment among you and your customer. Your one smile can make them feel secure. 

Having patience is every other crucial component of a sales job. You meet customers with specific mindset every day. Attend to their queries patiently. Do now not express any form of dissatisfaction. Always bear in mind, having endurance will deliver proper consequences on the stop.

Question 2. What Is Oracle Application Express?

Answer :

Oracle Application Express (additionally referred to as APEX and previously called HTML DB) is a FREE RAD net improvement tool. APEX is written the usage of PL/SQL and runs absolutely internal of a web browser. Apex is an IDE and a runtime environment. You use APEX to write internet packages. Users, the usage of their database consumer ID, log into APEX and run their application from a menu. With the APEX IDE, you can create bureaucracy, reports and charts. All of the normal net widgets are to be had: radio agencies, buttons, drop down lists, date pickers, and so forth. You can even integrate your very own JavaScript code ought to you need it. Output from APEX applications can be to the display screen or to PDF, Excel spreadsheet, Flash, or maybe included into a web carrier.

You can use a supplied subject matter for a steady appearance and sense or create your very own subject matter for a customised sense on your utility. The most important thing to do not forget approximately Oracle Application Express is that it's miles designed from the ground up to be tightly included with the Oracle Database, to be a completely succesful internet improvement surroundings, and to be clean sufficient for savvy commercial enterprise users to create or make bigger applications for themselves.

PL/SQL Interview Questions
Question 3. What Are The Uses Of Apex?

Answer :

Builds professional searching net packages which might be both fast and comfortable.
Runs on and lives in Oracle database. APEX framework and meta statistics are saved in Oracle tables.
It is FREE. No licensing required.
Fast getting to know curve for builders to construct application.
Deployment of utility is as simple as ‘Export and Import’ if tough coded references of values that change between environments are avoided.
Lot of scope for personalisation of software appearance and feel.
Scalable for high user extent. ASKTOM, former ORACLE METALINK (before migrated to Flash version) and MANY APPLICATIONS are constructed the use of APEX.
Can be configured to apply Oracle SSO and EBS fnd consumer repository.
Question four. What Kind Of Activities You Have Done For Apex As Apex Dba?

Answer :

setup of apex surroundings
SSL configuration
USER get right of entry to
Security modal definition
advert hoc problem and resolution
Patching /Performance /
OBIEE Tutorial
Question five. How Do You Know What Version Apex Is Install In System?

Answer :

If dba view get admission to then pick out comp_name, version, popularity from dba_registry or schema consumer.

OBIEE Interview Questions
Question 6. How Does Developer Know In Which Version They Are Working?

Answer :

Need to test schema name   OR select version_no from apex_release;

Question 7. If You Forget Admin Password ,how Will You Login To Apex Application?

Answer :

We want to name square scripts to reset the password  @apxchpwd.Square (that is equal as regulate consumer username identifies by using password)

Oracle apps Interview Questions
Question 8. By Which User We Connect To Apex Application?

Answer :

apex_public_user

Question nine. Who Uses Apex?

Answer :

If you are going for walks on oracle database and also you need to build wealthy web software with reviews, bureaucracy, charts, drill downs and dashboards with restricted Java skilled builders in a brief time body, Oracle APEX is the most in all likelihood candidate for consideration.

Oracle Apps ERP Interview Questions
Question 10. How Apex Architecture Works?

Answer :

APEX is set up on Oracle database (above nine.2 model), starting from Oracle 11g it comes pre-set up with the database. It is produced from meta facts in tables, pl/sq. Code and big JavaScript APIs.

The URL request from the browser is translated into appropriate APEX PL/SQL name by way of both Oracle HTTP Server (Apache) with mod_plsql plugin or Embedded PL/SQL Gateway. This varies by using the sort of APEX set up on oracle database. After the statistics is processed, results are relayed returned to browser as HTML. This cycle takes place every time user request or post a page. The utility consultation nation is maintained in database tables.

APEX installation may be carried out in  ways. DBAs are more involved about it than developers. But this determines how the URL is translated.

Question eleven. What Are Skills Required For Apex Developers?

Answer :

SQL, PL/SQL are important. HTML, CSS and JavaScript are top to have talents to recognize and personalize look and sense (themes, templates, …. ).

Oracle ADF Interview Questions
Question 12. What Are The Different Type Of Apex Users?

Answer :

Users are divided into 3 primary roles developer, Workspace directors  and Instance administrators

PL/SQL Interview Questions
Question 13. Some Views Of Apex?

Answer :

apex_workspaces,apex_workspace_activitiy_log and so on

Question 14. How Will You Validate Apex?

Answer :

Utlrp.Sq.  Or

SQL> exec validate_apex; (If your APEX version is two.Zero or above)

                    OR

SQL> exec validate_htmldb; (If your APEX model is prior to two.Zero

Question 15. How Will You Enable Sso For Apex Application?

Answer :

Login to APEX_030200

@loadsdk.Sq.;

@regapp.Sq.;

Oracle DBA Troubleshooting Interview Questions
Question 16. How Will You Direct Your Application To Use Https Instead Of Http?

Answer :

Create wallet from apache home (pockets need to be in ready state)
configure ssl.Conf file
restart apache
verify with opmnctl reputation -l
Question 17. I Have Installed Oracle 11g Enterprise Database With A View To Use The Embedded Apex But Dont Know How To Launch It?

Answer :

Oracle apex by way of default even as set up of oracle DB .But you want to configure get entry to mechanism to release APEX software.

Apache (Web Server)
Embedded PL/SQL gateway
Oracle Listner
OBIEE 11g Interview Questions
Question 18. How Does Apex Integrate With The Database?

Answer :

Oracle Application Express is surely a database application. The IDE, the menus, and all the screens you spot in APEX are written in PL/SQL. The meta information for all of these displays, reports, and menus are stored in relational tables inside the database. When you factor your browser at the APEX URL, the Oracle HTTP listener (Apache +mod_plsql or the PL/SQL gateway, depending on database version) receives that name and uses PL/SQL and the meta statistics saved in database tables to color the welcome screen.

When you log into APEX you're the use of an actual database user ID. This person ID is associated with a role (or roles) inside the database and those roles determine what get right of entry to you may have. If you are an administrator, you've got get entry to to create users and workspaces. As a developer, you have got get right of entry to to create new packages. If you're configured as an end-user, you will be capable of run one or extra applications. Oracle Application Express is integrated with the Oracle Database as no surroundings is. If you need to increase the basic functionality of APEX, there is no need to learn additional languages or link in additional libraries. On the uncommon occasions you need to increase capability, you’ll both use SQL for facts get entry to or PL/SQL when procedural code is needed.

OBIEE Interview Questions
Question 19. How Is Apex A Rad Tool?

Answer :

Because APEX is so tightly incorporated to the database, you may prototype displays while sitting with the person. The Object Browser allows you to create database objects consisting of tables in addition to viewing the ones equal objects. This lets in you to create gadgets on the fly after which build tables around those items. The IDE, such as the above Table builder, and all applications are run within a browser. Turn-round time is instant. Because APEX is declarative, you may easily make changes in real-time via the built-in wizards. Because APEX controls consultation information for you, and due to the fact you use the safety framework constructed into the Oracle Database, you may concentration turning in applications, not on connection configuration and different normal net development time wasters.

Question 20. How Much Does Apex Cost And Where Can I Get It?

Answer :

APEX comes pre-installed and completely incorporated with Oracle Database Express Edition(XE). For all other editions of Oracle Database, Oracle Application Express comes as a loose add-on that may be downloaded and mounted. If you chose to “strive before you buy”, or because it’s free, “strive before you install”, you may additionally use the hosted APEX Online facility. This facility lets in you to create and run complete applications simply as you would to your very own equipment.

Oracle Apps Functional Interview Questions
Question 21. What Is The Current Version Of Apex And Why Should I Upgrade?

Answer :

Beta model APEX 4.2 is released multiple weeks returned. This new edition offers many enhancements.

Among the maximum useful are:

Print to PDF

Users can chose to export their reviews and screens to PDF output.
Migrate from MS-Access

Using an export device and the Access Migration Workbench, you can migrate person packages to APEX.
Calendar Widget

Older variations protected a calendar widget however now customers can pick between day, week, or month calendars.
Improved Page and Region Caches

Caching improves overall performance.
Application Builder Defaults

performance improvements and additional usability functions for both the devel The developer can set defaults for wizards to reduce improvement time (basically subject matters for development).The blessings of upgrading includeoper and the give up user.
Oracle Database 10g Express Edition most effective supports Oracle APEX version 2.2.

Question 22. What Applications Come With Apex?

Answer :

The contemporary model of APEX lets in you to down load pre-packaged applications that allows you to examine from and/or regulate for your own uses.

You can presently download (form Oracle’s Technology site):

Employee Directory Lookup – This is precisely what it appears like.

Ask The Expert – Q&A Site ala “asktom”.
Bug Tracker – Log and song bug reviews.
Discussion Forum – Threaded chat, person control, and greater.
Document Library – Multi-person record repository (Word, Excel, and so on).
Project Issue Tracker – Define, assign, and record assignment issues.
Online Store – Catalog and purchasing cart.
Software Projects – Project challenge tracker.
You are in no way confined to this listing of projects. An Internet look for “oracle APEX initiatives” Gets nearly 500,000 hits and more are being posted all of the time.

Question 23. Where Can I Try Apex?

Answer :

As mentioned above, you can join up for a free account at APEX.ORACLE.COM (Oracle’s hosted Application Express website online). When you sign up for an account, you identify the paintings vicinity call which you need to use and become aware of an administrator. From there you may create applications and users simply as you'll for your personal hardware and structures.Apex.Oracle.Com isn't always supposed for production systems, it's miles supposed for exploration and trying out. For additional hosting organizations, test out the Oracle. These sites offer various tiers of website hosting together with unfastened developer access and complete utility deployment.

Oracle Apps DBA Interview Questions
Question 24. What Kind Of Support Exists For Apex?

Answer :

Application Express has a sturdy network to help you broaden, deliver, and use APEX programs. The first forestall for guide will be the APEX Forum sat Oracle Technology Network. This energetic forum provides suggestions and solutions from many experts both outside and inside of Oracle.

Other web sites include:

THE APEX WIKI – Wikipedia for the APEX crowd.

APEX STUDIO – Community created packages to be had for down load.

APEX MAILING LIST – Sign up for information and Q&A.

THE ORACLE APEX COMMUNITY LISTING The list is growing day by day.

Oracle apps Interview Questions
Question 25. Where Can I Get More Information?

Answer :

In addition to the OTN boards and network web sites, Application Express has a massive following within the blogosphere. Many expert level resources hold blogs about APEX.

Some especially widely recognized blogs are:

SCOTT SPENDOLINI– APEX Guru and proprietor of Sumner Technologies (an APEX Training, Services, and Consulting employer).

PATRICK WOLF– Inside Oracle APEX, Patrick is along-time Oracle veteran.

DIMITRI GELLIS – Another lengthy-time Oracle vetand co-founding father of APEX Evangelists, an APEX unique employer, with John Scott.

JOHN SCOTT– As mentioned above, co-founding father of APEX Evangelists, an Oracle ACE, and Application Express Developer of the Year for2006.

You can locate all of these and more at the OTN COMMUNITY SITE.

Question 26. What Is The Future Of Application Express?

Answer :

Oracle has made a big dedication to Application Express. In a fairly quick time, APEX has made it to model three.0. Every launch makes it less complicated to use and install packages. While current releases have progressed APEX integration with SOA, APEX does now not try to compete with jDeveloper or the Oracle Java stack. APEX is the glue which could combine various elements of an enterprise answer into a whole. APEX is the device of preference to create net-based, database-centric programs. If your business logic is inside the database tier, APEX is the manner to move. If your common sense is within the center tier or is carried out at the java degree, J2EE may be the higher desire. APEX take-up has doubled in the beyond yr and thousands of builders are the usage of APEX. Numbers like those make certain a wholesome future for APEX. A recent INFOWORLD ARTICLE consists of the subsequent:

“We’re going to take out the want to recognize the database,” stated Mike Hichwa, vice chairman of software program development at Oracle, speakme approximately Application Express 3.1, that's in all likelihood to seem before year-cease. The next release of the tool will keep its core functionality however can also be more wizard-pushed so it’s simpler for nonprogrammers to use, he introduced.

Application Express permits Oracle database customers, which include those with confined technical abilties, to create and manipulate comfortable Web programs the usage of handiest a Web browser. The tool may be used to prototype Web-based totally packages in addition to run those programs helping tens to thousands of customers.

Currently, Oracle estimates that round a hundred,000 developers are using Application Express on a monthly foundation, however the business enterprise would love to open up the tool to many extra users, Hichwa stated. Oracle’s specifically interested by those folks that are currently the usage of Microsoft Corp.’s Access database or its Excel spreadsheet or IBM Corp.’s Lotus Notes groupware to develop Web- based programs.

Oracle Core Dba Interview Questions
Question 27. Are There Any Limitations In Using Oracle Xe?

Answer :

XE is free however Oracle has constructed certain barriers into the product.
The first challenge is reminiscence. Oracle Database XE can address simplest 1GB of RAM. This quandary specifically impacts how many users can get entry to the database concurrently and the way properly it performs.
The 2nd restrict is that XE will simplest use one CPU. XE will run on a multi -CPU computer but wont scale up to use the ones CPUs. This functionality requires Oracle Database Standard Edition or Enterprise Edition.
The 1/3 restrict is that handiest a single XE database can run on any given computer. You do now not need a database for each application. Instead, Oracle uses the concept of schemas to separate packages.
Finally, a 4GB restrict is enforced on disk space. 4GB is a large quantity of garage for maximum programs. You also can use APEX to hyperlink to different databases (on different servers) for greater garage as wanted.
Oracle Apps ERP Interview Questions
Question 28. How Do I Backup And Restore An Oracle Xe Database?

Answer :

Backing up and restoring Oracle Database XE is primarily based on defensive the bodily documents that make up the database:

There are 6 files in C:oraclexeoradataXE: CONTROL.DBF, SYSAUX.DBF, SYSTEM.DBF, TEMP.DBF, UNDO.DBF and USER.DBF.

The manipulate record SPFILE is in C: oraclexe app oracle product 10.2.Zero server dbs.

If in ARCHIVELOG mode, the redo log documents need to be subsidized up. Two redo log files are in

C: oraclexe app oracle Vlash_recovery_areaVE ONLINELOG.

Cold lower back up is when you stop the database and zip up all those 9 files (in NOARCHIVEMOD). When you repair the database replica all nine files lower back to the identical folders.

If the application is in ARCHIVEMOD and should run 24X7 then use warm backup.

Question 29. Should Static Files Be Placed In The Database?

Answer :

Application Express packages can also reference additional outside documents such as cascading style sheets (CSS), pictures and Javascript libraries.
These snap shots can both be placed at the report system of the server that runs the internet server or, when they're uploaded the usage of Application Express’s application builder, may be saved inside the database.
A gain of managing documents inclusive of photographs and CSS inside the database with the application builder is they may be exported and imported into another Application Express environment or workspace using most effective a browser.
However, storing associated files within the database is usually recommended only when you have distinctly few pix and when the utility is not expected to undergo high request throughput.
When snap shots, CSS and Javascript libraries are stored within the database, a database connection is mounted on every occasion the browser requests this type of documents.
In a excessive throughput utility this could bring about undue and undesirable strain at the database.
Question 30. How Do I Separate Development From Production Environment?

Answer :

Depending on requirements for the availability of the software, the scale of the consumer population and other elements you may determine how to divide the improvement surroundings from the production surroundings.
For certain programs, it's miles perfect to mix the improvement server with the deployment server, as long as the stop users keep in mind that on occasion the application isn't always available.
Other applications may also require  (improvement and manufacturing) or maybe three (development, take a look at and manufacturing) servers.
In Application Express packages can be moved from environment to environment the use of an export and import facility for software definitions.
With one server available to run the database and Application Express, you can nevertheless separate the development version of an application from its production model with the aid of using  workspaces having access to separate schemas.
In this example one workspace can be utilized by builders and the opposite may be the workspace in which the software is deployed in manufacturing.
Question 31. Which Platforms Are Supported By Oracle Application Express?

Answer :

Oracle Apex works on the subsequent operating systems:

Linux x86
Mac OS X Server
Linux on Power
Linux x86-sixty four
z/Linux
Linux Itanium
Solaris x86
Solaris Operating System (SPARC) (sixty four bit)
Microsoft Windows (32 -bit)
Microsoft Windows (64 -bit Itanium)
Microsoft Windows (x64)
AIX5L
HP-UX PA -RISC
HP Tru64 UNIX (Compaq / DEC)
HP-UX Itanium