Answer Key Application Development Foundations iLearning Oracle Section 1 and 2
Sabtu, Januari 12, 2019
Edit
1. In Application Express, an Application is best described as which of the following? Mark for Review
(1) Points
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.
Incorrect Incorrect. Refer to Section 1 Lesson 2.
2. In Application Express, an application is an HTML interface that exists on top of database objects such as tables or procedures? Mark for Review
(1) Points
True (*)
False
Correct Correct
3. Packaged apps are easily installed with only a few clicks? Mark for Review
(1) Points
True (*)
False
Correct Correct
4. The Mid Tier of the Oracle Application Express Architecture is which of the following services? Mark for Review
(1) Points
Embedded PL/SQL Gateway
Oracle HTTP Server
Oracle REST Data Services (*)
Web Browser
None of the above
Incorrect Incorrect. Refer to Section 1 Lesson 2.
5. Packaged Applications include a collection of sample applications which demonstrate some of the major features of Oracle Application Express? Mark for Review
(1) Points
True (*)
False
Correct Correct
The User role of Workspace administrators can perform which of the following in Application Express? Mark for Review
(1) Points
(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.
Incorrect Incorrect. Refer to Section 1 Lesson 2.
Section 2
(Answer all questions in this section)
7. Which of the following types of applications can be created using App Builder? Mark for Review
(1) Points
(Choose all correct answers)
User Applications.
Websheet applications. (*)
Database applications. (*)
Website Applications.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
8. Which of the following best describes an Application URL within App Builder? Mark for Review
(1) Points
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. (*)
Supports multiple user interfaces within a single application.
Performs any computations, validations, processes, and branching.
Is the basic building block of an application.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
9. Which of the following best describes Packaged Applications within App Builder? Mark for Review
(1) Points
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.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
10. The Create Application Wizard enables developers to design create whch of the following Oracle Application Express application types? Mark for Review
(1) Points
(Choose all correct answers)
Desktop and Mobile Database Applications (*)
Packaged Applications (*)
User Applications
Websheet Applications (*)
All of the above
Incorrect Incorrect. Refer to Section 2 Lesson 2.
11. You can create a database application in which of the following ways within App Builder? Mark for Review
(1) Points
(Choose all correct answers)
Copy an existing application. (*)
From scratch. (*)
From a spreadsheet. (*)
From a design document.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
12. Which of the following best describes the Accept Page within App Builder? Mark for Review
(1) Points
Performs any computations, validations, processes, and branching. (*)
Is a logical construct that establishes persistence across page views.
Is the basic building block of an application.
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.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
13. Which of the following best describes SQL Commands within SQL Workshop? Mark for Review
(1) Points
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 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.
Incorrect Incorrect. Refer to Section 2 Lesson 1.
14. Which of the following best describes Utilities within SQL Workshop? Mark for Review
(1) Points
Enables developers to use SQL Scripts 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 Commands to create, edit, view, run, and delete database objects.
Enables developers to browse, create, and edit objects in a database.
Incorrect Incorrect. Refer to Section 2 Lesson 1.
15. Which of the following are tools that enable you to view and manage database objects in the SQL Workshop? Mark for Review
(1) Points
Object Browser.
SQL Commands.
SQL Scripts.
Utilities.
Restful Services.
All of the above. (*)
====================================================================================================
Which of the following best describes the Messages tab within Page Designer in App Developer? Mark for Review
(1) Points
Displays a visual representation of the page regions, items, and buttons that define a page.
Displays user interface elements and application logic by component type.
Displays errors and warnings you need to address. (*)
Displays attribute specific help.
None of the above.
Incorrect Incorrect. Refer to Section 3 Lesson 1.
2. Which of the following are Page Mode options in App Builder? Mark for Review
(1) Points
(Choose all correct answers)
Custom Dialog.
Non-Modal Dialog. (*)
Modal Dialog. (*)
User Defined Dialog.
None of the above.
Incorrect Incorrect. Refer to Section 3 Lesson 1.
3. Which of the following best describes the Layout tab within Page Designer in App Developer? Mark for Review
(1) Points
Displays a visual representation of the page regions, items, and buttons that define a page. (*)
Displays user interface elements and application logic by component type.
Displays errors and warnings you need to address.
Displays attribute specific help.
None of the above.
Correct Correct
4. Hidden items are displayed in the Layout tab within Page Designer in App Developer? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 1.
5. Interactive grid attributes allow developers to perform which of the following? Mark for Review
(1) Points
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 (*)
Incorrect Incorrect. Refer to Section 3 Lesson 4.
By default, an Interactive Grid includes which of the following components? (Choose all correct answers) Mark for Review
(1) Points
(Choose all correct answers)
Actions menu (*)
Sort bar
Search bar (*)
Column Heading menu (*)
Incorrect Incorrect. Refer to Section 3 Lesson 4.
7. In an editable interactive grid, users ability to rearrange the report interactively using the mouse? Mark for Review
(1) Points
True (*)
False
Correct Correct
8. When viewing an interactive report, end users can customize how and what data displays? Mark for Review
(1) Points
True (*)
False
Correct Correct
9. The Query Builder button provides you with assistance in writing an SQL query? Mark for Review
(1) Points
True (*)
False
Correct Correct
10. Application Express allows you to create reports in which of the following ways? Mark for Review
(1) Points
(Choose all correct answers)
Create a report when you create the application. (*)
Create a report as a new page. (*)
Create a report region on a page. (*)
Create a report on the fly as the application runs.
All of the above.
Incorrect Incorrect. Refer to Section 3 Lesson 2.
11. When using an interactive report, end users can create both row and column filters? Mark for Review
(1) Points
True (*)
False
Correct Correct
12. When using an interactive report, Application Express allows you to create multiple filters? Mark for Review
(1) Points
True (*)
False
Correct Correct
13. Application Express only allows you to perform a non-case-sensitive search on the entire interactive report? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
14. Which of the following best describes the Actions menu within an Interactive Report? Mark for Review
(1) Points
Provides features such as the Select Columns icon.
Provides features such as customize an interactive report. (*)
Provides features such as link to another page in your application.
Provides features such as create and save alternative views of a report.
Provides features such as change the sort order, hide columns etc.
Incorrect Incorrect. Refer to Section 3 Lesson 3.
15. Only developers can save a private or public interactive report? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
=====================================================================================================
The User role of Workspace administrators can perform which of the following in Application Express? Mark for Review
(1) Points
(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.
Incorrect. Refer to Section 1 Lesson 2.
2. Which of the following best describes the SQL Workshop 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.
Incorrect. Refer to Section 1 Lesson 2.
3. 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.
Incorrect. Refer to Section 1 Lesson 2.
4. 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.
Correct
5. Packaged apps are easily installed with only a few clicks?
True (*)
False
Correct
Correct
6. In Application Express, an application is an HTML interface that exists on top of database objects such as tables or procedures? Mark for Review
(1) Points
True (*)
False
Correct
7 . Which of the following best describes the Session State within App Builder?
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.
Is the basic building block of an application.
Performs any computations, validations, processes, and branching
You can create a database application in which of the following ways within App Builder? Mark for Review
(1) Points
(Choose all correct answers)
From a design document.
Copy an existing application. (*)
From scratch. (*)
From a spreadsheet. (*)
9. Which of the following best describes Packaged Applications within App Builder? Mark for Review
(1) Points
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.
Incorrect. Refer to Section 2 Lesson 2.
10. Which of the following types of applications can be created using App Builder? Mark for Review
(1) Points
(Choose all correct answers)
Database applications. (*)
Websheet applications. (*)
User Applications.
Website Applications.
11. Which of the following best describes an Application Page within App Builder? Mark for Review
(1) Points
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.
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.
Correct
12. Which of the following best describes a Database Application within App Builder? Mark for Review
(1) Points
Is a collection of pages linked together using navigation menus, tabs, buttons, or hypertext links (*)
Is the basic building block of an application
Supports multiple user interfaces within a single application
Are interactive web pages that combine text with data
Oracle Application Express includes the SQL Workshop for application developers to maintain database objects? Mark for Review
(1) Points
True (*)
False
Correct
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. (*)
Incorrect. Refer to Section 2 Lesson 1.
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 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 browse, create, and edit objects in a database.
Enables developers to build SQL queries, load and unload data from an Oracle database, generate DDL.
======================================================================================
1. Which of the following best describes Team Development within Application Express? Mark for Review
(1) Points
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.
Incorrect Incorrect. Refer to Section 1 Lesson 2.
2. The User role of End user can perform which of the following in Application Express? Mark for Review
(1) Points
Create and Edit Applications.
Sign into Workspace.
Run existing Applications. (*)
Perform Administration Tasks.
Manage entire hosted instance.
All of the above.
Incorrect Incorrect. Refer to Section 1 Lesson 2.
3. The User role of Workspace administrators can perform which of the following in Application Express? Mark for Review
(1) Points
(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.
Correct Correct
4. Oracle Application Express employs a 3 Tier Architecture? Mark for Review
(1) Points
True (*)
False
Correct Correct
5. The Oracle Application Express development environment consists of which of the following components? Mark for Review
(1) Points
(Choose all correct answers)
Database Administrator
Team Development (*)
App Builder. (*)
Packaged Apps. (*)
SQL Workshop. (*)
Incorrect Incorrect. Refer to Section 1 Lesson 2.
The User role of Developer can perform which of the following in Application Express? Mark for Review
(1) Points
(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.
Correct Correct
Section 2
(Answer all questions in this section)
7. Which of the following best describes the From scratch option within App Builder? Mark for Review
(1) Points
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.
Correct Correct
8. Which of the following best describes Desktop and Mobile Database Applications within App Builder? Mark for Review
(1) Points
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.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
9. Which of the following best describes the Application User Interface within App Builder? Mark for Review
(1) Points
Performs any computations, validations, processes, and branching.
Supports multiple user interfaces within a single application. (*)
Is the basic building block of an application.
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.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
10. Which of the following best describes Websheet Applications within App Builder? Mark for Review
(1) Points
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 an Accept Page within App Builder? Mark for Review
(1) Points
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. (*)
Incorrect Incorrect. Refer to Section 2 Lesson 2.
12. Which of the following best describes the Session State within App Builder? Mark for Review
(1) Points
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.
Is a logical construct that establishes persistence across page views. (*)
Performs any computations, validations, processes, and branching.
Supports multiple user interfaces within a single application.
Correct Correct
13. Oracle Application Express includes the SQL Workshop for application developers to maintain database objects? Mark for Review
(1) Points
True (*)
False
Correct Correct
14. Which of the following best describes Object Browser within SQL Workshop? Mark for Review
(1) Points
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 the declarative specification of RESTful services used to access the database.
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. (*)
Incorrect Incorrect. Refer to Section 2 Lesson 1.
15. Which of the following are tools that enable you to view and manage database objects in the SQL Workshop? Mark for Review
(1) Points
Object Browser.
SQL Commands.
SQL Scripts.
Utilities.
Restful Services.
All of the above. (*)
=========================================================================================
1. The Mid Tier of the Oracle Application Express Architecture is which of the following services? Mark for Review
(1) Points
Embedded PL/SQL Gateway
Oracle HTTP Server
Oracle REST Data Services (*)
Web Browser
None of the above
Incorrect Incorrect. Refer to Section 1 Lesson 2.
2. Packaged apps are a suite of business productivity applications? Mark for Review
(1) Points
True (*)
False
Correct Correct
3. In Application Express, an Application is best described as which of the following? Mark for Review
(1) Points
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.
Correct Correct
4. Which of the following best describes the App Builder within Application Express? Mark for Review
(1) Points
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.
Incorrect Incorrect. Refer to Section 1 Lesson 2.
5. Oracle Application Express Architecture Tiers can be identified as which of the following? Mark for Review
(1) Points
(Choose all correct answers)
Database Tier. (*)
Last Tier.
Mid Tier. (*)
First Tier.
Browser. (*)
Incorrect Incorrect. Refer to Section 1 Lesson 2.
6. In Application Express, an application is an HTML interface that exists on top of database objects such as tables or procedures? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 1 Lesson 2.
Section 2
(Answer all questions in this section)
7. 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? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 2 Lesson 2.
8. Which of the following best describes a Websheet Application within App Builder? Mark for Review
(1) Points
Are interactive web pages that combine text with data (*)
Is the basic building block of an application
Supports multiple user interfaces within a single application
Is a collection of pages linked together using navigation menus, tabs, buttons, or hypertext links
Correct Correct
9. Which of the following best describes the Copy an existing application option within App Builder? Mark for Review
(1) Points
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.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
10. You use the App Builder home page to Mark for Review
(1) Points
Access workspace.
Create new applications.
Import applications.
Select an application to edit.
View the Dashboard.
All of the above. (*)
11. Which of the following best describes Desktop and Mobile Database Applications within App Builder? Mark for Review
(1) Points
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.
Correct Correct
12. Which of the following best describes the Session State within App Builder? Mark for Review
(1) Points
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.
Performs any computations, validations, processes, and branching.
Supports multiple user interfaces within a single application.
Is the basic building block of an application.
Correct Correct
13. Which of the following are tools that enable you to view and manage database objects in the SQL Workshop? Mark for Review
(1) Points
Object Browser.
SQL Commands.
SQL Scripts.
Utilities.
Restful Services.
All of the above. (*)
Correct Correct
14. Which of the following best describes Utilities within SQL Workshop? Mark for Review
(1) Points
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.
Enables developers to browse, create, and edit objects in a database.
Correct Correct
15. Which of the following best describes Object Browser within SQL Workshop? Mark for Review
(1) Points
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
==========================================================================================1. The User role of End user can perform which of the following in Application Express? Mark for Review
(1) Points
Create and Edit Applications.
Sign into Workspace.
Run existing Applications. (*)
Perform Administration Tasks.
Manage entire hosted instance.
All of the above.
Incorrect Incorrect. Refer to Section 1 Lesson 2.
In Application Express User roles are best described as which of the following? Mark for Review
(1) Points
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.
Which of the following best describes the From a spreadsheet option within App Builder? Mark for Review
(1) Points
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.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
12. Which of the following best describes the Application User Interface within App Builder? Mark for Review
(1) Points
Supports multiple user interfaces within a single application. (*)
Is a logical construct that establishes persistence across page views.
Performs any computations, validations, processes, and branching.
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.
Incorrect Incorrect. Refer to Section 2 Lesson 2.
15. Which of the following best describes Object Browser within SQL Workshop? Mark for Review
(1) Points
Enables developers to build SQL queries, load and unload data from an Oracle database, generate DDL.
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 use SQL Commands to create, edit, view, run, and delete database objects.
Incorrect Incorrect. Refer to Section 2 Lesson
. Which of the following best describes Packaged Apps within Application Express? Mark for Review
(1) Points
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.