Oracle Apex Basics Quiz (MCQs) Part-1

Here is the quiz for Oracle Apex beginners to answer 15 basic questions (MCQs) about Oracle Apex.

This test can be used for self-assessment or interview purposes.

#1. From which database view you can know the Oracle Apex version installed?

apex_version

apex_version

apex_info

apex_info

apex_release

apex_release

apex_ver_info

apex_ver_info

#2. What is the name of main Oracle Apex installation SQL script?

apexinstall.sql

apexinstall.sql

apexins.sql

apexins.sql

apxins.sql

apxins.sql

apex_sql.sql

apex_sql.sql

#3. What is the name of the DB procedure used to set the HTTP port in Oracle Apex?

DBMS_APEX.SETHTTPPORT

DBMS_APEX.SETHTTPPORT

DBMS_XDB.HTTPPORT

DBMS_XDB.HTTPPORT

DBMS_APX.SETHTTPPORT

DBMS_APX.SETHTTPPORT

DBMS_XDB.SETHTTPPORT

DBMS_XDB.SETHTTPPORT

#4. Data Workshop Feature Introduced in which Oracle Apex version?

Version 20.1

Version 20.1

Version 5.1

Version 5.1

Version 19.1

Version 19.1

Version 20.2

Version 20.2

#5. To set an Item label to left side which Template setting is used?

Optional

Optional

Hidden

Hidden

Optional Floating

Optional Floating

Required Floating

Required Floating

#6. In Master-Detail form, to link Detail to the Master what you need to specify?

Master Table

Master Table

Master Region

Master Region

Master Form Process

Master Form Process

Master Block

Master Block

#7. Which one of the following will give Hello World! message in alert box?

apex.alert.message("Hello World!");

apex.alert.message("Hello World!");

apex.message.text("Hello World!");

apex.message.text("Hello World!");

apex.message.alert("Hello World!");

apex.message.alert("Hello World!");

apex.message.dialog("Hello World!");

apex.message.dialog("Hello World!");

#8. Which one is the correct PL/SQL expression to check salary item is greater than 1000?

:P1_SALARY > 1000

:P1_SALARY > 1000

:P1_SALARY > :1000

:P1_SALARY > :1000

$V("P1_SALARY") > 1000

$V("P1_SALARY") > 1000

P1_SALARY > 1000

P1_SALARY > 1000

#9. Which one of the following is not correct JavaScript command to set an item value?

$s("P1_NAME", "VINISH");

$s("P1_NAME", "VINISH");

apex.item.setValue("P1_NAME", "VINISH");

apex.item.setValue("P1_NAME", "VINISH");

apex.item("P1_NAME").setValue("Vinish");

apex.item("P1_NAME").setValue("Vinish");

All of above

All of above

#10. Which one of the following is Invalid Page type in Oracle Apex?

Normal Form

Normal Form

Normal

Normal

Modal Dialog

Modal Dialog

Non-Modal Dialog

Non-Modal Dialog

#11. In which source property of Static Content Region, you can add the custom HTML?

Text

Text

HTML Expression

HTML Expression

Custom Attributes

Custom Attributes

Column

Column

#12. For a Region, you can span a maximum of how many columns?

10

10

12

12

15

15

20

20

#13. For Pre-Rendering, you can not create a process for which one of the following?

Before Header

Before Header

After Header

After Header

After Regions

After Regions

Before Regions

Before Regions

#14. Can you submit a page through a dynamic action?

True

True

False

False

#15. Which one of the following is not a valid source type for a report?

Table / View

Table / View

SQL Query

SQL Query

Function body returning SQL query

Function body returning SQL query

Database procedure

Database procedure

Finish

Results

-