Answer Key Application Development Foundations Section 3 iLearning Oracle
Sabtu, Januari 12, 2019
Edit
Section 3
(Answer all questions in this section)
1. When using an interactive report, end users can specify column display sort order? Mark for Review
(1) Points
True (*)
False
Correct Correct
2. The Download option on the Actions menu enables users to download an interactive report in which of the following formats? Mark for Review
(1) Points
(Choose all correct answers)
HTML (*)
Microsoft Excel (*)
Microsoft Word Rich Text Format (*)
Comma-delimited file (*)
Adobe Portable Document Format (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
3. When using an interactive report, end users can decide the order in which the columns appear in the report? Mark for Review
(1) Points
True (*)
False
Correct Correct
4. Only developers can save Primary Default or Alternative Report? Mark for Review
(1) Points
True (*)
False
Correct Correct
5. Which of the following best describes the Actions menu within an Interactive Report? Mark for Review
(1) Points
Provides features such as change the sort order, hide columns etc.
Provides features such as create and save alternative views of a report.
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.
Incorrect Incorrect. Refer to Section 3 Lesson 3.
6. 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
7. 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.
8. The Page Mode determines if the page is a normal application page or a dialog Mark for Review
(1) Points
True (*)
False
Correct Correct
9. Which of the following best describes the Component View 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.
10. By default, an Interactive Grid includes which of the following components? (Choose all correct answers) Mark for Review
(1) Points
(Choose all correct answers)
Sort bar
Actions menu (*)
Column Heading menu (*)
Search bar (*)
Incorrect Incorrect. Refer to Section 3 Lesson 4
11. Developers can determine whether an interactive grid is editable or read-only? Mark for Review
(1) Points
True (*)
False
Correct Correct
12. A report is the formatted result of a SQL query Mark for Review
(1) Points
True (*)
False
Correct Correct
13. When you create an application, the user interface you select determines the available report types? Mark for Review
(1) Points
True (*)
False
Correct Correct
14. End users have the ability to apply sorting and simple filtering to a classic report? Mark for Review
(1) Points
True (*)
False
Correct Correct
15. When creating a database application, you can create which of the following report types? Mark for Review
(1) Points
(Choose all correct answers)
Classic Report. (*)
Interactive Grid. (*)
Interactive Report. (*)
Report on a form on a table. (*)
User Defined Report.
All of the above.
==========================================================================================
1. You cannot restrict the capabilities of interactive reports available to end users? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 2.
2. Match the report capabilities to the statement “End user customization of how and what data displays”. Mark for Review
(1) Points
Interactive Report - Yes, Interactive Grid - Yes, Classic Report - Yes
Interactive Report - Yes, Interactive Grid - No, Classic Report - Yes
Interactive Report - No, Interactive Grid - Yes, Classic Report - No
Interactive Report - Yes, Interactive Grid - No, Classic Report - No
Interactive Report - Yes, Interactive Grid - Yes, Classic Report - No (*)
Incorrect Incorrect. Refer to Section 3 Lesson 2.
3. In an editable interactive grid, users ability to rearrange the report interactively using the mouse? Mark for Review
(1) Points
True (*)
False
Correct Correct
4. When creating a database application, you can create which of the following report types? Mark for Review
(1) Points
(Choose all correct answers)
Classic Report. (*)
Interactive Grid. (*)
Interactive Report. (*)
Report on a form on a table. (*)
User Defined Report.
All of the above.
Incorrect Incorrect. Refer to Section 3 Lesson 2.
5. 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
6. Which of the following best describes a Modal Dialog Page Mode within App Builder? Mark for Review
(1) Points
An overlay window positioned within the same browser window. (*)
A separate popup browser window.
None of the above.
Correct Correct
7. The Code Editor within Page Designer is used to edit attributes requiring a large amount of code? Mark for Review
(1) Points
True (*)
False
Correct Correct
8. 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.
9. Developers can configure a Link Column to link to which of the following? Mark for Review
(1) Points
A custom target.
A single row view.
Excluded from the report.
All of the above. (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
10. 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.
11. Only developers can save Primary Default or Alternative Report? Mark for Review
(1) Points
True (*)
False
Correct Correct
12. Interactive reports enable end users to create highly customized reports? 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. 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.
15. Developers can determine whether an interactive grid is editable or read-only? Mark for Review
(1) Points
True (*)
False
==========================================================================================
1. 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.
2. The Download option on the Actions menu enables users to download an interactive report in which of the following formats? Mark for Review
(1) Points
(Choose all correct answers)
Comma-delimited file (*)
Microsoft Word Rich Text Format (*)
Adobe Portable Document Format (*)
Microsoft Excel (*)
HTML (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
3. When using an interactive report, end users can add a computation to a column? Mark for Review
(1) Points
True (*)
False
Correct Correct
4. Which of the following best describes the Column heading menu within an Interactive Report? Mark for Review
(1) Points
Provides features such as create and save alternative views of a report.
Provides features such as the Select Columns icon.
Provides features such as change the sort order, hide columns etc. (*)
Provides features such as customize an interactive report.
Provides features such as link to another page in your application.
Incorrect Incorrect. Refer to Section 3 Lesson 3.
5. Only developers can save Primary Default or Alternative Report? Mark for Review
(1) Points
True (*)
False
Correct Correct
6. In an editable interactive grid, users ability to rearrange the report interactively using the mouse? Mark for Review
(1) Points
True (*)
False
Correct Correct
7. An interactive grid presents users a set of data in a searchable, customizable report? Mark for Review
(1) Points
True (*)
False
Correct Correct
8. An interactive report is a formatted result of a SQL query? Mark for Review
(1) Points
True (*)
False
Correct Correct
9. In an editable interactive grid, users cannot also add to, modify, and refresh the data set directly on the page Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 2.
10. By default, an Interactive Grid controls can be used to alter the layout of report data by which of the following methods? Mark for Review
(1) Points
Applying filters
Highlighting
Selecting columns
Sorting (*)
All of the above
Incorrect Incorrect. Refer to Section 3 Lesson 4.
11. Developers can determine whether an interactive grid is editable or read-only? Mark for Review
(1) Points
True (*)
False
Correct Correct
12. Which of the following best describes the Component View 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
13. 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.
14. 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.
Incorrect Incorrect. Refer to Section 3 Lesson 1.
15. 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.
==========================================================================================
1. By default, an Interactive Grid includes which of the following components? (Choose all correct answers) Mark for Review
(1) Points
(Choose all correct answers)
Sort bar
Column Heading menu (*)
Search bar (*)
Actions menu (*)
Incorrect Incorrect. Refer to Section 3 Lesson 4.
2. 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.
3. Interactive reports enable end users to create highly customized reports? Mark for Review
(1) Points
True (*)
False
Correct Correct
4. Which of the following best describes the Column heading 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 change the sort order, hide columns etc. (*)
Provides features such as create and save alternative views of a report.
Incorrect Incorrect. Refer to Section 3 Lesson 3.
5. 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.
6. Developers can configure a Link Column to link to which of the following? Mark for Review
(1) Points
A custom target.
A single row view.
Excluded from the report.
All of the above. (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
7. 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.
8. 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
9. 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.
10. The Code Editor within Page Designer is used to edit attributes requiring a large amount of code? Mark for Review
(1) Points
True (*)
False
Correct Correct
11. Which of the following best describes a Non-Modal Dialog Page Mode within App Builder? Mark for Review
(1) Points
An overlay window positioned within the same browser window.
A separate popup browser window. (*)
None of the above.
Incorrect Incorrect. Refer to Section 3 Lesson 1.
12. A report is the formatted result of a SQL query Mark for Review
(1) Points
True (*)
False
Correct Correct
13. When creating a database application, you can create which of the following report types? Mark for Review
(1) Points
(Choose all correct answers)
Classic Report. (*)
Interactive Grid. (*)
Interactive Report. (*)
Report on a form on a table. (*)
User Defined Report.
All of the above.
Incorrect Incorrect. Refer to Section 3 Lesson 2.
14. An interactive report is a formatted result of a SQL query? Mark for Review
(1) Points
True (*)
False
Correct Correct
15. A classic report is the formatted result of a SQL query? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 2.
==========================================================================================
1. Which of the following best describes a Modal Dialog Page Mode within App Builder? Mark for Review
(1) Points
An overlay window positioned within the same browser window. (*)
A separate popup browser window.
None of the above.
Correct Correct
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. The Page Mode determines if the page is a normal application page or a dialog Mark for Review
(1) Points
True (*)
False
Correct Correct
4. 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.
Incorrect Incorrect. Refer to Section 3 Lesson 1.
5. An interactive grid presents users a set of data in a searchable, customizable report? Mark for Review
(1) Points
True (*)
False
Correct Correct
6. Match the report capabilities to the statement “End user can add, modify, and refresh the data directly on the report”. Mark for Review
(1) Points
Interactive Report - No, Interactive Grid - Yes, Classic Report - No (*)
Interactive Report - No, Interactive Grid - Yes, Classic Report - Yes
Interactive Report - Yes, Interactive Grid - Yes, Classic Report - No
Interactive Report - Yes, Interactive Grid - No, Classic Report - Yes
Interactive Report - Yes, Interactive Grid - No, Classic Report - No
Incorrect Incorrect. Refer to Section 3 Lesson 2.
7. You cannot restrict the capabilities of interactive reports available to end users? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 2.
8. A report is the formatted result of a SQL query Mark for Review
(1) Points
True (*)
False
Correct Correct
9. Only developers can save Primary Default or Alternative Report? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 3.
10. When using an interactive report, developers can change the way an interactive report is rendered to end users? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 3
11. When using an interactive report, end users can decide the order in which the columns appear in the report? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 3.
12. 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 create and save alternative views of a report.
Provides features such as link to another page in your application.
Provides features such as change the sort order, hide columns etc.
Provides features such as customize an interactive report. (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
13. When using an interactive report, end users can add a computation to a column? Mark for Review
(1) Points
True (*)
False
Correct Correct
14. By default, an Interactive Grid controls can be used to alter the layout of report data by which of the following methods? Mark for Review
(1) Points
Applying filters
Highlighting
Selecting columns
Sorting (*)
All of the above
Incorrect Incorrect. Refer to Section 3 Lesson 4.
15. By default, an Interactive Grid includes which of the following components? (Choose all correct answers) Mark for Review
(1) Points
(Choose all correct answers)
Sort bar
Actions menu (*)
Search bar (*)
Column Heading menu (*)
Incorrect Incorrect. Refer to Section 3 Lesson 4.
==========================================================================================
1. An interactive grid presents users a set of data in a searchable, customizable report? Mark for Review
(1) Points
True (*)
False
Correct Correct
2. Match the report capabilities to the statement “End user can add, modify, and refresh the data directly on the report”. Mark for Review
(1) Points
Interactive Report - No, Interactive Grid - Yes, Classic Report - No (*)
Interactive Report - Yes, Interactive Grid - No, Classic Report - Yes
Interactive Report - No, Interactive Grid - Yes, Classic Report - Yes
Interactive Report - Yes, Interactive Grid - Yes, Classic Report - No
Interactive Report - Yes, Interactive Grid - No, Classic Report - No
Incorrect Incorrect. Refer to Section 3 Lesson 2.
3. A classic report is the formatted result of a SQL query? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 2.
4. 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.
5. Which of the following best describes a Non-Modal Dialog Page Mode within App Builder? Mark for Review
(1) Points
An overlay window positioned within the same browser window.
A separate popup browser window. (*)
None of the above.
Correct Correct
6. 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.
7. The Page Mode determines if the page is a normal application page or a dialog Mark for Review
(1) Points
True (*)
False
Correct Correct
8. 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.
9. Application Express only allows you to perform a non-case-sensitive search on the entire interactive report? Mark for Review
(1) Points
True
False (*)
Correct Correct
10. When using an interactive report, Application Express allows you to create multiple filters? Mark for Review
(1) Points
True (*)
False
Correct Correct
11. When using an interactive report, end users can decide the order in which the columns appear in the report? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 3.
12. When using an interactive report, which of the following filters can be created by an end user? Mark for Review
(1) Points
(Choose all correct answers)
Column filters. (*)
Row filters. (*)
Table Filter.
User defines filter.
Incorrect Incorrect. Refer to Section 3 Lesson 3.
13. Which of the following best describes the Actions menu within an Interactive Report? Mark for Review
(1) Points
Provides features such as change the sort order, hide columns etc.
Provides features such as customize an interactive report. (*)
Provides features such as link to another page in your application.
Provides features such as the Select Columns icon.
Provides features such as create and save alternative views of a report.
Correct Correct
14. 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.
15. By default, an Interactive Grid controls can be used to alter the layout of report data by which of the following methods? Mark for Review
(1) Points
Applying filters
Highlighting
Selecting columns
Sorting (*)
All of the above
Incorrect Incorrect. Refer to Section 3 Lesson 4.
==========================================================================================
1. 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.
2. Developers can determine whether an interactive grid is editable or read-only? Mark for Review
(1) Points
True (*)
False
Correct Correct
3. When using an interactive report, end users cannot customize their report to include specific columns? Mark for Review
(1) Points
True
False (*)
Correct Correct
4. When using an interactive report, the default setting always displays NULL values first? Mark for Review
(1) Points
True
False (*)
Correct Correct
5. Which of the following are components of an interactive report? Mark for Review
(1) Points
Actions menu.
Column heading menu.
Link to custom target.
Saved reports.
Search bar.
All of the above. (*)
Incorrect Incorrect. Refer to Section 3 Lesson 3.
6. Application Express only allows you to perform a non-case-sensitive search on the entire interactive report? Mark for Review
(1) Points
True
False (*)
Correct Correct
7. Which of the following best describes the Search bar within an Interactive Report? Mark for Review
(1) Points
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 the Select Columns icon. (*)
Provides features such as link to another page in your application.
Provides features such as customize an interactive report.
Incorrect Incorrect. Refer to Section 3 Lesson 3.
8. Hidden items are displayed in the Layout tab within Page Designer in App Developer? Mark for Review
(1) Points
True
False (*)
Correct Correct
9. Each page in an Oracle Application Express application can contain only one region? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 1.
10. 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.
11. The Property Editor within Page Designer organizes attributes into functional groups? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 1.
12. Match the report capabilities to the statement “End user can add, modify, and refresh the data directly on the report”. Mark for Review
(1) Points
Interactive Report - Yes, Interactive Grid - No, Classic Report - No
Interactive Report - No, Interactive Grid - Yes, Classic Report - No (*)
Interactive Report - Yes, Interactive Grid - Yes, Classic Report - No
Interactive Report - Yes, Interactive Grid - No, Classic Report - Yes
Interactive Report - No, Interactive Grid - Yes, Classic Report - Yes
Incorrect Incorrect. Refer to Section 3 Lesson 2.
13. When you create an application, the user interface you select determines the available report types? Mark for Review
(1) Points
True (*)
False
Incorrect Incorrect. Refer to Section 3 Lesson 2.
14. In an editable interactive grid, users ability to rearrange the report interactively using the mouse? Mark for Review
(1) Points
True (*)
False
Correct Correct
15. When viewing an interactive report, end users can customize how and what data displays? Mark for Review
(1) Points
True (*)
False
Correct Correct
None of the above.
=========================================================================================
4. When you create an application all report types are available to create? Mark for Review
(1) Points
True
False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 2.
8. Which of the following are the design Tabs within Page Designer in App Developer? Mark for Review
(1) Points
Component View.
Help.
Layout.
Messages.
Page Search.
All of the above. (*)
Incorrect Incorrect. Refer to Section 3 Lesson 1.