Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ADFO 456

Total questions: 101

Worksheet time: 53mins

Name
Class
Date
1.

Which of the following actions can be carried out in Application Builder using a button page item?

a)

Redirect

b)

Submit a page

c)

All of the above

d)

Do nothing

2.

2. In Application Builder, you can reference item values stored in session state in regions, computations, processes, validation, and branches. True or False?

a)

True

b)

False

3.

3. In Application Builder, you cannot use buttons to perform a Dynamic Action. True or False? True

a)

True

b)

False

4.

Which of the following is not an item in Application Builder?

a)

Check box

b)

SQL Query

c)

Text area

d)

Select list

e)

password

5.

In Application builder, a list based on predefined pairs of display values and return values is known as

a)

A user defined list

b)

A scratch list

c)

A dynamic list

d)

A static list

6.

In Application Builder, you can use buttons to direct users to a specific page or URL, or to post or process information. True or False?

a)

True

b)

False

7.

Application Builder provides which of the following form types?

a)

Report with Form

b)

List View with Form

c)

From on a Local Procedure

d)

None of the above

e)

All of the above

8.

Forms can enable users to update multiple rows in a table. True or False?

a)

True

b)

False

9.

Forms are made up of types. True or False?

a)

True

b)

False

10.

Forms can be created in Application Builder suing which of the following methods?

a)

Manually

b)

Uploaded from an external application

c)

Using a wizard

d)

Both manually and using a wizard

e)

All of the above

11.

Application Builder allows which of the following data sources when creating a form?

a)

Local database table

b)

Local database sql query

c)

REST enabled SQL service

d)

Web source

e)

All of the above

12.

Forms are made up of fields, called items. True or False?

a)

True

b)

False

13.

Forms are application components that are used for data input from end users. True or False?

a)

True

b)

False

14.

Which of the following statements best describes a Form on a Local Procedure Application Builder form type?

a)

Builds a form based on stored procedure arguments.

b)

Creates two pages. One page displays a report

c)

Presents users a set of data in a searchable, customizable report.

d)

Creates a form and list view that enables users to update a single row in a database table

15.

Match the descriptions to the two processes Application Express engine relies on when you run an (1/1) Points Previous Page 3 of 10 Next Summary application. (Choose two)

a)

Accept Page : performs page processing.

b)

Accept Page : is the page rendering process

c)

Show Page : performs page processing.

d)

Show Page : is the page rendering process.

16.

If you wanted to assign a value to an identified item when a page is displayed or submitted you would use?

a)

A Trigger

b)

A Page-rendering computation.

c)

Page-processing computation.

d)

A PL/SQL statement

17.

In Application Builder, a branch is an instruction to go to a specific page, procedure, or URL. True or False?

a)

True

b)

False

18.

Which of the following are types of Page process in Application Builder? (Choose two)

a)

Automatic Row Processing.

b)

PL/SQL Row Processing

c)

Automatic Row Fetch.

d)

SQL Row Fetch.

19.

When you create a branch, you must specify a Branch Point and Branch Type. True or False?

a)

True

b)

False

20.

A page process is a specific event that runs when a page is loaded or submitted. True or False?

a)

True

b)

False

21.

Which of the following are types of Validations in Application Builder? (choose two)

a)

Application Control Validation

b)

Page Validation.

c)

Page Control Validation

d)

Page Item Validation.

22.

The process to retrieve records from a single database table or view in Application Builder is defined as which of the following?

a)

PL/SQL Row Processing.

b)

Automatic Row Fetch.

c)

SQL Row Fetch

d)

Automatic Row Processing.

23.

Validations that apply to an entire page in Application Builder are defined as which of the following?

a)

Page Validation.

b)

Page Control Validation.

c)

Page Item Validation

d)

Application Control Validation.

24.

Which of the following is not an example of shared components?

a)

Breadcrumbs

b)

Pull down menu

c)

Lists

d)

Navigation bar

e)

Navigation menu

25.

In Application Builder you can create which types of Lists? (Choose two)

a)

Hierarchical Lists

b)

Static Lists

c)

Navigation Lists

d)

Dynamic Lists

26.

Which of the following statements best describe Lists as a Shared Component?

a)

Provide users with hierarchical navigation. A hierarchical list of links that display using templates. Can be displayed as a list of links or as a path.

b)

