Oracle-Oracle Application Express 3.2 Developing Web Applications

Question - 9 Maximum mark : - 14

Home
All Exams
Oracle-Oracle Application Express 3.2 Developing Web Applications Online Mock Tests
Oracle-Oracle Application Express 3.2 Developing Web Applications

In your application both page 2 and page 4 branches to page 5. Page 5 has a Cancel button which currently redirects to page 2, however it should redirect to either page 2 or page 4 depending on the origination page. Which three actions need to be performed?

Create two application items: LAST_PAGE and CURRENT_PAGE. Create an application computation on item LAST_PAGE, computation point Before Header, typePL/SQL Function Body and the computation body as: BEGIN :LAST_PAGE:=nv(:CURKENT_PAGE,:APP_PAGE_ID; :CURRENT_PAGE:=APP_PAGE_ID RETURN:LAST_PAGE; END; Create an application computation on Item LAST_PAGE, computation point After Submit, type PL/SQLFunction Body and the computation body as: BEGIN :LAST_PAGE:=:CURRENT_PAGE; :CURRENT_PAGE:=: APP_PAGE_ID; RETURN:LAST_PAGE; END; On page 5 create a validation to check whether the value stored in application item LAST_PAGE is equal tothe value of APP_PREVJ_PAGE_ID WhereAPPJ>REV_PAGE_ID is Built-in Substitution String in Oracle APEX that stores the number of calling page. On page 5 use the value stored in application item LAST_PAGE to go back to the page from which youbrowsed to the current page.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which two are true about creating interactive reports?

A form and Interactive'-report can be at the same time. An interactive report must be baseiHHp SQL Query. All the columns must be shown in Interactive report Onlyone interactive report can be defined on a page. More than one Interactive report can be viewed on a page.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

ABC Company wants to change the font color of a Region Title to blue. Which two actions could be performed to accomplish this task?

Use a standard class in template definition for #TTTL# Add a font tag around the substitution #TTTL# found in the region template definition. Reference a class from a cascading style sheet that changes the text color to the desired Certkey.com -Make You Succeed To Pass IT Exams Certkey 1Z0-450 color and apply that class in the HTML that immediately precedes the subsitiution #TTTL# found hi the region template definition. Add a font class that contains the desire color to the Region Header filed in the Region Definition. Add an APEX standard class to the header for the page.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are testing a customer entry from that is part of an Order Processing application. When you open the form the first time, enter data, and click `Submit', a message "Action Processed" is displayed and data is inserted into the underlying table. However, when you open the page again, it displays old data in place of a blank new form. How do you ensure that a blank form is displayed so that you can enter new customer data?

Modify the branch for the "Submit" button to clear the cache for the page or items on the page. ✘ Select "Always, replacing any existing value in session state" from Source Used field for each form item onthe page. ✘ Set Caching to "Not Cached" for the region that hosts the customer entry form ✘ Set Caching to "Not Cached" for the page that hosts the customer entry form ✔ Set Caching "Maintain session state" item property to "Per Session" ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which three statements are true about a wizard-generated tabular form?

Only allows you to update one record at a time Allows you to add and update multiple records at a time You can drill down to detail record view Allow you to add more than one record at a time Only allows you to change the updateable columns

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

XYZ Corporation wants to develop a new theme for all applications within a workspace. In order for a new theme to be applied to all applications, you must perform these steps. 1)Promote the theme to a workspace theme. 2)Change the theme identification number to a number higher than 100 3)Modify all applications to switch to the new theme. 4)Copy an existing theme 5)Navigate to the Themes page 6)Change the templates in the new theme 7)Edit the theme definition. What is the most likely sequence for he steps be perfromed in?

4,5,7,1,2,6,3] ✘ 4,5,3,7,2,6,1 ✘ 5,4,7,2,3,1,6 ✘ D.5,4,2,7,1,6,3 ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which three steps are presented when importing an application?

Specify where to store the imported application Browse to the file location and select the name of the file to be imported Select how to resolve Application ID conflicts Select the parsing schema and build status Select the database character set

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

After creating buttons in a region position, you cannot change the position of the buttons to

Bottom of the region ✘ Above or below the region ✘ In any button position defined in the region template ✘ To the left or the right of the page title ✔ Among this region's Items ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

User Details form page is page 1 in your application. On this page the end user is required to provide his Name and Address details- You need to create a validation that requires the end user to enter aprovince if the country is not the United States (US). Which action needs to be performed?

Create a validation of type SQL and enter the following in the validation method; SELECT1FROMCUTOMERS WHERE COUNTRY='US' AMD PROVINCEIS NULL ✘ Create a validation of type PL/SQL Function Returning Boolean and enter the following in ht evalidationmethod: BEGIB IF"Pi_COUNTRY ='US' AMD: PI_PROVINCE IS NULL THEN RETURM FALSE; ELSE RETURN TRUE; END IF; END; ✘ Create a validation of type PL/SQL Function Returning Booleanand enter the following in ht evalidationmethod; begin IF: P1_COUNTRY !+'US' AND; PI_PROVINCE IS NULLTHEN RETURN FALSE; ELSE RETURN TRUE; END IF; END; ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle-Oracle Application Express 3.2 Developing Web Applications

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner