Answer Section 4 Quiz Application Development Foundations 2019 Learner - English

Section 4

When you submit a page, the Application Express engine is running which of the following? 
             
            Find Page.

                           
            Submit Page.

                           
            Show Page.

                           
            Accept Page. (*)



If you wanted to assign a value to an identified item when a page is displayed or submitted you would use?    

                           
            A Trigger.

                           
            A Page-rendering computation.

                           
            Page-processing computation. (*)

                           
            A PL/SQL statement.


                                                   
When you create a branch, you must specify a Branch Point and Branch Type? 

                           
            True (*)

                           
            False


 In Application Builder, a branch is an instruction to go to a specific page, procedure, or URL?
                                                   
                           
            True (*)

                           
            False


In Application Builder, a branch can be defined to go to which of the following? 

                           
            A specific page

                           
            A procedure

                           
            A URL

                           
            All of the above (*)


Which of the following are an item in Application Builder?    

                           
            SQL Query

                           
            Text field (*)

                           
            Text area (*)

                           
            Select list (*)

                           
            Check box (*)

                           
            Password (*)


A list of values (LOV) is a static or dynamic set of values used to display a specific type of page item? 
                                                   
                           
            True (*)

                           
            False


 In Application builder, a list based on a SQL query you write that selects values from a table is known as? 

                           
            A User Defined List.

                           
            A Scratch List.

                           
            A Dynamic list. (*)

                           
            A Static list.

                                                   
Which of the following are types of Items in Application Builder? 

                           
            Application items

                           
            Authentication Scheme

                           
            Page items

                           
            Shared Components

                           
            All of the above (*)


Which of the following statements best describes an Single Page Master Detail Application Builder form type?

                           
            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.

                                                           

 Forms are application components that are used for data input from end users? 
                           
            True (*)

                           
            False

                                                   
Which of the following statements best describes an Editable Interactive Grid Application Builder form type? 

            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.

                           
            Builds a single page report and form combination based on tables you select.

                           
            Creates two pages. One page displays a report.

                                                   
Which of the following statements best describes an Form on Web Service Application Builder form type?
                                                   
                           
            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. (*)


 Forms can enable users to update multiple rows in a table?
                                                   
                           
            True (*)

                           
            False

                                                   
Forms can be created in Application Builder using which of the following methods?

                           
            Manually. (*)

                           
            Uploaded from an external application.

                           
            Using a Wizard. (*)

                           
            All of the above.

                           
            None of the above.

                                                           

Match the descriptions to the two processes Application Express engine relies on when you run an application.                                                 
                Accept Page : is the page rendering process.                                        
                Show Page : is the page rendering process. (*)                                        
                Accept Page : performs page processing. (*)                                        
                Show Page : performs page processing.  

A page process is a specific event that runs when a page is loaded or submitted?                                                       
                True (*)                                        
                False

Validations specific to a single item in Application Builder are defined as which of the following?                                               
                                       
                Page Validation.                                        
                Page Control Validation.                                        
                Page Item Validation. (*)                                        
                Application Control Validation.  

When you create a branch, you must specify a Branch Point and Branch Type? 
                                       
                True (*)                                        
                False

The process to retrieve records from a single database table or view in Application Builder is defined as which of the following?  
                                       
                SQL Row Fetch.                                        
                Automatic Row Processing.                                        
                PL/SQL Row Processing.                                        
                Automatic Row Fetch. (*) 

In Application builder, a list based on predefined pairs of display values and return values is known as?     
                                       
                A Static list. (*)                                        
                A User Defined List.                                        
                A Scratch List.                                        
                A Dynamic list. 

Which of the following are an item in Application Builder?                                                              
                Text area (*)                                        
                SQL Query                                        
                Check box (*)                                        
                Select list (*)                                        
                Text field (*)                                        
                Password (*) 

Which of the following are database application page controls in Application Builder?                   
                                       
                Buttons.                                        
                Dynamic Actions.                                        
                Page-level items.                                        
                Trees.                                        
                All of the above. (*) 

In Application Builder, you cannot use buttons to perform a Dynamic Action?   
                                       
                True                                        
                False (*) 

Which of the following statements best describes an Two Page Master Detail Application Builder form type?   
                                       
                Creates a form that enables users to update a single row in a database table.                                        
                Creates two pages. One page displays a report. (*)                                        
                presents users a set of data in a searchable, customizable report.                                        
                Builds a single page report and form combination based on tables you select. 

Application Builder provides which of the following form types? 
                                       
                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. (*) 

A master detail form reflects a one-to-many relationship between two tables?
                                       
                True (*)                                        
                False 

Which of the following statements best describes an Form on Web Service Application Builder form type? 
                                       
                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. (*) 

Forms are made up of types?  
                                       
                True                                        
                False (*)

 Which of the following statements best describes an Single Page Master Detail Application Builder form type? 
                                       
                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.                                        
                Creates two pages. One page displays a report.                                        
                Builds a single page report and form combination based on tables you select. (*)