[2022] 1Z0-750 PDF Questions - Perfect Prospect To Go With DumpsMaterials Practice Exam
Oracle 1Z0-750 Pdf Questions - Outstanding Practice To your Exam
NEW QUESTION 25
KIM has defined a validation of '' Item is NOT zero'' on ps_SAL. When she runs the page, the error is displayed in the notification, but does not highlight the item or display the error below the item.
KIM changes Display Location to ''Inline with Field and Notification. ''However, the validation error still does not display under the item.
What must KIM do to ensure that the validation error appears correctly under the item and also in the notification?
- A. Set value Requires to Yes on p5_SAL.
- B. Set Display Location to ''Inline with Field.''
- C. Set validation Associated Item to p5 SAL.
- D. Add javaScript to the item to display on error.
Answer: B
NEW QUESTION 26
Which is true interactive reports?
- A. A developer can delete a primary report
- B. A developer can hide the search bar
- C. Only reports can be downloaded, not group by, charts, or pivots
- D. Subscription is supported only on primary reports
Answer: B
NEW QUESTION 27
Which two actions can be done by a Page Process of type Automatic Row Processing (DML)?
- A. Perform CRUD operations on multiple tables.
- B. Log a user-defined message when an exception is raised.
- C. invoke PL/SQL code to perform the Inserts, updates, and deletes.
- D. Apply a SQL where clause to append to all generated INSERT, UPDATE, and delete statements at fun time.
- E. Perform automatic detection of lost updates.
- F. Generate a primary key column value on a SQL INSERT statement.
Answer: C,D
NEW QUESTION 28
Maurice wants to have a report on employees, which shows only employees tor the department selected in a select list Item.
He has created a report, called report_1, based on the EMP table. Above the region, he has defined a select list called p6_deptno.
Maurice has added the correct Where clause for report_1 and defined an "on change" dynamic action on p6_deptno to refresh the report_1 region.
When he runs the page, no data is displayed. Irrespective of the department selected.
What must Maurice do to get the page to work correctly?
- A. On the report_1 region, set page Items to submit to p6_deptno.
- B. Add a set value action, before the refresh action, of type PL/SQL Expression with code of : p6^deptno and items to submit to p6_DEPTNO.
- C. In the "on change" dynamic action, set event scope to "dynamic."
- D. In the "on change" dynamic action, set page Items to submit to p6_DEPTNO.
Answer: B
NEW QUESTION 29
Carl has created a new region template as a copy of the Standard region template in Universal Theme. He wants to update the template, but is not sure how often the template is used throughout the application.
How can Carl determine all of the pages where his custom template is used?
- A. Go to Application Utilities > Templates and review the utilization report
- B. Go to Shared Components > Templates, and select References for the given template
- C. Run the Application Advisor and select Template Utilization
- D. Go to Application Utilities > Cross Page Utilities and review Page Attributes
Answer: C
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/HTMDB/ui_templt.htm#HTMDB25621
NEW QUESTION 30
Which three item types support defining a list of values?
- A. Text Field with autocomplete
- B. Switch
- C. file Browse
- D. List Manager
- E. Shuttle
- F. Color Picker
Answer: A,D,F
NEW QUESTION 31
Francisco has been tasked with creating a Frequently Asked Questions (FAQ) page. The page security requirements are defined as:
* Anyone who can access the application, in any capacity, shall also be able to view the new FAQ page.
Which page level Authorization Scheme and Authentication options should Francisco choose?
- A. Authorization Scheme: Null; Authentication: Page is Public
- B. Authorization Scheme: Reader Rights; Authentication: Page Requires Authentication
- C. Authorization Scheme: {Not Reader Rights}; Authentication: Page Is Public
- D. Authorization Scheme: Must Not Be Public User; Authentication: Page Requires Authentication
Answer: A
Explanation:
Explanation/Reference:
NEW QUESTION 32
Which three actions can be performed In Object Browser?
- A. Download table data to XML.
- B. Enable and disable Indexes.
- C. Truncate a table.
- D. Review the SQL statement for an existing table.
- E. Write a SQL statement to update data in a table.
- F. Enable and disable constraints.
- G. Review the storage clause lot a table or view.
Answer: B,C,F
NEW QUESTION 33
Lucy' created an interactive report on the EMP table. She wants to filter the report to show employees with JOB = SALESMAN'.
Which two options could Lucy perform to add an equals filter on the Job column?
- A. Add a where clause to the SQL Query to restrict the records returned.
- B. Click Actions > Filter and select Job as column, equal sign (=) as operator, SALESMAN as Expression, and then click Apply.
- C. Click the Job column and select salesman from the column filter list of values
- D. Click the Search icon (magnifying glass) on the search bar, and enter SALESMAN in the search bar text box.
- E. Enter salesman in the search bar text box.
Answer: B,E
NEW QUESTION 34
Mark has created a modal form page to enter new calendar events. Mark now wants to call the form when an spot.
How can Mark update the calendar region to call the form?
- A. In the rendering tree, right-click the calendar region and select the Link Form to calendar option.
- B. Use the create link attribute and the APEXSNEW_START_DATE placeholder.
- C. Define a dynamic action of type click in the calendar region.
- D. Use the view/edit link attribute to display the selected calendar entry.
- E. Use the create link attribute and use the :APEXSNEW_STANT_DATE bind variable.
Answer: D
NEW QUESTION 35
Which two actions can be done by a Page Process of type Automatic Row Processing (DML)?
- A. Perform CRUD operations on multiple tables.
- B. invoke PL/SQL code to perform the Inserts, updates, and deletes.
- C. Perform automatic detection of lost updates.
- D. Generate a primary key column value on a SQL INSERT statement.
- E. Log a user-defined message when an exception is raised.
- F. Apply a SQL where clause to append to all generated INSERT, UPDATE, and delete statements at fun time.
Answer: B,E
NEW QUESTION 36
Sam is updating an application with a report (page 10) and form (page 11), where the form page has Page Mode "Normal." She wants to update the form page to a modal dialog, so it can be called from multiple report pages.
Sam has already changed Page Mode to "Modal Dialog." removed the breadcrumb region, added a button region to the dialog footer, and moved the buttons to the new region.
Whenever she opens the form page from a different report page (page is), it keeps returning to the original report page (Page 10) when she cancels or submits the form page.
Which three steps must Sam perform to get the modal page to always return to the report page from which it was called?
- A. Create a Dynamic Action of type Cancel Dialog that fires when the CANCEL button is clicked.
- B. Change the action on the CANCEL button to "Defined by Dynamic Action."
- C. Add a Close Dialog process.
- D. Add a branch that redirects to an item holding the calling page.
- E. Update the branch to return to the correct calling page.
- F. Create a Dynamic Action of type Close Dialog that fires whenever the DELETE, SAVE, or CREATE button is pressed.
- G. Create a hidden page item to hold the calling page and update the calls to the form page to populate the item.
Answer: A,B,C
NEW QUESTION 37
Maurice wants to have a report on employees, which shows only employees or the department selected in a select list item. He has created a report, called REPORT_1, based on the EMP table. Above the region, he has defined a select list called P6_DEPTNO. Maurice has added the correct Where clause for REPORT_1 and defined an "on change" dynamic action on P6_DEPTNO to refresh the REPORT_1 region. When he runs the page, no data is displayed, irrespective of the department selected.
What must Maurice do to get the page to work correctly?
- A. On the REPORT_1 region, set page items to submit to P6_DEPTNO.
- B. Add a set value action, before the refresh action, of type PL/SQL Expression with code of :P6_DEPTNO and items to submit to P6_DEPTNO.
- C. In the "on change" dynamic action, set event scope to "dynamic".
- D. In the "on change" dynamic action, set page items to submit to P6_DEPTNO.
Answer: D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E10513_01/appdev.310/e10497/rprt_query.htm#BABGAFID
NEW QUESTION 38
Kevin has been asked to create a percentage bar chart that shows what percentage of project were over budget and under budget. Initially his chart looks like.
However, he wants the chart to look like.
What chart attribute should Kevin change to fix this display issue?
- A. Chart Type =Percent
- B. Combine Series = Yes
- C. Fill Gaps in Chart Data + Yes
- D. Stack = Yes
Answer: D
NEW QUESTION 39
Which three are true about using REST Enabled SQL to access a remote database?
- A. A REST Enabled SQL Reference must be created in Shared Components.
- B. A wallet must be defined and configured on the remote database.
- C. Authentication can be done using the remote database username and password.
- D. The application parsing schema must be REST enabled.
- E. Authentication must be done using the OAuth2 Client Credentials flow.
- F. REST Enabled SQL must be enabled In the remote databases' ORDS configuration.
Answer: A,B,F
NEW QUESTION 40
Fred" created a parent/child relationship between the Employees and Dep..
Fred wants to hide the Departments region. What should Fred do to achieve this?
- A. Set the Parent Region to "Null."
- B. Delete the region.
- C. Set the Read Only condition to "Never."
- D. Set the Server-side Condition to "Never."
- E. Set the Read Only condition to "Always."
Answer: D
NEW QUESTION 41
John has a form page with an email item and a status item.
What must John do to ensure that the email Item is populated before users can enter any value into the status Item on the form page?
- A. server-side condition on the status item
- B. dynamic action on the email item
- C. validation on the email item
- D. plug-in for the status item
Answer: D
NEW QUESTION 42
When testing the Data Load Wizard pages, you realize that you forgot to add a transformation rule. What should you do to add the transformation rule?
- A. Delete Data Load Definition and re-create it manually.
- B. Use the Create Page Wizard to re-create the pages.
- C. Update the existing generated pages.
- D. Update Data Load Definition.
Answer: D
NEW QUESTION 43
Which three actions can be performed in Object Browser? (Choose three.)
- A. Download table data to XML.
- B. Enable and disable indexes.
- C. Truncate a table.
- D. Review the SQL statement for an existing table.
- E. Write a SQL statement to update data in a table.
- F. Enable and disable constraints.
- G. Review the storage clause for a table or view.
Answer: B,C,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e12511/obj_brows.htm#AEUTL185
NEW QUESTION 44
Michael created a report and form on a table to maintain customers.
When Michael tested the new form and entered a new record, he got this error:
What should Michael do to resolve this Issue?
- A. Set the Customer ID item to text Held with Read-Only set to "Always."
- B. Create a sequence.
- C. Add a trigger on the table to populate the CUSTOMER_ID column when null.
- D. Select Managed by Database (ROWID) for the Primary Key type.
Answer: D
NEW QUESTION 45
Morgan has a report and form on the EMP table. He updated the form by adding a display-only item P5_LOC, and a change event dynamic action on P5_DEPTNOto populate the item using Set Value with this SQL:
select loc from dept
where deptno = :P5_DEPTNO;
When Morgan runs the page, he gets this error:
apex_error_code:
WWV_FLOW_DML.COLUMN_NOT_FOUND
original message: Column LOC not found in table EMP
What should Morgan do to prevent this error?
- A. Update P5_LOCand set Save Session State to "No."
- B. Update P5_LOC and set Source Type to Item and select Item P5_DEPTNO.
- C. Update P5_LOC and set Source Type to "Null".
- D. Update P5_LOC and set Source Database Column to DEPTNO.
- E. Update P5_DEPTNO and set Type to "Display Only."
Answer: C
Explanation:
Explanation/Reference:
NEW QUESTION 46
......
Online Questions - Outstanding Practice To your 1Z0-750 Exam: https://www.dumpsmaterials.com/1Z0-750-real-torrent.html