A shared collection of links. You control the appearance through templates. Each element has a display condition that enables you to control when it displays.

c)

An effective way to navigate users between pages in an application. You can create two types : standard or parent

d)

Offer users a simple navigation path for moving between pages in an application. Entries can display as a link from an image or text

e)

A list of links that enables users to navigate the pages in an application. Only supported in applications using the Universal Theme - 42

27.

Which of the following statements best describe Navigation Menu as a Shared Component?

a)

A list of links that enables users to navigate the pages in an application. Only supported in applications using the Universal Theme - 42.

b)

A shared collection of links. You control the appearance through templates. Each element has a display condition that enables you to control when it displays

c)

Provide users with hierarchical navigation. A hierarchical list of links that display using templates. Can be displayed as a list of links or as a path.

d)

An effective way to navigate users between pages in an application. You can create two types : standard or parent.

e)

Offer users a simple navigation path for moving between pages in an application. Entries can display as a link from an image or text.

28.

Shared components can only be added to one page within your application. True or False?

a)

True

b)

False

29.

The Universal Theme is a user interface for Application Express that enables developers to build (1/1) Points Previous Page 6 of 10 Next Summary modern web applications without requiring extensive knowledge of HTML, CSS, or JavaScript. True or False?

a)

True

b)

False

30.

The Theme Roller offers the workspace administrator the ability to? (Choose three)

a)

Customize the look and feel of applications.

b)

Share customizations with other administrators through a gallery

c)

Use customizations designed by other administrators from a gallery

d)

Modify attributes and see changes applied to your in real time

e)

Save customizations as a Theme Style.

31.

Template options provide a declarative way for developers to apply different styles to components on an application page. True or False?

a)

True

b)

False

32.

Application Builder supports all of the following types of charts except:

a)

Chart

b)

CustomChart Chart

c)

AnyChart Chart

33.

Authentication may require a user to?

a)

Provide a digital certificate

b)

Enter a user name and password.

c)

Provide a secure key

d)

All of the above

34.

Authentication defines who you are whilst Authorization defines What are you allowed to do after logging in. True or False?

a)

True

b)

False

35.

An exported application from APEX is saved as a .xml file type. True or False?

a)

True

b)

False

36.

Define the order of the steps required when importing an application.

a)

Application, Table and Trigger Definitions, Table Data.

b)

Table and Trigger Definitions, Application, Table Data

c)

Table Data, Table and Trigger Definitions, Application.

d)

None of the above

37.

Which of the following are the correct order of steps to migrate an application between environments?

a)

Export, Import, Recreate Objects, Populate Tables, Test.

b)

Export, Import, Populate Tables, Recreate Objects, Test

c)

Export, Recreate Objects, Populate Tables, Import, Test.

d)

Export, Populate Tables, Recreate Objects, Import, Test

38.

In APEX you add a chart region to your page using Page Designer. True or False?

a)

True

b)

False

39.

A tree is a hierarchical navigation mechanism. True or False?

a)

True

b)

False

40.

Which of the following calendar types is template-based and may be deprecated in the future release?

a)

Calendar

b)

Custom Calendar

c)

Legacy Calendar

d)

User Calendar

e)

All of the above

41.

Which of the following chart types is a flexible Flash and JavaScript (HTML5) based solution?

a)

Chart

b)

AnyChart Chart

c)

CustomChart Chart

d)

All of the above

42.

Application Builder supports the following types of charts except for:

a)

CustomChart Chart

b)

Chart

c)

AnyChart Chart

43.

Application Builder supports which of the following types of calendars? (Choose two)

a)

User Calendar

b)

Calendar

c)

Legacy Calendar

d)

Custom Calendar

44.

To use Dynamic actions to define complex client-side behavior declaratively you need to know or code JavaScript or AJAX. True or False?

a)

True

b)

False

45.

You can create a dynamic action in which of the following ways?

a)

Under Rendering, locate the item, right-click and select Create Dynamic Action.

b)

Under Dynamic Actions, right-click Events and select Create Dynamic Action

c)

All of the above

46.

Which of the following steps are required to be defined when creating a Dynamic Action?

a)

When the action happens (with optional conditions)

b)

What action or actions are performed

c)

What elements are affected by the action

d)

All of the above

47.

Change, Click, Double Click, Get Focus, and so on would best describe which type of Dynamic Action Event?

