Oracle 1Z0-750 Online Practice Questions and Exam Preparation

Oracle 1Z0-750 Online Questions & Answers

• Question 1:

  Brian created a page with multiple regions. He now wants to include a list of links to selectively display each region.

  

  How can Brian achieve this?

  A. Create a region of type Region Display Selector, and ensure that each region has Region Display Selector set to "Yes".
  B. Create a parent region called REGIONS. For each region, update the Parent Region attribute to REGIONS.
  C. Create a list in Shared Components containing each region. Create a region of type List and associated the list created.
  D. Define static IDs for each region. Create a region called REGIONS of type Static Content with named anchors to other regions.
  A. Create a region of type Region Display Selector, and ensure that each region has Region Display Selector set to "Yes".

• Question 2:

  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. Go to Application Utilities > Cross Page Utilities and review Page Attributes
  D. Run the Application Advisor and select Template Utilization
  D. Run the Application Advisor and select Template Utilization

  ---

  Reference: https://docs.oracle.com/database/121/HTMDB/ui_templt.htm#HTMDB25621

• Question 3:

  Where is Oracle APEX session state stored between calls from the browser?

  A. in the browser in the form of cookies
  B. in the workspace schema
  C. in the APEX metadata schema
  D. is passed back and forth between the database and browser with each call
  A. in the browser in the form of cookies

  ---

  Reference: https://docs.oracle.com/database/apex-18.1/HTMDB/understanding-session-state-management.htm#HTMDB03009

• Question 4:

  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 Nameto DEPTNO.
  B. Set Fill Gaps in Chart Data to "Yes."
  C. Update group by In the chart SQL Query.
  D. Update the x-axis Baseline Scaling to "Fixed."
  D. Update the x-axis Baseline Scaling to "Fixed."

• Question 5:

  Jason has developed an app for maintaining customers. He has a navigation menu for customers that he needs to associate with multiple pages.

  How can Jason associate one list entry with multiple pages?

  A. Set List Entry Current for Pages Type to "Comma Delimited Page List."
  B. Update the list entry User Defined Attribute 01 to "MULTIPLE", and User Defined Attribute 02 to the list of pages.
  C. Update each page and set Current Navigation Menu Entry to "Customers".
  D. Add additional list entries labeled Customers.
  E. Update list entry Condition Type to "Current Page Is Contained Within Expression 1 (comma delimited list of pages)."
  E. Update list entry Condition Type to "Current Page Is Contained Within Expression 1 (comma delimited list of pages)."

• Question 6:

  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. Click Actions > Filter and select Job as column, equal sign (=) as operator, SALESMAN as Expression, and then click Apply.
  B. Enter salesman in the search bar text box.
  C. Click the Search icon (magnifying glass) on the search bar, and enter SALESMAN in the search bar text box.
  D. Add a where clause to the SQL Query to restrict the records returned.
  E. Click the Job column and select salesman from the column filter list of values
  A. Click Actions > Filter and select Job as column, equal sign (=) as operator, SALESMAN as Expression, and then click Apply.
  B. Enter salesman in the search bar text box.

• Question 7:

  You created an application where the home page looks like:

  

  You now want to change the page to look like:

  

  What do you need to do to change the appearance of the page?

  A. Update the region Type to "List View"
  B. Update the list Template to "Media List"
  C. Update the list Template Options > Style to "Basic"
  D. Update the region Template Options > Icons to "No Icons"
  B. Update the list Template to "Media List"

  ---

  Reference: https://apex.oracle.com/pls/apex/apex_pm/r/ut/lists

• Question 8:

  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. Define a report query and report layout based on the EMP table. Add a button to the page to output the report.
  C. Update the Interactive Report attributes and set Download > PDF to "Checked".
  D. Update the Interactive Report attributes and set Download > High Fidelity to "Checked".
  D. Update the Interactive Report attributes and set Download > High Fidelity to "Checked".

• Question 9:

  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. Define a Data Loading page in the Create Application Wizard.
  B. 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.
  C. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.
  D. Use the Create Application Wizard and select "From a Spreadsheet."
  E. 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.
  A. Define a Data Loading page in the Create Application Wizard.
  C. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.

• Question 10:

  In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS-based RESTful Services?

  A. Install the Sample REST Services packaged application.
  B. Navigate to the Shared Components section and configure a REST Enabled SQL resource.
  C. Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button.
  D. Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes".
  C. Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button.

  ---

  Reference: https://docs.oracle.com/en/database/oracle/application-express/19.1/aeutl/accessing-RESTful-services.html#GUID-DE5D8763-A650-4FBA-9CC5-17E141C8406C