Updated Oct-2021 Pass 1Z0-750 Exam - Real Practice Test Questions
Download Free Oracle 1Z0-750 Real Exam Questions
NEW QUESTION 21
As a project manager, you use spreadsheets to keep track of multiple projects. As you took-responsibility of more projects, you become tired of managing them in spreadsheets.
You have collected all of your project data in one single spreadsheet. You also want to maintain the data in an Oracle Database table by using an Oracle Apex application.
Which two action can you take?
- A. Create a new table by using SQL Workshop > Object Browser .Create Table, and then use the Create Application Wizard to Create an application based on the new table.
- B. Use the Create Application Wizard and select ''From a Spreadsheet.''
- C. Use SQL Workshop >Utilities > Data Workshop to load the data into a new table, and then use the Create Application wizard to create an application on the new table.
- D. Define a Data Loading page in the Create Application Wizard.
- E. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.
Answer: D,E
NEW QUESTION 22
Phil has been given the responsibility for an application that was developed years ago, because the original developer has left the company. End users have complained about accessibility because not all pages have titles.
How can Phil ensure that he corrects all pages in the app without page titles?
- A. Use Application Advisor to perform a check
- B. Bring up each page in Page Designer and review the Page Name
- C. Run a query on the APEX_PAGE_DETAILSview where PAGE_TITLEis null
- D. Ask end users to identify the problem pages
Answer: A
NEW QUESTION 23
Which three actions can be performed In Object Browser?
- A. Review the storage clause lot a table or view.
- B. Download table data to XML.
- C. Write a SQL statement to update data in a table.
- D. Enable and disable Indexes.
- E. Enable and disable constraints.
- F. Truncate a table.
- G. Review the SQL statement for an existing table.
Answer: D,E,F
NEW QUESTION 24
Fred created a parent/child relationship between the Employees and Departments.
Fred wants to hide the Departments region.
What should Fred do to achieve this?
- A. Set the Server-side Condition to "Never"
- B. Set the Read Only condition to "Never"
- C. Set the Road Only condition to "Always"
- D. Set the Parent Region to "Null"
- E. Delete the region
Answer: D
Explanation:
Explanation/Reference: https://docs.oracle.com/html/E39147_04/ui003.htm#CHDBAEEJ
NEW QUESTION 25
Martin has a text field on a page that he wants to protect with Session State Protection.
Select the four valid protection levels available to Martin. (Choose four.)
- A. Checksum Required: Session Level
- B. Checksum Required: User Level
- C. Checksum Required: Workspace Level
- D. Unrestricted
- E. Restricted: May not be set from browser
- F. Hidden Item
- G. Checksum Not Required
- H. Checksum Required: Application Level
Answer: A,B,E,H
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/HTMDB/sec_dev.htm#HTMDB25976
NEW QUESTION 26
Nancy has an application that is performing unexpectedly. She has turned on debug for the page and reviewed the debug messages and still can't determine the cause of the Inconsistent behavior. She believes It may be an APEX bug.
What action should Nancy take to Identify the issue?
- A. Set Debug Level to 9 and review the debug messages.
- B. View the page source.
- C. Review the application error log.
- D. Review the browser console output.
Answer: A
NEW QUESTION 27
Jules is trying to implement Session State Protection to increase the security of rules' application. On which three components can Jules configure Session State Protection in Oracle Application Express?
- A. page processes
- B. pages
- C. application Items
- D. page regions
- E. page items
- F. buttons
Answer: A,C,E
NEW QUESTION 28
Trillian wants to pass an item value, which includes a comma, such as the value Donuts, Coffee, In the URL when calling another page.
How can Trillian escape the Item value so that the comma is interpreted correctly?
- A. Donuts\,Coffee
- B. \Donuts,Coffee\
- C. /Donuts,Coffee/
- D. "Donuts,Coffee"
Answer: D
NEW QUESTION 29
ABC Company developed an employee directly by using an interactive report.
The HR manager (an end user) has customized his or her report to show only employees in the HR department, and wants to review the same report weekly.
How can the HR manager achieve this?
- A. Download the report to a CSV or HTML file
- B. Add a control break on Department
- C. Add a filter to the report
- D. Save the report as a named report
- E. Save the report as the primary report
Answer: E
NEW QUESTION 30
Which two actions can be done by a Page Process of type Automatic Row Processing (DML)? (Choose two.)
- A. Perform CRUD operations on multiple tables.
- B. generate a primary key column value on a SQL INSERTstatement.
- C. Perform automatic detection of lost updates.
- D. Apply a SQL WHEREclause to append to all generated INSERT, UPDATE, and DELETEstatements at run time.
- E. Log a user-defined message when an exception is raised.
- F. Invoke PL/SQL code to perform the inserts, updates, and deletes.
Answer: D,F
Explanation:
Explanation/Reference: https://docs.oracle.com/html/E39147_04/app_forms004.htm
NEW QUESTION 31
Thomas has created an app and wants to add a help Icon to the navigation bar. He has added the list entry with the Image/Class fa-question circle-o and List Entry Label "Help." When he runs the app, the question mark Is displayed together with the word Help.
How can Thomas display just the icon and not the word Help in the navigation bar?
- A. Set List Entry Label to "Null."
- B. Set List Attributes to style"display:none;
- C. Set List Entry Template to "Icon."
- D. Set User Defined Attribute 02 to icon-only
Answer: D
NEW QUESTION 32
Susan created Page 10as an interactive report, called Departments, on the DEPT table. She also created Page 11as an interactive report on the EMP table, called Employees.
Susan would like to add a link in the Departmentsreport (Page 10) that redirects to the Employeesreport (Page 11) and displays only employees for the selected department.
How would Susan set items in the link builder on Page 10 to correctly call the report on Page 11?
- A. Set item name to :P11_DEPTNOand value to #DEPTNO#
- B. Set item name to :P11_DEPTNOand value to :P10_DEPTNO
- C. Set item name to :P10_DEPTNOand value to #DEPTNO#
- D. Set item name IR_DEPTNOand value to #DEPTNO#
Answer: A
NEW QUESTION 33
Sunny has developed a report and form on customers, which is open partners. The report displays only customers associated with partners, based on their user credentials.
Partners can click an Edit button to go to a form to update their customers.
Sunny Is concerned that IT savvy users will be able to to alter the URL to be able to see and Update records from other partners.
What must Sunny do to protect the form page from URL tampering?
- A. Set Deep Linking to Disabled.
- B. Set Rejoin Session to disabled.
- C. Update Page Access Protection to Arguments Must Have Checksum.
- D. Set Authentication to Administrator Rights.
- E. Update Page Access Protection to No URL Access.
Answer: C
NEW QUESTION 34
What is the least error-prone way to split a long list into two lists?
- A. Create an empty second list, copy selected list items from the first list to the second list, and then remove the copied list items from the first list.
- B. Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.
- C. Create two new lists, copy list items from the initial list to the first list, copy the remaining list items from the initial list to the second list, and then delete the initial list.
- D. Copy the entire list, grid edit the copied list and remove entries that are not needed, and then grid edit the first list and remove the entries that are now in the second list.
Answer: B
NEW QUESTION 35
Which is true about the Button Name attribute?
- A. The button name is a unique Identifier on a page. No other buttons or page items on the page can have the same name.
- B. The button name serves as a static ID, which is useful when developing custom JavaScript functionality for the button.
- C. The button name defines what database action is done on page submit.
- D. When the page is submitted by clicking the button, the value of bequest is set to the button name.
Answer: B
NEW QUESTION 36
Kyle' is developing a page with an interactive report, called Employees, using this query: - SELECT EMPNO, ENAME, JOB, DEPTMO FROM EMP WHERE DEPTHO = nv1 (: P3_DEPTHO, DEPTNO) On the page. Kyle adds a select list, called p3_deptmo, using this query:
SELECT dname, deptno FROM dept;
He creates a dynamic action on change of p3_deptno. with a true action of 'Refresh' against the Employs region.
Kyle then runs the page and selects accounting in the P3_ DEPTNO item. However, the report still shows employees from all departments.
What must Kyle do to correctly display only employees from the department selected?
- A. Add a computation set to p3_ DEPTNO
- B. Set a column on the DEPTNO column.
- C. Set "Page Items to Submit" to p3_deptho in the report.
- D. Add an additional true action of Set Value by using Static Assignment in Dynamic Action.
Answer: D
NEW QUESTION 37
You "want to refer to a page by a name (or alias) instead of page number in the application URL Which step most accurately helps you achieve this?
- A. Go to Application Properties and set "Refer to page by name (or alias)' to "Yes."
- B. Enter an alphanumeric name In the Page Title attribute.
- C. Enter an alphanumeric alias in the Page Alias attribute.
- D. Set the Built-in substitution string PAGE_ALIAS on page load.
Answer: C
NEW QUESTION 38
Jane is creating a new application. Users of the application will use SSO to authenticate. SSO has been defined for the instance.
Which step should Jane perform in the Create Application Wizard?
- A. Include the Access Control feature.
- B. Include a Sign-In page in the list of pages.
- C. Under Authentication, select Single Sign On (SSO).
- D. Update Advanced Settings to specify authentication.
Answer: C
Explanation:
Explanation/Reference:
Reference https://docs.oracle.com/database/apex-18.1/HTMDB/establishing-user-identity-through- authentication.htm#HTMDB12003
NEW QUESTION 39
whore is Oracle APEX session state stored between calls from the browser?
- A. in the browser in the form of cookies
- B. in the APEX metadata schema
- C. is passed back and forth between the database and browser with each call
- D. In the workspace schema
Answer: A
NEW QUESTION 40
......
1Z0-750 Dumps 100 Pass Guarantee With Latest Demo: https://www.newpassleader.com/Oracle/1Z0-750-exam-preparation-materials.html