a)

Framework Event

b)

Custom Event

c)

Component Event

d)

Browser Event

48.

A plug-in is one of the built-in types of Application Express. True or False

a)

True

b)

False

49.

Which of the following is the best description of a Dynamic Action?

a)

Validate that a Job Position is in MANAGER, SALESMAN or CLERK

b)

Provide a list of values to be shown for Commission and Hire date fields.

c)

Ensure that the Commission and Hire date fields are enabled only if the Job is SALESMAN.

d)

None of the above

50.

Developers can export and import plug-ins to other workspaces. True or False?

a)

True

b)

False

51.

Which of the following best describes utilities within SQL Workshop

a)

Enables developers to use SQL Commands to create,edit,view,run and delete database objects

b)

Enables developers to browse create and edit objects in database

c)

enables developers to use sql scripts to create edit view run and delete database objects

d)

enables the declarative specification of RESTful services used to access the database

e)

Enables developers to build SQLqueries load and unload data from an Oracle Database generate DDL

52.

Which of the following best describes Object Browser within SQL Workshop

a)

Enables developers to use SQL Commands to create edit view run and delete database objects

b)

Enables the declarative specification of RESTful services used to access the database

c)

Enables developers to build SQL queries, loadn and unload data from an oracle database, generate DDL

d)

Enables developers to use SQL Scripts to create, edit, view, run and delete database objects

e)

Enables developers to browse create and edit objects in database

53.

Which of the following are tools that enable you to view and manage database objects in the SQL Workshop?

a)

Object Browser.

b)

SQL Commands.

c)

SQL Scripts.

d)

Utilities.

e)

All of the above.

54.

Which of the following best describes an Application URL within App Builder?

a)

Performs any computations, validations, processes, and branching.

b)

Is a logical construct that establishes persistence across page views.

c)

Supports multiple user interfaces within a single application.

d)

The URL that displays in your browser which indicates the location of your Oracle Application Express application

e)

Is the basic building block of an application.

55.

An application is an HTML interface that exists on top of database objects such as tables or procedures. True or False?

a)

True

b)

False

56.

Which of the following best describes Packaged Applications within App Builder?

a)

The user interface is optimized for larger displays, such as desktop, laptop and tablet screens.

b)

Enable users to build data centric applications without any SQL programming knowledge.

c)

Include a set of business productivity and sample applications which can be installed with just a few clicks.

d)

None of the above

57.

You use an HTML Editor to build the pages that and them import them using App Builder to make up an Oracle Application Express application.

a)

True

b)

False

58.

Which of the following best describes an Application Page within App Builder?

a)

Is the basic building block of an application.

b)

Is a logical construct that establishes persistence across page views

c)

Performs any computations, validations, processes, and branching

d)

Supports multiple user interfaces within a single application

e)

The URL that displays in your browser which indicates the location of your Oracle Application Express application.

59.

Which of the following best describes the Application User Interface within App Builder?

a)

Is a logical construct that establishes persistence across page views.

b)

The URL that displays in your browser which indicates the location of your Oracle Application Express application.

c)

Is the basic building block of an application.

d)

Performs any computations, validations, processes, and branching.

e)

Supports multiple user interfaces within a single application.

60.

The User role of Workspace administrators cannot perform which of the following in Application Express?

a)

Create and Edit Applications

b)

Sign into Workspace

c)

Perform Administration Tasks

d)

Manage entire hosted instance

e)

Run existing Applications

61.

The Mid Tier of the Oracle Application Express Architecture is which of the following services?

a)

Embedded PL/SQL Gateway

b)

Oracle HTTP Server

c)

Oracle REST Data Services

d)

Web Browser

e)

None of the above

62.

Which of the following best describes Packaged Apps within Application Express?

a)

rovides tools to create the pages that make up an Oracle Application Express application

b)

Provides tools to view and manage database objects and data.

c)

Provides the ability to manage the full lifecycle of your application development

d)

Provides a suite of business productivity applications, easily installed with only a few clicks.

e)

None of the above

63.

Packaged apps are easily installed with only a few clicks. True or False?

a)

True

b)

False

64.

The User role of Developer can perform which of the following in Application Express?

a)

Perform Administration Tasks.

b)

Manage entire hosted instance.

c)

Sign into Workspace.

