Oracle 1Z0-200 Online Practice Questions and Exam Preparation

Oracle 1Z0-200 Online Questions & Answers

• Question 101:

  In the Exhibit view the organization structure. The MO: Top Reporting Level is set to Set of Books.

  Paul is an Oracle Applications user. He is connected to a responsibility that is linked to the Western Division operating unit.

  What are his reporting options?

  

  A. He cannot submit a report at the Operating Unit level.
  B. He can submit a report at the Set of Books level, Legal Entity level, and Operating Unit level.
  C. He can submit a report at the Legal Entity level only and can choose the U.S. Legal Entity or the Canada Legal Entity as the reporting context.
  D. He can submit a report at the Set of Books level only and the reporting context automatically defaults and is restricted to the U.S. Set of Books.
  B. He can submit a report at the Set of Books level, Legal Entity level, and Operating Unit level.

• Question 102:

  Which two options would you use to restrict the functionality provided by a responsibility? (Choose two.)

  A. creating an appropriate role
  B. creating an appropriate group
  C. constructing a new menu hierarchy
  D. defining rules to exclude specific functions
  C. constructing a new menu hierarchy
  D. defining rules to exclude specific functions

• Question 103:

  Identify three correct statements of a multi-org setup. (Choose three.)

  A. A Government Reporting Entity (GRE)/Legal Entity can point to one and only one Set of Books.
  B. Inventory Orgs can be associated directly with a GRE/Legal Entity.
  C. The creation of a Master Inventory organization is mandatory.
  D. One and only one Operating Unit can be associated with a GRE/Legal Entity.
  E. One Set of Books can have one or many GRE's/Legal Entities associated with it.
  A. A Government Reporting Entity (GRE)/Legal Entity can point to one and only one Set of Books.
  C. The creation of a Master Inventory organization is mandatory.
  E. One Set of Books can have one or many GRE's/Legal Entities associated with it.

• Question 104:

  ABC Corp. decides to implement Oracle Receivables, Oracle Payables, and Oracle Purchasing.

  To access any of these applications, a user must be given access to a responsibility associated with which of the following type of organization?

  A. a Legal Entity
  B. an Inventory Org
  C. an Operating Unit
  D. an Asset organization
  C. an Operating Unit

• Question 105:

  ABC Corp. is implementing 11i Oracle Applications. The company has two local administrators in separate locations. They need to ensure that only a relevant set of users is visible to each of these local administrators.

  Which action will meet the requirement?

  A. create a separate role for each local administrator
  B. specify user administration privileges in Oracle User Management
  C. use Data Security to provide relevant access to each local administrator
  D. use Function Security to provide relevant access to each local administrator
  B. specify user administration privileges in Oracle User Management

• Question 106:

  Which two statements are correct regarding a table-validated value set? (Choose two.)

  A. It does not provide a predefined list of values.
  B. You use a table-validated value set when you have a set of values that is already maintained in an application table.
  C. You cannot define a table that you want to use when defining the table-validated value set
  D. You can use a SQL query to retrieve all the approved values from the table when defining the table-validated value set.
  B. You use a table-validated value set when you have a set of values that is already maintained in an application table.
  D. You can use a SQL query to retrieve all the approved values from the table when defining the table-validated value set.

• Question 107:

  As a system administrator for 11i Oracle Applications, which two actions can you perform on user passwords? (Choose two.)

  A. set the initial password
  B. change an existing password
  C. see the password that was chosen by the user
  D. set varying minimum lengths of passwords for different users
  A. set the initial password
  B. change an existing password