Oracle 1Z0-960 Online Practice Questions and Exam Preparation

Oracle 1Z0-960 Online Questions & Answers

• Question 1:

  Your customer wants to prevent their department managers from viewing the results of other departments where they have no management authority.

  What should be implemented for this type of security?

  A. Data Access Sets
  B. Cross-Validation Rules
  C. Segment Value Security
  D. Role-Based Access
  C. Segment Value Security

• Question 2:

  You operate in a country whose unstable currency makes it unsuitable for managing your day-to-day business. As a consequence, you need to manage your business in a more stable currency while retaining the ability to report in the unstable local currency.

  What would be your recommendation when defining ledgers?

  A. Define Balance-Level Reporting Currencies in the more stable currency and run Translation as often as you need.
  B. Use Journal-Level or Subledger-Level Reporting Currencies denominated in the more stable currency.
  C. Run Revaluation as often as you need to the more stable currency and report on the more stable currency'sbalances.
  D. Create a secondary ledger that uses a different chart of accounts that is denominated in the more stable currency.
  B. Use Journal-Level or Subledger-Level Reporting Currencies denominated in the more stable currency.

  ---

  Reference:

  http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e20374/F484499AN16AFA.htm

• Question 3:

  You want to process multiple allocations at the same time. What feature do you use?

  A. RuleSets
  B. Point of View (POV)
  C. Formulas
  D. General Ledger Journal entries
  C. Formulas

• Question 4:

  Your company has complex consolidation requirements with multiple general ledger instances. You are using Oracle Hyperion Financial Management to consolidate the disparate General Ledgers. You can typically map segments between your general ledger segment to a Hyperion Financial Management segment, such as Company to Entity, Department to Department, and Account to Account.

  What happens to segments in your source general ledger, such as Program, that cannot be mapped Hyperion Financial Management?

  A. The data is not transferred.
  B. Data is summarized across segments that are not mapped to Hyperion Financial Management
  C. Errors occur for unmapped segments. You must map multiple segments from source general ledgers to the target segment in Hyperion Financial Management.
  D. The unmapped segments default to future use segments in Hyperion Financial Management
  C. Errors occur for unmapped segments. You must map multiple segments from source general ledgers to the target segment in Hyperion Financial Management.

• Question 5:

  You want to prevent intercompany transactions from being entered during the last day of the close.

  What should you do?

  A. Close all subledger periods.
  B. Close Intercompany periods in Fusion Intercompany.
  C. Freeze the Intercompany Journal source in General Ledger.
  D. Close the General Ledger period in the Manage Accounting Periods page.
  B. Close Intercompany periods in Fusion Intercompany.

• Question 6:

  You customer is a financial Institution that needs to maintain overage daily balances (ADB).

  Which two statements are true regarding this functionality in Fusion Applications?

  A. ADB provides organizations with the ability to track average and end-of-day balances, reportaverage balance sheets, and create custom reports using both actual and average balances.
  B. Average balances are stored for both subledger balances and general ledger balances.
  C. Average balances are stored in the Essbase cube.
  D. Average balances are maintained for both actual and budget balances.
  E. When using ADB, you must define a daily calendar and assign it to your ADB ledger.
  A. ADB provides organizations with the ability to track average and end-of-day balances, reportaverage balance sheets, and create custom reports using both actual and average balances.
  D. Average balances are maintained for both actual and budget balances.

• Question 7:

  You are defining an income statement report. You want to allow viewers of the report to be able to drill down from report balances to the underlying transactions. What do you need to enable?

  A. Drill Through in Grid Properties
  B. Report Functions
  C. Nothing. All report balances are drillable in all FR Studio reports.
  D. Allow Expansion
  D. Allow Expansion

• Question 8:

  What are the tables or views from which the Create Accounting program takes source data that is used in rules to create journal entries?

  A. Transaction Objects
  B. Event Entities
  C. Mapping Sets
  D. Accounting attributes
  E. Event Classes
  A. Transaction Objects

  ---

  Reference:

  https://docs.oracle.com/cd/E18727_01/doc.121/e13420/T193592sdextchap.htm

• Question 9:

  Which two types of journals can be automatically routed through the journal approval process?

  A. Allocation journals
  B. Revaluation journals
  C. Manual journals
  D. Sub ledger journals
  E. Journals imported from third-party systems
  C. Manual journals
  E. Journals imported from third-party systems

• Question 10:

  You are reconciling your subledger balances and you need a report that includes beginning and ending account balances and all transactions that constitute the account's activities.

  What type of report will provide this type of information?

  A. An Online Transactional Business Intelligence (OTBI) report to create ad hoc queries on transactions and balances
  B. Account Analysis Reports
  C. Journals Reports
  D. Aging Reports
  C. Journals Reports