Free 1Z0-750 Questions for Oracle 1Z0-750 Exam [Sep-2022]
Validate your 1Z0-750 Exam Preparation with 1Z0-750 Practice Test (Online & Offline)
NEW QUESTION 39
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 Template to "Icon."
- B. Set List Attributes to style"display:none;
- C. Set User Defined Attribute 02 to icon-only
- D. Set List Entry Label to "Null."
Answer: C
NEW QUESTION 40
Bob has created an interactive report on the EMP table. Oracle BI Publisher has been configured as the report server in his environment. He has been asked to output a high-fidelity PDF report, which lists all employees.
How can Bob define the report?
- A. Create a modal page with a classic report on EMP by using the Printer-Friendly template. Add a button to the page to call the new modal page.
- B. Update the Interactive Report attributes and set Download > PDF to "Checked".
- C. Update the Interactive Report attributes and set Download > High Fidelity to "Checked".
- D. Define a report query and report layout based on the EMP table. Add a button to the page to output the report.
Answer: C
Explanation:
Explanation/Reference:
NEW QUESTION 41
Which two are true about using the Create Page Wizard to create a report with "Report with Form on Table"?
- A. The second page allows users to select the previous and next records.
- B. The wizard builds two pages, an interactive report page and a form page.
- C. The first page allows users to update records.
- D. The wizard builds two p3ges using an interactive grid page and a form page.
- E. The report and form must both be based on the same table or view.
Answer: A,D
NEW QUESTION 42
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. Run a query on the APEX_PAGE_DETAILSview where PAGE_TITLEis null
- C. Bring up each page in Page Designer and review the Page Name
- D. Ask end users to identify the problem pages
Answer: A
NEW QUESTION 43
Which three sources can be used for a classic report?
- A. SQL Query
- B. PL/SQL stored procedure with the out parameter
- C. PL/SQL function returning a single value variable
- D. PL/SQL function returning a SQL query
- E. CSV (comma separated values) file
- F. Excel spreadsheet
- G. RESTful Web Source module
Answer: A,D,G
NEW QUESTION 44
Which three actions can be performed In Object Browser?
- A. Download table data to XML.
- B. Write a SQL statement to update data in a table.
- C. Review the storage clause lot a table or view.
- D. Enable and disable Indexes.
- E. Review the SQL statement for an existing table.
- F. Truncate a table.
- G. Enable and disable constraints.
Answer: D,F,G
NEW QUESTION 45
George used the Create Page Wizard to create a calendar on the DEMP_ORDERS table based on the ORDER_TIMESTAMP column However, the calendar shows only the month and list views.
What does George need to do to show week and day views?
- A. Select Week and Day under Calendar Views and Navigation.
- B. Select the End Date Column.
- C. Set Maximum Events / Day to greater than 1.
- D. Set Show Time to "Yes."
Answer: B
NEW QUESTION 46
Which three actions can be performed by a workspace administrator?
- A. Add space to a schema.
- B. Manage user accounts.
- C. Approve workspace requests.
- D. Manage workspace to schema assignments.
- E. Monitor workspace activity.
- F. View usage reports for a workspace.
Answer: B,C,E
NEW QUESTION 47
As a project manager, you use spreadsheets to keep track of multiple projects. As you took responsibility of more projects, you became tired of managing them in spreadsheets.
You have collated 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 actions can you take? (Choose two.)
- A. 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.
- B. Define a Data Loading page in the Create Application Wizard.
- C. 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.
- D. Use the Create Application Wizard and select "From a Spreadsheet."
- E. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.
Answer: B,E
NEW QUESTION 48
Which three item types support defining a list of values?
- A. Color Picker
- B. Text Field with autocomplete
- C. List Manager
- D. Switch
- E. file Browse
- F. Shuttle
Answer: A,B,C
NEW QUESTION 49
Betty has created a zip file, app100 fiies.zip, to Include all of her static application files-that she references in her application. The files are divided into different subdirectories for JavaScript and CSS.
How can Betty upload the static files, so they can be referenced, and maintain the subdirectory structure?
- A. Upload app100_files. zip to the file server and unzip the file, in User Interface Properties, edit the Theme, and 'set JavaScript File URLs.
- B. In Shared Components, create the required subdirectories. Unzip app100_Files. zip. and upload each file Into their subdirectories.
- C. Unzip app100_files.zip, and upload each directory individually.
- D. Upload app100__files.zip, and set Unzip File to Yes.
Answer: D
NEW QUESTION 50
Which best describes how Session State Protection works?
- A. saves sensitive data in Oracle Application Express session state tables In encrypted form, stopping users from tampering with the data
- B. encrypts the values supplied in the URL to prevent reading of the values
- C. saves data in Oracle Application Express session state tables in encrypted form and uses the Page Access Protection attributes and the Session State Protection item attributes with checksums to prevent alteration of session state
- D. adds checksums to Page Access Protection attributes and Session State Protection Item attributes to prevent alteration of session state
Answer: D
NEW QUESTION 51
William has created the chart on the left, which displays values.
He wants to show the chart on the right. Which displays percentages.
Which step should William perform to display percentages?
- A. Set Label > Display As to ''Percentage.''
- B. Set the Column Mapping > Value to ''Percentage.''
- C. Set Tooltip > Show Values to "No.''
- D. Update the query to return percentage values.
Answer: B
NEW QUESTION 52
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 53
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. buttons
- B. page regions
- C. page items
- D. page processes
- E. application Items
- F. pages
Answer: C,D,E
NEW QUESTION 54
Molly has created a multi-series chart on the EMP table that shows the average salary per job in each department.
The chart below is not showing the data correctly because there are no Analysis or Salesmen In Department
10.
How must Molly update the chart to correctly display the data?
- A. Update the Series Column Mapping for Series Name to DEPTNO.
- B. Update group by In the chart SQL Query.
- C. Update the x-axis Baseline Scaling to "Fixed."
- D. Set Fill Gaps in Chart Data to "Yes."
Answer: C
NEW QUESTION 55
Bob' has created an interactive report on the EMP table. Oracle B1 Publisher has been configured as the report server in his environment. He has been asked to output a high-fidelity PDF report, which lists all employees.
How can Bob define the report?
- A. Create a model page with a classic report on EMP by using the Printer-Friendly template. Add a button to the page to call the new model page.
- B. Update the Interactive Report attributes and set Download > PDF to Checked.'
- C. Define a report query and report Layout based on the EMP table. Add a button to the page to output the report.
- D. Update the Interactive Report attributes and set Download > High Fidelity to Checked.''
Answer: D
NEW QUESTION 56
Penny has created a special survey page, Pago 8, where she wants to hide the standard navigation menu.
Which two ways can Penny hide the navigation menu only for Page 8?
- A. Update the navigation menu and set condition of Never for Page 8?
- B. Delete the Navigation Menu region from Page 8.
- C. Set Override User Interface Level to Yes.
- D. Change Page Template to Minimal (No Navigation) for page 8.
- E. Go to Page Shared Components. Right-click the navigation menu entry and select Delete.
- F. Do not include page e in the list of pages In the navigation menu.
Answer: A,D
NEW QUESTION 57
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 > Cross Page Utilities and review Page Attributes
- B. Go to Application Utilities > Templates and review the utilization report
- C. Go to Shared Components > Templates, and select References for the given template
- D. Run the Application Advisor and select Template Utilization
Answer: D
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/HTMDB/ui_templt.htm#HTMDB25621
NEW QUESTION 58
......
Check Real Oracle 1Z0-750 Exam Question for Free (2022): https://www.fast2test.com/1Z0-750-premium-file.html