d)

Run existing Applications

e)

Create and Edit Applications

65.

Which of the following best describes Team Development within Application Express?

a)

Provides tools to create the pages that make up an Oracle Application Express

b)

Provides tools to view and manage database objects and data.

c)

Provides the ability to manage the full lifecycle of your application development

d)

Provides a suite of business productivity applications, easily installed with only a few clicks

e)

None of the above

66.

Developers can determine whether an interactive grid is editable or read-only. True or False?

a)

True

b)

False

67.

Interactive grid attributes allow developers to perform which of the following?

a)

Determine if end users can edit the underlying data

b)

All of the above

c)

Create error messages

d)

Configure the toolbar and download options

e)

Control if and how users can save an interactive grid

68.

The Code Editor within Page Designer is used to edit attributes requiring a large amount of code. True or False?

a)

True

b)

False

69.

Which of the following best describes a Modal Dialog Page Mode within App Builder?

a)

An overlay window positioned within the same browser window.

b)

A separate popup browser window.

c)

None of the above.

70.

Each page in an Oracle Application Express application can contain only one region. True or False?

a)

True

b)

False

71.

Which of the following best describes a Non-Modal Dialog Page Mode within App Builder?

a)

An overlay window positioned within the same

browser window.

b)

A separate popup browser window

c)

None of the above.

72.

Match the report capabilities to the statement "End user can add, modify, and refresh the data directly on the report".

a)

Interactive Report - No, Interactive Grid - Yes, Classic Report - Yes

b)

Interactive Report - Yes, Interactive Grid - No, Classic Report - Yes

c)

Interactive Report - Yes, Interactive Grid - No, Classic Report - No

d)

Interactive Report - Yes, Interactive Grid - Yes, Classic Report - No

73.

When you create an application all report types are available to create True or false?

a)

True

b)

False

74.

A classic report is the formatted result of a SQL Query. True or false

a)

True

b)

False

75.

A report is the formatted result of a SQL query. True or false?

a)

True

b)

False

76.

Application Express only allows you to perform a non-case sensitive search on the entire interactive report True or False?

a)

True

b)

False

77.

When using an interactive report, developers can change the way an interactive report is rendered to end users. True or false?

a)

True

b)

False

78.

When using an interactive report end users can decide order in which the columns appear in the report. True or False?

a)

True

b)

False

79.

When using an interactive report the default setting always displays NULL values first.

a)

True

b)

False

80.

When using an interactive report end users can specify column display sort order True or False?

a)

True

b)

False

81.

Which of the following best describes the From a spreadsheet option within App Builder?

a)

Allows you to assemble an initial set of application pages including blank, reports, and forms.

b)

Creates a table based on the spreadsheet data and then application with a report and a form is created

c)

Creates a copy of an existing database application.

d)

None of the above

82.

Which of the following types of applications can be created using App Builder

a)

Mobile web applications

b)

Website applications

c)

User applications

d)

Database applications

83.

Which of the following best describes the From scratch option within App Builder

a)

Allows you to assemble an initial set of application pages including blank, reports, and forms.

b)

Creates a table based on the spreadsheet data and then application with a report and a form is created

c)

Creates a copy of an existing database application

d)

None of the above

84.

Which of the following best describes the Copy an existing application option within App Builder?

a)

Allows you to assemble an initial set of application pages including blank, reports, and forms.

b)

Creates a table based on the spreadsheet data and then application with a report and a form is created.

c)

Creates a copy of an existing database application.

d)

None of the above

85.

Oracle Application Express includes the SQL Workshop for application developers to maintain database objects.  True or False?

a)

True

b)

False

86.

Which of the following best describes SQL Commands within SQL Workshop?

a)

Enables the declarative specification of RESTful services used to access the database

b)

Enables developers to use SQL Scripts to create, edit, view, run, and delete database objects

c)

Enables developers to build SQL queries, load and unload data from an Oracle database, generate DDL.

d)

Enables developers to browse, create, and edit objects in a database

e)

Enables developers to use SQL Commands to create, edit, view, run, and delete database objects

87.

Which of the following best describes Utilities within SQL Workshop?

a)

Enables developers to use SQL Commands to create, edit, view, run, and delete database objects

b)

Enables developers to use SQL Scripts to create, edit, view, run, and delete database objects

c)

