Blog Author
Tekslate
Published Date
24th September, 2020
Ratings
Views
347
Q.1) What is Oracle Apex?
Ans) Oracle Apex is a free web development tool. Apex runs on PL/SQL inside the web browser. Apex is a runtime environment. It is used to code web apps. User-specific with user ID lof into Apex & run the apps from the menu. We can create reports, forms & charts. Flexible to integrate our own javascript code. Outputs can be off the screen as PDF or to the screen, Flash, Excel Sheet or into web services via integration.
The most important and basic feature of Oracle Apex is that it is tightly integrated with Oracle DB, & fully capable of the web development environment. We can even customize the theme or use the basic theme for the look & feel of the application.
Q.2) What are the advantages of APEX? The following are the advantages of APEX:
Ans)
Q.3) SQL Statement that defines a foreign key constraint on column DEPT NO1 of EMP1 Table?
Ans) CREATE TABLE EMP1 (empno NUMBER(301), ename VARCHAR(45), deptno NUMBER(5,3), NOT NULL, CONSTRAINT emp1_deptno1_fk FOREIGN KEY deptno1 REFERENCES dept1(deptno1));
Q.4) What are DML Commands?
Ans) Delete, Update, Merge & Commit are the DML Commands.
The SQL Statement that generates alias od annual salary for column calculated SALARY*12? SELECT eno, ename, salary*12 ”Annual Salary” FROM employees1;
Q.5) Specify the user through which you connect to APEX application?
Ans)
Apex_public_use
Q.6)Skills required for APEX developers?
Ans) Basics of PL/SQL & SQL are required & the added advantage would be having skills related to customizing look and feel with Javascript, CSS, HTML.
Q.7) Mention the types of APEX Users? Actually, they are divided into 3 they are:
Ans)
Q.8) Define the support for APEX that exists?
Ans) Application Express could be the best community for some to help deliver, develop & the use of APEX applications. The basic support is from APEX forum of Oracle Tech Network. We can find answers & tips related to development from in & out of Oracle.
Q.9) Few Examples of Views of Apex?
Ans)
apex_workspace_activity_log, apex_workspace etc.
Q.10) Define how to direct application to Https instead of Http?
Ans)
Steps to Include:: Create wallet from apache home → configure ssl.conf file → Restart apache → Verify using optmnctl status - I
Q.11) What are the platforms that support Oracle Apex?
Ans) The below mentioned supports the Oracle Apex::
TekSlate
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us