Oracle 1Z0-750 問題集

質問 1：
You want to use the session state value of a page item in the select statement for a report on another page.
What is the correct way to reference the value of a page item in a SQL statement?
A. APEX_UTIL.GET_SESSION_STATE(p_item => 'PAGE_ITEM)
B. &PAGE_ITEM
C. :PAGE_ITEM
D. v('PAGE_ITEM')
正解：A

質問 2：
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 the Job column and select salesman from the column filter list of values
B. Click Actions > Filter and select Job as column, equal sign (=) as operator, SALESMAN as Expression, and then click Apply.
C. 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 Search icon (magnifying glass) on the search bar, and enter SALESMAN in the search bar text box.
正解：B,C

質問 3：
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 > High Fidelity to Checked.''
C. Update the Interactive Report attributes and set Download > PDF 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.
正解：B

質問 4：
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. Use the Create Page Wizard to re-create the pages.
B. Update the existing generated pages.
C. Update Data Load Definition.
D. Delete Data Load Definition and re-create it manually.
正解：C

質問 5：
Which is Hue about interactive reports?
A. An Interactive report can be based on a PL/SQL function body returning a SQL query.
B. You can define only one Interactive report on a page.
C. All columns defined In the report query must be shown.
D. Interactive reports can be either read-only or editable.
正解：D

質問 6：
Martin has a text field on a page that the wants to protect with session Satate protecton.
Select the four valid protection levels available to Martin.
A. Checksum Required: Workspace Level
B. Checksum required: Application Level
C. Restricted: may not be set from browser
D. Checksum Required: User Level
E. Checksum Required: Session Level
F. Hidden Item
G. Checksum NOT Required
H. Unrestricted
正解：B,C,D,E

質問 7：
Phil has been given the responsibility 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. Bring up each page In Page designee and review the Page Name.
B. Ask end users to identify the problem pages.
C. Use Application Advisor to perform a check.
D. Run a query on the APEX_PAGE_DETAILS view where PAGE_TITLE is null.
正解：C

質問 8：
Which four Oracle APEX region types can be created on top of a Web Source module?
A. PL/SQL Dynamic Content
B. List View
C. Tree
D. Interactive Grid
E. Interactive Grid (non-editable)
F. Chart
G. Interactive Report
H. List
I. Classic Report
J. Static Content
正解：C,D,F,G