Interview Questions.

Q1. How Does Developer Know In Which Version They Are Working?
Need to check construction name OR select version_no from apex_release;

Q2. How Might You Enable Sso For Apex Application?
Login to APEX_030200

@loadsdk.sql;

@regapp.sql;

Q3. A few Views Of Apex?
apex_workspaces,apex_workspace_activitiy_log and so forth

Q4. I Have Installed Oracle 11g Enterprise Database With A View To Use The Embedded Apex But Dont Know How To Launch It?
Prophet peak naturally while establishment of prophet DB .But you really want to arrange access component to send off APEX application.

Apache (Web Server)
Installed PL/SQL passage
Prophet Listner
Q5. The amount Does Apex Cost And Where Can I Get It?
Summit comes pre-introduced and totally coordinated with Oracle Database Express Edition(XE). For any remaining versions of Oracle Database, Oracle Application Express comes as a free extra that can be downloaded and introduced. Assuming you decided to "attempt before you purchase", or since it's free, "attempt before you introduce", you can likewise utilize the facilitated APEX Online office. This office permits you to make and run total applications similarly as you would on your own hardware.

Q6. Where Can I Try Apex?
As referenced above, you can pursue a free record at APEX.ORACLE.COM (Oracle's facilitated Application Express site). At the point when you pursue a record, you distinguish the workspace name that you need to utilize and recognize a chairman. From that point you can make applications and clients similarly as you would on your own equipment and systems.apex.oracle.com isn't planned for creation frameworks, it is expected for investigation and testing. For extra facilitating organizations, look at the Oracle. These destinations offer changing degrees of facilitating including free engineer access and full application organization.

Q7. What Is The Future Of Application Express?
Prophet has earnestly committed to Application Express. In a genuinely brief time frame, APEX has come to form 3.@Every delivery makes it more straightforward to utilize and send applications. While late deliveries have further developed APEX incorporation with SOA, APEX doesn't attempt to rival jDeveloper or the Oracle Java stack. Pinnacle is the paste that can join different pieces of an endeavor arrangement into an entirety. Summit is the apparatus of decision to make online, data set driven applications. Assuming that your business rationale is in the data set level, APEX is the best approach. Assuming your rationale is in the center level or is carried out at the java level, J2EE might be the better decision. Zenith take-up has multiplied in the previous year and great many designers are utilizing APEX. Numbers like these guarantee a sound future for APEX. A new INFOWORLD ARTICLE contains the accompanying:

"We will take out the need to grasp the data set," said Mike Hichwa, VP of programming advancement at Oracle, discussing Application Express 3.1, which is probably going to show up before year-end. The following arrival of the instrument will hold its center usefulness yet will likewise be more wizard-driven so it's simpler for nonprogrammers to utilize, he added.

Application Express empowers Oracle information base clients, incorporating those with restricted specialized abilities, to make and oversee secure Web applications utilizing just a Web program. The apparatus can be utilized to model Web-based applications as well as run those applications supporting tens to thousands of clients.

Presently, Oracle gauges that around 100,000 designers are utilizing Application Express consistently, however the organization might want to open up the instrument to a lot more clients, Hichwa said. Prophet's especially intrigued by those individuals who are as of now utilizing Microsoft Corp's. Access data set or its Excel calculation sheet or IBM Corp's. Lotus Notes groupware to foster Web-based applications.

Q8. How Kind Of Activities You Have Helped Apex As Apex Dba?
arrangement of pinnacle climate
SSL design
Client access
Security modular definition
specially appointed issue and goal
Fixing/Performance/
Q9. Where Can I Get More Information?
Notwithstanding the OTN gatherings and local area destinations, Application Express has an immense continuing in the blogosphere. Numerous master level assets keep up with web journals about APEX.

A few especially notable web journals are:

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

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

DIMITRI GELLIS - Another long-term Oracle vetand fellow benefactor of APEX Evangelists, an APEX explicit organization, with John Scott.

JOHN SCOTT-As referenced above, prime supporter of APEX Evangelists, an Oracle ACE, and Application Express Developer of the Year for2006.

You can find these and more at the OTN COMMUNITY SITE.

Q10. What Are The Different Type Of Apex Users?
Clients are partitioned into three essential jobs engineer, Workspace managers and Instance overseers

Q11. Who Uses Apex?
In the event that you are running on prophet data set and you need to construct rich web application with reports, structures, graphs, drill downs and dashboards with restricted Java experienced designers in a brief period of time, Oracle APEX is the most probable possibility for thought.

Q12. Which Platforms Are Supported By Oracle Application Express?
Prophet Apex chips away at the accompanying working frameworks:

Linux x86
Macintosh OS X Server
Linux on Power
Linux x86-64
z/Linux
Linux Itanium
Solaris x86
Solaris Operating System (SPARC) (64 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
Q13. Let me know It Is Said That Smile And Patience Are Two Vital Aspects Of A Sales Job. What Is Your Opinion?
Indeed, it is totally correct.

You ought to have a lovely character to intrigue your client. Ensure that you converse with them cheerfully. It will make a cordial climate among you and your client. Your one grin can cause them to feel great.

Having tolerance is one more significant part of a deals work. You meet clients with various demeanor every day. Take care of their questions calmly. Don't communicate any kind of disappointment. Continuously had, persistence will give great outcomes toward the end.

Q14. How Might You Direct Your Application To Use Https Instead Of Http?
Make wallet from apache home (wallet ought to be in prepared state)
design ssl.conf document
restart apache
check with opmnctl status - l
Q15. How Apex Architecture Works?
Pinnacle is introduced on Oracle data set (above 9.2 variant), beginning from Oracle 11g it comes pre-introduced with the information base. It is contained meta information in tables, pl/sql code and broad JavaScript APIs.

The URL demand from the program is trlated into fitting APEX PL/SQL call by either Oracle HTTP Server (Apache) with mod_plsql module or Embedded PL/SQL Gateway. This changes by the sort of APEX establishment on prophet data set. After the information is handled, results are handed-off back to program as HTML. This cycle happens each time client demand or present a page. The application meeting state is kept up with in data set tables.

Peak establishment should be possible in two ways. DBAs are more worried about it than engineers. Be that as it may, this decides how the URL is trlated.

Q16. What Are Skills Required For Apex Developers?
SQL, PL/SQL are fundamental. HTML, CSS and JavaScript are great to have abilities to comprehend and tweak look and feel (subjects, formats, … . ).

Q17. How Might You Validate Apex?
Utlrp.sql or

SQL> executive validate_apex; (If your APEX rendition is 2.0 or above)

                    Or then again

SQL> executive validate_htmldb; (If your APEX rendition is preceding 2.0