Free Oracle APEX Developer and Application Questions and Answers — Questions and Answers
Question 1: The Oracle APEX was formerly known as:
- Oracle APX
- Oracle DB
- Oracle Tool
- HTML DB (Correct answer)
Correct answer: HTML DB
Explanation: <br> The correct answer is HTML DB. Oracle APEX was previously known as HTML DB.
Question 2: The Oracle APEX supports these operating systems except:
- Windows
- Chrome OS (Correct answer)
- Linux
- IBM AIX
Correct answer: Chrome OS
Explanation: <br> Oracle APEX supports various operating systems, including Windows, Linux, and IBM AIX. However, it does not support Chrome OS. This means that users cannot run Oracle APEX on devices that have Chrome OS as their operating system.
Question 3: Which of these is the developer of Oracle APEX?
- Oracle Team
- Oracle Inc
- Oracle Corporation (Correct answer)
- Oracle Company
Correct answer: Oracle Corporation
Explanation: <br> Oracle Corporation is the correct answer because it is the official developer of Oracle APEX. Oracle Corporation is a multinational technology corporation that specializes in developing and marketing computer hardware systems and enterprise software products. They are widely recognized for their database management systems, including Oracle APEX, which is a low-code development platform used for building scalable web applications.
Question 4: Concerning the Oracle APEX names, which of these is odd?
- Flows
- Oracle Platform
- Project Marvel
- APEX Tool (Correct answer)
Correct answer: APEX Tool
Explanation: <br> The given options consist of names related to Oracle APEX. However, "APEX Tool" stands out as odd because it specifically mentions APEX as a tool, while the other options refer to broader concepts such as Flows, Oracle Platform, and Project Marvel. Therefore, "APEX Tool" is the odd one out in terms of the naming convention.
Question 5: The following are classes of vulnerability that affect APEX applications except:
- SQL injection
- Access control
- Cross-site scripting
- Automated control (Correct answer)
Correct answer: Automated control
Explanation: <br> Automated control is not a class of vulnerability that affects APEX applications. Vulnerabilities are weaknesses or flaws in a system that can be exploited by attackers, and automated control does not fall into this category. SQL injection, access control, and cross-site scripting are all common vulnerabilities that can affect APEX applications. SQL injection involves inserting malicious SQL code into a database query, access control refers to inadequate restrictions on user access and permissions, and cross-site scripting involves injecting malicious scripts into web pages viewed by other users.
Question 6: Who created APEX?
- Andrew Flow
- Mike Hichida (Correct answer)
- Mike Robbin
- Lord Thomas
Correct answer: Mike Hichida
Explanation: <br> Mike Hichida is the correct answer because he is the creator of APEX.
Question 7: The following are third-party libraries with which APEX comes standard with except:
- JQuery Mobile
- CKEditor
- AnyChart
- JQuery System (Correct answer)
Correct answer: JQuery System
Explanation: <br> APEX does not come standard with jQuery System. The other three libraries mentioned (jQuery Mobile, CKEditor, and AnyChart) are included with APEX.
Question 8: Michael has developed an app for tracking product defects. His navigation menu lists each product. He has defined application items and computations to hold the number of defects for each product. For example, for Hedgers, he has defined the application item HEDGER_DEFECTS. <br><br> How can Michael add the number of open defects in the navigation menu entries?
- Update the Navigation Menu template to Include Count.
- Update Template Options and set Display Count to True.
- Update the List Entry Label for Hedgers to Hedgers &HEDGER_DEFECTS., and similarly for other products. (Correct answer)
- Add &HEDGER_DEFECTS. to User Defined Attribute 01 in the navigation menu for Hedgers, and similarly for other products.
Correct answer: Update the List Entry Label for Hedgers to Hedgers &HEDGER_DEFECTS., and similarly for other products.
Explanation: <br> By updating the List Entry Label for each product in the navigation menu to include the application item reference, such as &HEDGER_DEFECTS., Michael can dynamically display the number of defects for each product in the navigation menu entries. This approach ensures that the defect count is updated automatically based on the application item value defined for each product.
Question 9: John is evaluating an old APEX application that has over 20 tabular forms. He wants to update the application and replace all of the tabular forms with interactive grids. <br><br> What is the fastest way for John to replace the old reports?
- Go to each page with a tabular form, copy the SQL Source from the Tabular Form region, and use it to create a new interactive grid.
- Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.
- Use the Upgrade Application utility and select the candidate objects listed for "Upgrade Tabular Form to Interactive Grid", select all, and then click Upgrade.
- Go to each report and change the type from Tabular Form to Interactive Grid. (Correct answer)
Correct answer: Go to each report and change the type from Tabular Form to Interactive Grid.
Explanation: <br> This option involves directly updating each report from a tabular form to an interactive grid. While it might seem straightforward, it could be time-consuming if John has to manually edit each report individually. However, if John is familiar with the structure of the application and the locations of the reports, this method could still be relatively efficient, especially if there are not too many reports to update.
Question 10: Which statement is true about creating and using a report with form?
- The Create Page Wizard doesn't support the creation of a classic report and formcombination
- The Create Application Wizard doesn't support the creation of an interactive report and form combination.
- In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
- Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination. (Correct answer)
Correct answer: Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
Explanation: <br> Both the Create Application Wizard and Create Page Wizard in Oracle APEX support the creation of reports with forms, whether it's an interactive report or a classic report combined with a form. These wizards provide convenient and efficient ways to create applications with integrated reporting and form functionality.
Question 11: Which two layout options are available for Page Designer under Utilities?
- Single Pane Mode (Correct answer)
- Four Pane Mode
- Two Pane Mode (Correct answer)
- Three Pane Mode
Correct answer: Single Pane Mode
Explanation: <br> In Page Designer under Utilities, you can find the Single Pane Mode and Two Pane Mode layout options. These modes determine how the Page Designer interface is displayed, allowing you to choose between a single-pane or two-pane layout for managing your application pages efficiently.
Free Oracle APEX Developer and Application Questions and Answers
The Oracle APEX was formerly known as: