Free Oracle 1z0-985 Practice Test & Real Exam Questions

Exam Code/Number: 1z0-985
Exam Name/Title: Oracle Enterprise Performance Reporting Cloud Service 2017 Implementation Essentials
Certification Provider: Oracle
Corresponding Certification: Other Oracle Certification

Exam Questions: 70
Updated On: Sep 22, 2026

Question #8

You need to add the number 10 to column A in a management report. Which two are acceptable formula syntaxes for doing this?

A. =SUM([A],10)

B. A+10

C. =SUM(A, 10)

D. [A]+10

E. SUM([A],10)

F. SUM(A, 10)

Discussion 0

Correct Answer: A,C Vote an answer

Question #9

Your package details are finalized for the month. What step would you take to ensure no updates are made to the doclets?

A. Remove Security

B. Signoff Content

C. Approve Content

D. Remove doclet

E. Lock Content

Discussion 0

Correct Answer: C Vote an answer

Question #10

You have a requirement for a management report to display both the report's name and the fiscal year being run by the report.
What are the correct text function and syntaxes to accomplish this?

A. ReportTitle()
MemberAlias("Grid 1", "Years")

B. ReportName()
MemberAlias("Grid 1", "Years")

C. ReportDescription()
MemberAlias("Grid 1", "Years")

D. ReportTitle()
MemberAlias("Grid 1", "FY 16")

E. ReportDescription()
MemberAlias("Grid 1", "FY 16")

F. ReportName()
MemberAlias("Grid 1", "FY 16")

Discussion 0

Correct Answer: D Vote an answer

Question #11

You just set up an application, and now you must assign security. The client informs you that they do not need to restrict access on a granular level.
Which data level approach should you take?

A. Security is only set on a granular level, so there is no need to assign access.

B. You can grant access to users on the entire application.

C. You can use a data grant and specify the portions of data within the model that can be accessed by users, groups or users and groups.

D. You can grant access to users on > dimension by dimension basis.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #12

How would a sample of the message "During August 2017"syntax display when you have added a static variable called, "CurrentMonth", into a doclet?

A. During "Current Month"

B. During &<<Current Month >>

C. During &"Current Month"

D. During <<Current Month>>

E. During 8Current Month

Discussion 0

Correct Answer: E Vote an answer

Question #13

Which step is NOT performed during the process of generating an XBRL Instance Document?

A. Validate individual doclets.

B. Validate Master document.

C. Generate and export the instance document for filing.

D. Review and modify any mappings.

E. Rearrange Doclets up or down with arrow key.

Discussion 0

Correct Answer: B Vote an answer

Question #14

Which statement is FALSE about the Review Phase?

A. When a Review Cycle is commenced, notifications are sent to Reviewers to begin their work.

B. Optionally Reviewers can send Doclets containing review comments back to the Doclet Authors to edit the Doclet based on the review comments.

C. Reviewers can review report content, modify content, and add comments to the document.

D. When Reviewers have finished adding comments, they mark their reviews complete.

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 1z0-985 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z0-985 exam.