Enables developers to browse, create, and edit objects in a database

d)

Enables the declarative specification of RESTful services used to access the database

e)

Enables developers to build SQL queries, load and unload data from an Oracle database, generate DDL

88.

Packaged Applications include a collection of sample applications which demonstrate some of the major features of Oracle Application Express.  True or False?

a)

True

b)

False

89.

The Oracle Application Express development environment does not consist of which of the following components?

a)

App Builder

b)

Team Development

c)

Database Administrator

d)

SQL Workshop

e)

Packaged Apps

90.

Oracle Application Express Architecture Tiers can be identified as which of the following?  (Choose three)

a)

Database Tier

b)

Mid Tier

c)

First tier

d)

Last Tier

e)

Browser

91.

In Application Express, an application is an HTML interface that exists on top of database objects such as tables or procedures.  True or False?

a)

True

b)

False

92.

In Application Express, a Workspace is best described as which of the following?

a)

A logical work area which is associated with one or more Oracle database schemas.

b)

An HTML interface that exists on top of database objects such as tables or procedures

c)

Divided in to four primary roles

d)

All of the above

e)

None of the above

93.

Which of the following best describes Desktop and Mobile Database Applications within App Builder?

a)

The user interface is optimized for larger displays, such as desktop, laptop and tablet screens.

b)

Enable users to build data centric applications without any SQL programming knowledge

c)

Include a set of business productivity and sample applications which can be installed with just a few clicks

d)

None of the above

94.

Which of the following best describes the Session State within App Builder?

a)

The URL that displays in your browser which indicates the location of your Oracle Application Express application.

b)

Is a logical construct that establishes persistence across page views

c)

Supports multiple user interfaces within a single application

d)

Is the basic building block of an application

e)

Performs any computations, validations, processes, and branching

95.

Which of the following best describes Object Browser within SQL Workshop?

a)

Enables developers to use SQL Commands to create, edit, view, run, and delete database objects

b)

Enables developers to browse, create, and edit objects in a database

c)

Enables developers to build SQL queries, load and unload data from an Oracle database, generate DDL

d)

Enables developers to use SQL Scripts to create, edit, view, run, and delete database objects

e)

Enables the declarative specification of RESTful services used to access the database

96.

Packaged apps are a suite of business productivity applications. True or False?

a)

True

b)

False

97.

The User role of Developer can perform which of the following in Application Express? (Choose three)

a)

Sign into Workspace

b)

Perform Administration tasks

c)

Manage entire hosted instance

d)

Run existing applications

e)

Create and edit applications

98.

Which of the following best describes the SQL Workshop within Application Express?

a)

Provides tools to create the pages that make up an Oracle Application Express application

b)

Provides tools to view and manage database objects and data

c)

Provides the ability to manage the full lifecycle of your application development

d)

Provides a suite of business productivity applications, easily installed with only a few clicks

e)

None of the above

99.

Which of the following best describes the Accept Page within App Builder?

a)

Supports multiple user interfaces within a single application

b)

Is the basic building block of an application

c)

Performs any computations, validations, processes, and branching

d)

The URL that displays in your browser which indicates the location of your Oracle Application Express application

e)

Is a logical construct that establishes persistence across page views

100.

You use an HTML Editor to build the pages that and them import them using App Builder to make up an Oracle Application Express application. True or False?

a)

True

b)

False

101.

You use the App Builder home page to

a)

Access workspace

b)

Create new applications

c)

Import applications

d)

Select an application to edit

e)

All of the above

Similar Resources on Wayground

English Speaking Countries Quiz

106 questions

English Speaking Countries Quiz

quiz

Worksheet

•

1st - 5th Grade

computer for grdade 6

100 questions

computer for grdade 6

quiz

Worksheet

•

2nd Grade

Informational Text Structures Quiz 3

97 questions

Informational Text Structures Quiz 3

quiz

Worksheet

•

1st - 5th Grade

JulMeg PTS 1 vers 2 2023

104 questions

JulMeg PTS 1 vers 2 2023

quiz

Worksheet

•

1st - 5th Grade

Mathematics Assignment 1

100 questions

Mathematics Assignment 1

quiz

Worksheet

•

1st - 5th Grade

Latihan Soal OSN SD

105 questions

Latihan Soal OSN SD

quiz

Worksheet

•

1st - 5th Grade