Interview Questions.

Q1. What Is Oracle Application Express?
Prophet Application Express (likewise called APEX and previously called HTML DB) is a FREE RAD web improvement device. Summit is composed utilizing PL/SQL and runs totally within an internet browser. Summit is an IDE and a runtime climate. You use APEX to compose web applications. Clients, utilizing their data set client ID, sign into APEX and run their application from a menu. With the APEX IDE, you can make structures, reports and diagrams. All of the ordinary web gadgets are accessible: radio gatherings, buttons, drop down records, date pickers, and so on. You could in fact coordinate your own JavaScript code would it be a good idea for you really want it. Yield from APEX applications can be to the screen or to PDF, Excel bookkeeping sheet, Flash, or even incorporated into a web administration.

You can involve a provided subject for a predictable look and feel or make your own subject for a customized feel to your application. The main thing to recall about Oracle Application Express is that it is planned starting from the earliest stage to be firmly incorporated with the Oracle Database, to be a completely able web improvement climate, and to be simple enough for insightful business clients to make or expand applications for themselves.

Q2. How Do I Backup And Restore An Oracle Xe Database?
Backing up and reestablishing Oracle Database XE depends on safeguarding the actual documents that make up the information base:

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

The control document SPFILE is in C: oraclexe application prophet item 10.2.0 server dbs.

On the off chance that in ARCHIVELOG mode, the re-try log documents ought to be supported. Two re-try log documents are in

C: oraclexe application prophet Vlash_recovery_areaVE ONLINELOG.

Cold back up is the point at which you plug the data set and compress up that large number of 9 records (in NOARCHIVEMOD). At the point when you reestablish the data set duplicate each of the 9 documents back to similar envelopes.

In the event that the application is in ARCHIVEMOD and ought to run 24X7, utilize hot reinforcement.

Q3. How Do You Know What Version Apex Is Install In System?
In the event that dba view access, select comp_name, variant, status from dba_registry or pattern client.

Q4. How Does Apex Integrate With The Database?
Prophet Application Express is really a data set application. The IDE, the menus, and each of the screens you find in APEX are written in PL/SQL. The meta information for those screens, reports, and menus are put away in social tables inside the data set. At the point when you point your program at the APEX URL, the Oracle HTTP audience (Apache +mod_plsql or the PL/SQL entryway, contingent upon data set rendition) gets that call and uses PL/SQL and the meta information put away in data set tables to paint the welcome screen.

At the point when you sign into APEX you are utilizing a real data set client ID. This client ID is related with a job (or jobs) inside the data set and these jobs figure out what access you will have. Assuming you are an overseer, you approach make clients and work areas. As a designer, you approach make new applications. On the off chance that you are designed as an end-client, you will actually want to run at least one applications. Prophet Application Express is coordinated with the Oracle Database as no climate is. In the event that you really want to broaden the fundamental usefulness of APEX, there is compelling reason need to gain proficiency with extra dialects or connection in extra libraries. On the interesting events you want to expand usefulness, you'll either involve SQL for information access or PL/SQL when procedural code is required.

Q5. Are There Any Limitations In Using Oracle Xe?
XE is free yet Oracle has incorporated specific restrictions into the item.
The main limit is memory. Prophet Database XE can address just 1GB of RAM. This impediment chiefly influences the number of clients that can get to the data set simultaneously and how well it performs.
As far as possible is that XE will just utilize one CPU. XE will run on a multi - CPU PC however wont increase to utilize those CPUs. This usefulness requires Oracle Database Standard Edition or Enterprise Edition.
As far as possible is that main a solitary XE information base can run on some random PC. You needn't bother with an information base for every application. All things being equal, Oracle utilizes the idea of blueprints to isolate applications.
At last, a 4GB breaking point is implemented on plate space. 4GB is an enormous measure of capacity for most applications. You can likewise utilize APEX to connection to different data sets (on different servers) for more capacity on a case by case basis.
Q6. How Do I Separate Development From Production Environment?
Contingent upon prerequisites for the accessibility of the application, the size of the client populace and different variables you can choose how to partition the advancement climate from the creation climate.
For specific applications, it is satisfactory to consolidate the improvement server with the organization server, as long as the end clients comprehend that occasionally the application isn't accessible.
Different applications might require two (improvement and creation) or even three (advancement, test and creation) servers.
In Application Express applications can be moved from one climate to another involving a product and import office for application definitions.
With one server accessible to run the information base and Application Express, you can in any case isolate the advancement variant of an application from its creation adaptation by utilizing two work areas getting to isolate mappings.
For this situation one work area will be utilized by designers and the other will be the work area in which the application is conveyed underway.
Q7. What Applications Come With Apex?
The ongoing adaptation of APEX permits you to download pre-bundled applications for you to gain from as well as change for your own purposes.

