Application Development Foundations Midterm Exam
The Oracle Application Express
development environment consists of which of the following components?
Packaged
Apps. (*)
App
Builder. (*)
SQL
Workshop. (*)
Team
Development (*)
Database
Administrator
In Application Express, a
Workspace is best described as which of the following?
A
logical work area which is associated with one or more Oracle database schemas.
(*)
An HTML
interface that exists on top of database objects such as tables or procedures.
Divided
in to four primary roles.
None of
the above.
The Mid Tier of the Oracle
Application Express Architecture is which of the following services?
Embedded
PL/SQL Gateway
Oracle
HTTP Server
Oracle
REST Data Services (*)
Web
Browser
None of
the above
In Application Express User
roles are best described as which of the following?
A
logical work area which is associated with one or more Oracle database schemas.
An HTML
interface that exists on top of database objects such as tables or procedures.
Divided
in to four primary roles. (*)
None of
the above.
The User role of End user can
perform which of the following in Application Express?
Create
and Edit Applications.
Sign
into Workspace.
Run
existing Applications. (*)
Perform
Administration Tasks.
Manage
entire hosted instance.
All of
the above.
Which of the following best describes Packaged Apps within
Application Express?
Provides
tools create the pages that make up an Oracle Application Express application.
Provides
tools to view and manage database objects and data.
Provides
the ability to manage the full lifecycle of your application development.
Provides
a suite of business productivity applications, easily installed with only a few
clicks. (*)
None of
the above.
Packaged Applications include a
collection of sample applications which demonstrate some of the major features
of Oracle Application Express?
True
(*)
False
Oracle Application Express
employs a 3 Tier Architecture?
True
(*)
False
In Application Express, an
application is an HTML interface that exists on top of database objects such as
tables or procedures?
True
(*)
False
Which of the following best
describes Desktop and Mobile Database Applications within App Builder?
The
user interface is optimized for larger displays, such as desktop, laptop and
tablet screens. (*)
Enable
users to build data centric applications without any SQL programming knowledge.
Include
a set of business productivity and sample applications which can be installed
with just a few clicks.
None of
the above.
Which
of the following best describes an Application URL within App Builder?
The URL
that displays in your browser which indicates the location of your Oracle
Application Express application. (*)
Performs
any computations, validations, processes, and branching.
Is the
basic building block of an application.
Supports
multiple user interfaces within a single application.
Is a
logical construct that establishes persistence across page views.
Which of the following best
describes the Session State within App Builder?
The URL
that displays in your browser which indicates the location of your Oracle
Application Express application.
Performs
any computations, validations, processes, and branching.
Is the
basic building block of an application.
Is a
logical construct that establishes persistence across page views. (*)
Supports
multiple user interfaces within a single application.
Which of the following best
describes an Application Page within App Builder?
The URL
that displays in your browser which indicates the location of your Oracle
Application Express application.
Supports
multiple user interfaces within a single application.
Is the
basic building block of an application. (*)
Performs
any computations, validations, processes, and branching.
Is a
logical construct that establishes persistence across page views.
The Create Application Wizard
enables developers to design create whch of the following Oracle Application
Express application types?
Desktop
and Mobile Database Applications (*)
Packaged
Applications (*)
User
Applications
Websheet
Applications (*)
All of
the above
Which of the following best
describes an Accept Page within App Builder?
Is a
logical construct that establishes persistence across page views.
Is the
basic building block of an application.
Performs
any computations, validations, processes, and branching.
Supports
multiple user interfaces within a single application.
The URL
that displays in your browser which indicates the location of your Oracle
Application Express application.
None of
the above. (*)
Which
of the following best describes the Application User Interface within App
Builder?
Is a
logical construct that establishes persistence across page views.
The URL
that displays in your browser which indicates the location of your Oracle
Application Express application.
Is the
basic building block of an application.
Supports
multiple user interfaces within a single application. (*)
Performs
any computations, validations, processes, and branching.
Which of the following best
describes a Database Application within App Builder?
Is the
basic building block of an application
Is a
collection of pages linked together using navigation menus, tabs, buttons, or
hypertext links (*)
Are
interactive web pages that combine text with data
Supports
multiple user interfaces within a single application
You use the App Builder home page
to
Access
workspace.
Create
new applications.
Import
applications.
Select
an application to edit.
View
the Dashboard.
All of
the above. (*)
You can create a database
application in which of the following ways within App Builder?
From a
design document.
From
scratch. (*)
Copy an
existing application. (*)
From a
spreadsheet. (*)
Which of the following best
describes Websheet Applications within App Builder?
The
user interface is optimized for larger displays, such as desktop, laptop and
tablet screens.
Enable
users to build data centric applications without any SQL programming knowledge.
(*)
Include
a set of business productivity and sample applications which can be installed
with just a few clicks.
None of
the above.
Which of the following best describes SQL Commands within
SQL Workshop?
Enables
developers to browse, create, and edit objects in a database.
Enables
developers to use SQL Scripts to create, edit, view, run, and delete database
objects.
Enables
developers to build SQL queries, load and unload data from an Oracle database,
generate DDL.
Enables
developers to use SQL Commands to create, edit, view, run, and delete database
objects. (*)
Enables
the declarative specification of RESTful services used to access the database.
Which of the following best
describes Object Browser within SQL Workshop?
Enables
developers to use SQL Commands to create, edit, view, run, and delete database
objects.
Enables
developers to browse, create, and edit objects in a database. (*)
Enables
developers to build SQL queries, load and unload data from an Oracle database,
generate DDL.
Enables
the declarative specification of RESTful services used to access the database.
Enables
developers to use SQL Scripts to create, edit, view, run, and delete database
objects.
Which of the following are tools
that enable you to view and manage database objects in the SQL Workshop?
Object
Browser.
SQL
Commands.
SQL
Scripts.
Utilities.
Restful
Services.
All of
the above. (*)
Which of the following are Page
Mode options in App Builder?
Custom
Dialog.
Non-Modal
Dialog. (*)
Modal
Dialog. (*)
User
Defined Dialog.
None of
the above.
Each page in an Oracle
Application Express application can contain only one region?
True
False (*)
The Property Editor within Page Designer organizes
attributes into functional groups?
True
(*)
False
Which of the following best
describes a Non-Modal Dialog Page Mode within App Builder?
An
overlay window positioned within the same browser window.
A
separate popup browser window. (*)
None of
the above.
Which of the following best
describes a Modal Dialog Page Mode within App Builder?
An
overlay window positioned within the same browser window. (*)
A
separate popup browser window.
None of
the above.
The Page Mode determines if the
page is a normal application page or a dialog
True
(*)
False
By default, an Interactive Grid
controls can be used to alter the layout of report data by which of the
following methods?
Applying
filters
Highlighting
Selecting
columns
Sorting
(*)
All of
the above
Interactive
grid attributes allow developers to perform which of the following?
Determine
if end users can edit the underlying data
Configure
report pagination
Create
error messages
Configure
the toolbar and download options
Control
if and how users can save an interactive grid
All of
the above (*)
A classic report is the formatted
result of a SQL query?
True
(*)
False
When creating a database
application, you can create which of the following report types?
Classic
Report. (*)
Interactive
Grid. (*)
Interactive
Report. (*)
Report
on a form on a table. (*)
User
Defined Report.
All of
the above.
An interactive report is a
formatted result of a SQL query?
True
(*)
False
The Query Builder button provides
you with assistance in writing an SQL query?
True
(*)
False
Match the report capabilities to the statement “End user
customization of how and what data displays”.
Interactive
Report - No, Interactive Grid - Yes, Classic Report - No
Interactive
Report - Yes, Interactive Grid - Yes, Classic Report - No (*)
Interactive
Report - Yes, Interactive Grid - Yes, Classic Report - Yes
Interactive
Report - Yes, Interactive Grid - No, Classic Report - Yes
Interactive
Report - Yes, Interactive Grid - No, Classic Report - No
When you create an application
all report types are available to create?
True
False
(*)
When you create an application,
the user interface you select determines the available report types?
True
(*)
False
End users cannot customize a
classic report?
True
(*)
False
Match the report capabilities to
the statement “End user can add, modify, and refresh the data directly on the
report”.
Interactive
Report - No, Interactive Grid - Yes, Classic Report - No (*)
Interactive
Report - No, Interactive Grid - Yes, Classic Report - Yes
Interactive
Report - Yes, Interactive Grid - No, Classic Report - Yes
Interactive
Report - Yes, Interactive Grid - Yes, Classic Report - No
Interactive
Report - Yes, Interactive Grid - No, Classic Report - No
Which of the following best describes the Column heading
menu within an Interactive Report?
Provides
features such as customize an interactive report.
Provides
features such as create and save alternative views of a report.
Provides
features such as change the sort order, hide columns etc. (*)
Provides
features such as link to another page in your application.
Provides
features such as the Select Columns icon.
Only developers can save a
private or public interactive report?
True
False
(*)
Only developers can save Primary
Default or Alternative Report?
True
(*)
False
When using an interactive report,
Application Express allows you to create multiple filters?
True
(*)
False
When using an interactive report,
end users cannot customize their report to include specific columns?
True
False
(*)
When using an interactive report, end users can specify
column display sort order?
True
(*)
False
When using an interactive report,
end users can change the way a developer defines how an interactive report is
to be rendered to end users?
True
False
(*)
When using an interactive report,
developers can change the way an interactive report is rendered to end users?
True
(*)
False
Which of the following are
components of an interactive report?
Actions
menu.
Column
heading menu.
Link to
custom target.
Saved
reports.
Search
bar.
All of
the above. (*)
When using an interactive report,
end users can create both row and column filters?
True
(*)
False
No comments:
Post a Comment