Answer Key Application Development Foundations Section 4 iLearning Oracle
Sabtu, Januari 12, 2019
Edit
1. In Application Builder, a branch can be defined to go to which of the following? Mark for Review
(1) Points
A specific page
A procedure
A URL
All of the above (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
2. When you create a branch, you must specify a Branch Point and Branch Type? Mark for Review
(1) Points
True (*)
False
Correct Correct
3. The process to insert, update, or delete records into a single database table or updateable view in Application Builder is defined as which of the following? Mark for Review
(1) Points
Automatic Row Fetch.
PL/SQL Row Processing.
SQL Row Fetch.
Automatic Row Processing. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
4. Which of the following are types of Page process in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
SQL Row Fetch.
Automatic Row Fetch. (*)
PL/SQL Row Processing.
Automatic Row Processing. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
5. In Application Builder, a branch is an instruction to go to a specific page, procedure, or URL? Mark for Review
(1) Points
True (*)
False
Correct Correct
6. Application Builder provides which of the following form types? Mark for Review
(1) Points
Report with Form on Table.
Editable Interactive Grid.
Single Page Master Detail.
Two Page Master Detail.
Form on a Table.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
7. Forms can enable users to update multiple rows in a table? Mark for Review
(1) Points
True (*)
False
Correct Correct
8. Forms are application components that are used for data input from end users? Mark for Review
(1) Points
True (*)
False
Correct Correct
9. Forms can enable users to update a single row in a table? Mark for Review
(1) Points
True (*)
False
Correct Correct
10. Which of the following statements best describes an Form on a Table Application Builder form type? Mark for Review
(1) Points
Creates two pages. One page displays a report.
Creates a form that enables users to update a single row in a database table. (*)
presents users a set of data in a searchable, customizable report.
Builds a single page report and form combination based on tables you select.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
11. Which of the following statements best describes an Form on Web Service Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table.
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report.
None of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
12. A list of values (LOV) is a static or dynamic set of values used to display a specific type of page item? Mark for Review
(1) Points
True (*)
False
Correct Correct
13. In Application Builder, You can reference item values stored in session state in regions, computations, processes, validation, and branches? Mark for Review
(1) Points
True (*)
False
Correct Correct
14. Which of the following are types of Items in Application Builder? Mark for Review
(1) Points
Application items
Authentication Scheme
Page items
Shared Components
All of the above (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
15. In Application builder, a list based on a SQL query you write that selects values from a table is known as? Mark for Review
(1) Points
A User Defined List.
A Dynamic list. (*)
A Static list.
A Scratch List.
Incorrect Incorrect. Refer to Section 4 Lesson 2.
==========================================================================================
1. Which of the following are an item in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
Select list (*)
SQL Query
Password (*)
Text area (*)
Text field
Check box (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
2. Which of the following actions can be carried out in Application Builder using a button page item? Mark for Review
(1) Points
Do nothing. (*)
Redirect.
Submit a page.
All of the above.
Correct Correct
3. In Application Builder, you can use buttons to direct users to a specific page or URL, or to post or process information? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 2.
4. In Application builder, a list based on a SQL query you write that selects values from a table is known as? Mark for Review
(1) Points
A Dynamic list. (*)
A Static list.
A Scratch List.
A User Defined List.
Correct Correct
5. Which of the following statements best describes an Form on Web Service Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table.
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report.
None of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
6. Which of the following statements best describes an Single Page Master Detail Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table.
Creates two pages. One page displays a report.
Builds a single page report and form combination based on tables you select. (*)
presents users a set of data in a searchable, customizable report.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
7. Forms can be created in Application Builder using which of the following methods? Mark for Review
(1) Points
(Choose all correct answers)
Manually. (*)
Uploaded from an external application.
Using a Wizard. (*)
All of the above.
None of the above.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
8. Application Builder provides which of the following form types? Mark for Review
(1) Points
Form on a Procedure.
Editable Interactive Grid.
Form on Web Service.
Two Page Master Detail.
Form on a Table.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
9. Forms are made up of types? Mark for Review
(1) Points
True
False (*)
Correct Correct
10. A master detail form reflects a one-to-many relationship between two tables? Mark for Review
(1) Points
True (*)
False
Correct Correct
11. When you request a page using a URL, the Application Express engine is running which of the following? Mark for Review
(1) Points
Submit Page.
Accept Page.
Show Page. (*)
Find Page.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
12. The process to retrieve records from a single database table or view in Application Builder is defined as which of the following? Mark for Review
(1) Points
SQL Row Fetch.
Automatic Row Processing.
PL/SQL Row Processing.
Automatic Row Fetch. (*)
Correct Correct
13. When you submit a page, the Application Express engine is running which of the following? Mark for Review
(1) Points
Show Page.
Find Page.
Accept Page. (*)
Submit Page.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
14. A page process is a series of event that run when a page is loaded or submitted? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
15. If you wanted to assign a value to an identified item when a page is displayed or submitted you would use? Mark for Review
(1) Points
A Trigger.
A Page-rendering computation.
Page-processing computation. (*)
A PL/SQL statement.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
==========================================================================================
1. Which of the following are an item in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
SQL Query
Select list (*)
Text field
Password (*)
Text area (*)
Check box (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
2. In Application Builder, an item is part of an HTML form? Mark for Review
(1) Points
True (*)
False
Correct Correct
3. Which of the following are types of Items in Application Builder? Mark for Review
(1) Points
Application items
Authentication Scheme
Page items
Shared Components
All of the above (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
4. In Application builder, a list based on predefined pairs of display values and return values is known as? Mark for Review
(1) Points
A Scratch List.
A Dynamic list.
A Static list. (*)
A User Defined List.
Incorrect Incorrect. Refer to Section 4 Lesson 2.
5. In Application Builder, a branch is an instruction to go to a specific page, procedure, or URL? Mark for Review
(1) Points
True (*)
False
Correct Correct
6. Validations that apply to an entire page in Application Builder are defined as which of the following? Mark for Review
(1) Points
Page Item Validation.
Page Validation. (*)
Page Control Validation.
Application Control Validation.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
7. When you request a page using a URL, the Application Express engine is running which of the following? Mark for Review
(1) Points
Show Page. (*)
Accept Page.
Find Page.
Submit Page.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
8. Which of the following are types of computations in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
Field Computation.
Page Computation. (*)
Item Computation.
Application Computation. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
9. If you wanted to assign a value to an identified item when a page is displayed or submitted you would use? Mark for Review
(1) Points
A Trigger.
A Page-rendering computation.
Page-processing computation. (*)
A PL/SQL statement.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
10. A master detail form reflects a one-to-many relationship between two tables? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 1.
11. Which of the following statements best describes an Two Page Master Detail Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table.
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report. (*)
Builds a single page report and form combination based on tables you select.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
12. Once a form is created, you cannot re-arrange form fields? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
13. Application Builder provides which of the following form types? Mark for Review
(1) Points
Form on a Procedure.
Editable Interactive Grid.
Form on Web Service.
Two Page Master Detail.
Form on a Table.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
14. Forms can enable users to update a single row in a table? Mark for Review
(1) Points
True (*)
False
Correct Correct
15. Which of the following statements best describes an Form on Web Service Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table.
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report.
None of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
==========================================================================================
1. Application Builder provides which of the following form types? Mark for Review
(1) Points
Report with Form on Table.
Editable Interactive Grid.
Single Page Master Detail.
Two Page Master Detail.
Form on a Table.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
2. Forms are application components that are used for data input from end users? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 1.
3. Application Builder provides which of the following form types? Mark for Review
(1) Points
Form on a Procedure.
Form on a SQL Query.
Form on Web Service.
Report and Form on Web Service.
Form on a Table.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
4. Forms can enable users to update a single row in a table? Mark for Review
(1) Points
True (*)
False
Correct Correct
5. Which of the following statements best describes an Form on Web Service Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table.
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report.
None of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
6. Which of the following statements best describes a Report with Form on Table Application Builder form type? Mark for Review
(1) Points
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report. (*)
Creates a form that enables users to update a single row in a database table.
Builds a single page report and form combination based on tables you select.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
7. Validations specific to a single item in Application Builder are defined as which of the following? Mark for Review
(1) Points
Page Control Validation.
Application Control Validation.
Page Item Validation. (*)
Page Validation.
Correct Correct
8. The process to insert, update, or delete records into a single database table or updateable view in Application Builder is defined as which of the following? Mark for Review
(1) Points
Automatic Row Fetch.
PL/SQL Row Processing.
SQL Row Fetch.
Automatic Row Processing. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
9. Which of the following types of Validations can be built in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
Row Validation. (*)
Schema Validation.
SQL Validation. (*)
Table Validation.
PL/SQL Validation. (*)
Regular Expression Validation. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
10. A page process is a specific event that runs when a page is loaded or submitted? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 3.
11. If you want to retrieve and display a value from the database when a report is displayed you would use? Mark for Review
(1) Points
A Trigger.
A Page-rendering computation. (*)
Page-processing computation.
A PL/SQL statement.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
12. In Application Builder, you can use buttons to direct users to a specific page or URL, or to post or process information? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 2.
13. Which of the following are types of Items in Application Builder? Mark for Review
(1) Points
Application items
Authentication Scheme
Page items
Shared Components
All of the above (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
14. Which of the following actions can be carried out in Application Builder using a button page item? Mark for Review
(1) Points
Do nothing. (*)
Redirect.
Submit a page.
All of the above.
Correct Correct
15. In Application builder, a list based on predefined pairs of display values and return values is known as? Mark for Review
(1) Points
A User Defined List.
A Dynamic list.
A Static list. (*)
A Scratch List.
Correct Correct
==========================================================================================
1. A page process is a specific event that runs when a page is loaded or submitted? Mark for Review
(1) Points
True (*)
False
Correct Correct
2. Validations that apply to an entire page in Application Builder are defined as which of the following? Mark for Review
(1) Points
Page Validation. (*)
Page Control Validation.
Application Control Validation.
Page Item Validation.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
3. Which of the following are types of computations in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
Field Computation.
Page Computation. (*)
Application Computation. (*)
Item Computation.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
4. Match the descriptions to the two processes Application Express engine relies on when you run an application. Mark for Review
(1) Points
(Choose all correct answers)
Show Page : performs page processing.
Accept Page : is the page rendering process.
Show Page : is the page rendering process. (*)
Accept Page : performs page processing. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
5. In Application Builder, a branch is an instruction to go to a specific page, procedure, or URL? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 3.
6. Which of the following statements best describes an Form on a Table Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table. (*)
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
7. A master detail form reflects a one-to-many relationship between two tables? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 1.
8. Which of the following statements best describes an Form on Web Service Application Builder form type? Mark for Review
(1) Points
Creates a form that enables users to update a single row in a database table.
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report.
Creates two pages. One page displays a report.
None of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
9. Forms are application components that are used for data input from end users? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 1.
10. Application Builder provides which of the following form types? Mark for Review
(1) Points
Form on a Procedure.
Editable Interactive Grid.
Form on Web Service.
Two Page Master Detail.
Form on a Table.
All of the above. (*)
11. Which of the following statements best describes a Report with Form on Table Application Builder form type? Mark for Review
(1) Points
Creates two pages. One page displays a report. (*)
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report.
Creates a form that enables users to update a single row in a database table.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
12. Which of the following are database application page controls in Application Builder? Mark for Review
(1) Points
Buttons.
Dynamic Actions.
Page-level items.
Trees.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
13. A list of values (LOV) is a static or dynamic set of values used to display a specific type of page item? Mark for Review
(1) Points
True (*)
False
Correct Correct
14. In Application builder, a list based on a SQL query you write that selects values from a table is known as? Mark for Review
(1) Points
A Scratch List.
A Static list.
A User Defined List.
A Dynamic list. (*)
Correct Correct
15. Which of the following are types of Items in Application Builder? Mark for Review
(1) Points
Application items
Authentication Scheme
Page items
Shared Components
All of the above (*)
==========================================================================================
1. The process to retrieve records from a single database table or view in Application Builder is defined as which of the following? Mark for Review
(1) Points
Automatic Row Fetch. (*)
PL/SQL Row Processing.
Automatic Row Processing.
SQL Row Fetch.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
2. When you request a page using a URL, the Application Express engine is running which of the following? Mark for Review
(1) Points
Find Page.
Show Page. (*)
Accept Page.
Submit Page.
Incorrect Incorrect. Refer to Section 4 Lesson 3.
3. Validations specific to a single item in Application Builder are defined as which of the following? Mark for Review
(1) Points
Page Item Validation. (*)
Page Validation.
Application Control Validation.
Page Control Validation.
Correct Correct
4. A page process is a specific event that runs when a page is loaded or submitted? Mark for Review
(1) Points
True (*)
False
Correct Correct
5. Which of the following are types of Validations in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
Page Validation. (*)
Application Control Validation.
Page Control Validation.
Page Item Validation. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
6. Which of the following actions can be carried out in Application Builder using a button page item? Mark for Review
(1) Points
Do nothing. (*)
Redirect.
Submit a page.
All of the above.
Correct Correct
7. Which of the following are an item in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
SQL Query
Check box (*)
Select list (*)
Password (*)
Text field
Text area (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
8. Which of the following are types of Items in Application Builder? Mark for Review
(1) Points
Application items
Authentication Scheme
Page items
Shared Components
All of the above (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
9. In Application Builder, you cannot use buttons to perform a Dynamic Action? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
10. Forms are application components that are used for data input from end users? Mark for Review
(1) Points
True (*)
False
11. Which of the following statements best describes an Single Page Master Detail Application Builder form type? Mark for Review
(1) Points
Creates two pages. One page displays a report.
Builds a single page report and form combination based on tables you select. (*)
presents users a set of data in a searchable, customizable report.
Creates a form that enables users to update a single row in a database table.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
12. Forms can be created in Application Builder using which of the following methods? Mark for Review
(1) Points
(Choose all correct answers)
Manually. (*)
Uploaded from an external application.
Using a Wizard. (*)
All of the above.
None of the above.
Incorrect Incorrect. Refer to Section 4 Lesson 1.
13. Forms are made up of types? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
14. Application Builder provides which of the following form types? Mark for Review
(1) Points
Form on a Procedure.
Editable Interactive Grid.
Form on Web Service.
Two Page Master Detail.
Form on a Table.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
15. Forms can enable users to update a single row in a table? Mark for Review
(1) Points
True (*)
False
Correct Correct
==========================================================================================
1. Which of the following actions can be carried out in Application Builder using a button page item? Mark for Review
(1) Points
Do nothing. (*)
Redirect.
Submit a page.
All of the above.
Correct Correct
2. Which of the following are types of Items in Application Builder? Mark for Review
(1) Points
Application items
Authentication Scheme
Page items
Shared Components
All of the above (*)
Incorrect Incorrect. Refer to Section 4 Lesson 2.
3. Which of the following are an item in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
SQL Query
Check box (*)
Password (*)
Select list (*)
Text area (*)
Text field
Incorrect Incorrect. Refer to Section 4 Lesson 2.
4. A list of values (LOV) is a static or dynamic set of values used to display a specific type of page item? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 2.
5. The process to retrieve records from a single database table or view in Application Builder is defined as which of the following? Mark for Review
(1) Points
Automatic Row Processing.
PL/SQL Row Processing.
SQL Row Fetch.
Automatic Row Fetch. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
6. In Application Builder, a branch is an instruction to go to a specific page, procedure, or URL? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 3.
7. In Application Builder, a branch can be defined to go to which of the following? Mark for Review
(1) Points
A specific page
A procedure
A URL
All of the above (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
8. A computation is a logic that assigns values to a single item? Mark for Review
(1) Points
True (*)
False
Correct Correct
9. Which of the following are types of Validations in Application Builder? Mark for Review
(1) Points
(Choose all correct answers)
Page Control Validation.
Page Item Validation. (*)
Application Control Validation.
Page Validation. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 3.
10. Forms can enable users to update a single row in a table? Mark for Review
(1) Points
True (*)
False
11. Which of the following statements best describes an Single Page Master Detail Application Builder form type? Mark for Review
(1) Points
presents users a set of data in a searchable, customizable report.
Builds a single page report and form combination based on tables you select. (*)
Creates a form that enables users to update a single row in a database table.
Creates two pages. One page displays a report.
Correct Correct
12. Forms can enable users to update multiple rows in a table? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 1.
13. A master detail form reflects a one-to-many relationship between two tables? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 4 Lesson 1.
14. Once a form is created, you cannot re-arrange form fields? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
15. Application Builder provides which of the following form types? Mark for Review
(1) Points
Report with Form on Table.
Editable Interactive Grid.
Single Page Master Detail.
Two Page Master Detail.
Form on a Table.
All of the above. (*)
Incorrect Incorrect. Refer to Section 4 Lesson 1.
========================================================================================== Which of the following statements best describes an Editable Interactive Grid Application Builder form type? Mark for Review
(1) Points
Builds a single page report and form combination based on tables you select.
presents users a set of data in a searchable, customizable report. (*)
Creates two pages. One page displays a report.
Creates a form that enables users to update a single row in a database table.