You can right now download (structure Oracle's Technology website):

Representative Directory Lookup - This is precisely exact thing it seems like.

Ask The Expert - Q&A Site ala "asktom".
Bug Tracker - Log and track bug reports.
Conversation Forum - Threaded visit, client the board, and that's only the tip of the iceberg.
Archive Library - Multi-client report store (Word, Excel, and so on).
Project Issue Tracker - Define, appoint, and report project issues.
Online Store - Catalog and shopping basket.
Programming Projects - Project task tracker.
You are by no me restricted to this rundown of ventures. An Internet look for "prophet APEX projects" Gets right around 500,000 hits and more are being posted constantly.

Q8. What Is The Current Version Of Apex And Why Should I Upgrade?
Beta rendition APEX 4.2 is delivered a long time back. This new adaptation offers numerous upgrades.

Among the most helpful are:

Print to PDF

Clients can decided to send out their reports and screens to PDF yield.
Move from MS-Access

Utilizing a product device and the Access Migration Workbench, you can relocate client applications to APEX.
Schedule Widget

More established variants incorporated a schedule gadget yet presently clients can pick between day, week, or month schedules.
Further developed Page and Region Caches

Reserving further develops execution.
Application Builder Defaults

execution improvements and extra convenience highlights for both the devel The engineer can set defaults for wizards to diminish advancement time (essentially subjects for development).The advantages of redesigning includeoper and the end client.
Prophet Database 10g Express Edition just backings Oracle APEX variant 2.2.

Q9. How Is Apex A Rad Tool?
Since APEX is so firmly incorporated to the data set, you can model screens while sitting with the client. The Object Browser permits you to make data set articles like tables as well as survey those equivalent items. This permits you to make objects on the fly and afterward assemble tables around those articles. The IDE, including the above Table manufacturer, and all applications are run inside a program. Completion time is prompt. Since APEX is explanatory, you can without much of a stretch make changes progressively by means of the underlying wizards. Since APEX controls meeting data for you, and in light of the fact that you utilize the security structure incorporated into the Oracle Database, you can focus conveying applications, not on association setup and other run of the mill web advancement time killers.

Q10. By Which User We Connect To Apex Application?
apex_public_user

Q11. Should Static Files Be Placed In The Database?
Application Express applications might reference extra outer documents, for example, flowing templates (CSS), pictures and Javascript libraries.
These pictures can either be put on the document arrangement of the server that runs the web server or, when they are transferred utilizing Application Express' application developer, can be put away inside the information base.
An advantage of overseeing records, for example, pictures and CSS in the data set with the application manufacturer is that they can be sent out and brought into another Application Express climate or work area utilizing just a program.
Nonetheless, putting away related documents in the data set is suggested just when you have moderately couple of pictures and when the application isn't supposed to get through high solicitation throughput.
At the point when pictures, CSS and Javascript libraries are put away in the data set, a data set association is laid out each time the program demands one of these records.
In a high throughput application this might bring about excessive and undesirable burden on the data set.
Q12. What Kind Of Support Exists For Apex?
Application Express has a hearty local area to assist you with creating, convey, and use APEX applications. The main stop for help would be the APEX Forum sat Oracle Technology Network. This dynamic discussion gives tips and wers from numerous specialists both inside and beyond Oracle.

Different destinations include:

THE APEX WIKI - Wikipedia for the APEX swarm.

Summit STUDIO - Community made applications accessible for download.

Pinnacle MAILING LIST - Sign up for data and Q&A.

THE ORACLE APEX COMMUNITY LISTING The rundown is developing day to day.

Q13. What Are The Uses Of Apex?
Constructs proficient looking web applications that are both quick and secure.
Runs on and lives in Oracle data set. Summit structure and m