Oracle APEX вопросы и ответы для интервью

Вопрос 11. What are the key differences between SQL Workshop and Apex Workspace?

• SQL Workshop is a tool for working with SQL databases, while Apex Workspace is a tool for working with Oracle Application Express applications.
• SQL Workshop provides a user interface for running SQL queries and commands, while Apex Workspace provides a user interface for developing and managing Oracle Application Express applications.

Вопрос 12. Are there any performance issues when thousands of users access a single instance of Oracle?

There are no known performance issues when thousands of users access a single instance of Oracle. In fact, Oracle is designed to handle large numbers of users and transactions as it is scalable by default.

Вопрос 13. What are some best practices for developing web apps using Oracle Application Express (APEX)?

Some best practices for developing web apps using Oracle Application Express include using the built-in security features to control access to the app, using bind variables to avoid SQL injection attacks, and using the built-in report generation features to generate reports on app usage.

Вопрос 14. What is the usage of the apex_util package in Oracle APEX?

The apex_util package is used for a variety of tasks related to Oracle Application Express, including retrieving session information, generating HTML, and creating email messages etc.

Вопрос 15. How do you design a responsive page using Oracle Application Express?

In order to design a responsive page using Oracle Application Express, you will need to use the fluid grid layout. This will allow you to create a page that will resize itself based on the size of the device that it is being viewed on.