Answer Sections 1 and 2 Quiz Application Development Foundations 2019 Learner - English

Section 1

1.  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.



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

True (*)


False

3.  The User role of Workspace administrators can perform which of the following in Application Express?
(Choose all correct answers)


Create and Edit Applications. (*)


Sign into Workspace. (*)


Run existing Applications. (*)


Perform Administration Tasks. (*)


Manage entire hosted instance.


All of the above.

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

(Choose all correct answers)


Create and Edit Applications. (*)


Sign into Workspace. (*)


Run existing Applications. (*)


Perform Administration Tasks.


Manage entire hosted instance.


All of the above.

5.  The Oracle Application Express development environment consists of which of the following components?
(Choose all correct answers)


Database Administrator


SQL Workshop. (*)


Team Development (*)


Packaged Apps. (*)


App Builder. (*)

6.  Packaged apps are a suite of business productivity applications?

True (*)


False


Section 2

7.  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. (*)


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

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.


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


Performs any computations, validations, processes, and branching.


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

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.


Performs any computations, validations, processes, and branching.


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


10.  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.


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

Is a logical construct that establishes persistence across page views.


Performs any computations, validations, processes, and branching. (*)


Is the basic building block of an application.


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.


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

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


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


Creates a copy of an existing database application. (*)


None of the above.


13.  Which of the following best describes Utilities within SQL Workshop?

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.


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


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


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


14.  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. (*)


15.  Which of the following best describes SQL Commands 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 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.


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