Oracle 1Z0-202 Online Practice Questions and Exam Preparation

Oracle 1Z0-202 Online Questions & Answers

• Question 81:

  Your requirement is to allow only one industry for a given Account. What would you do to start to meet the requirement?

  A. Create a new Industry table.
  B. Create a new foreign key on S_INDUST that points to S_ORG_EXT.
  C. Validate there is a foreign key on S_ORG_EXT that points to the Industry business component's main table.
  D. Validate there is a foreign key to the Industry business component's main table on the S_ORG_INDUST table.
  E. Validate there is a foreign key on the Industry business component's main table that points to the S_ORG_EXT table.
  C. Validate there is a foreign key on S_ORG_EXT that points to the Industry business component's main table.

• Question 82:

  Which three are valid candidates for assignment through assignment rules? (Choose three.)

  A. Positions
  B. Responsibilities
  C. Persons
  D. Organizations
  E. Accounts
  A. Positions
  C. Persons
  D. Organizations

• Question 83:

  Which statement is true of Customer data?

  A. includes static, referential data
  B. has access controlled at the record level
  C. can be grouped into catalogs and categories
  D. is created and managed by only company administrators
  B. has access controlled at the record level

• Question 84:

  You are cleaning up account data in the system. You know that your company maintains several different Marriott accounts such as Marriott, Marriott Europe, and Marriott Asia. All such accounts should start with the word Marriott, Unfortunately, users have used these different spellings for the accounts: Marriott Marriot Mariott and Mariot

  Which query would you enter to query for all such accounts?

  A. Mar?iot?
  B. Mar?iot?*
  C. Mar*iot*
  D. IS LIKE (Mar?iot?)
  E. IS LIKE (Mar*iot*)
  C. Mar*iot*

• Question 85:

  You have populated millions of products in your test system and you are ready to move them to your production system. Which would you use?

  A. Update Server
  B. Assignment Management
  C. Enterprise Integration Manager (EIM)
  D. Application Deployment Manager (ADM)
  C. Enterprise Integration Manager (EIM)

• Question 86:

  What is the primary difference between an organization and a division?

  A. Divisions can be deleted, organizations cannot.
  B. Organizations can be deleted, divisions cannot.
  C. Positions are assigned to organizations, and not divisions.
  D. Organizations are used for Access Control, divisions are not.
  D. Organizations are used for Access Control, divisions are not.

• Question 87:

  What does Enterprise Integration Manager use to prevent duplication of records during processing?

  A. Primary keys
  B. Foreign keys
  C. User keys
  D. Indexes
  C. User keys

• Question 88:

  In Server Administration, what does the Delete Parameter Override feature allow you to do?

  A. Delete the inherited parameter and input a new parameter.
  B. Use the current parameter on all levels higher than the current level.
  C. Remove the current parameter and reinstate parameter inheritance.
  D. Override the current parameter for the next single instance of the component.
  C. Remove the current parameter and reinstate parameter inheritance.

• Question 89:

  You wish to create a M:M relationship between contacts and colleges attended, to be displayed in both a Contacts-Colleges view and in a Colleges-Contacts view. You decide to implement this by first creating a stand-alone CX_COLLEGE table.

  What will you also need to create? (Choose all that apply.)

  A. A Contact/College link.
  B. A College/Contact link.
  C. A College business object.
  D. A College business component.
  E. A join between S_CONTACT and CX_COLLEGE.
  F. An intersection table between S_CONTACT and CX_COLLEGE.
  A. A Contact/College link.
  B. A College/Contact link.
  C. A College business object.
  D. A College business component.
  F. An intersection table between S_CONTACT and CX_COLLEGE.

• Question 90:

  Your business model requires that you change the Job Title for contacts to be a required field.

  Select the true statement.

  A. You cannot copy records whose Job Title is NULL.
  B. You must modify the JOB_TITLE column of the S_CONTACT table to make it non-nullable.
  C. Existing contacts whose Job Title is NULL will be visible only in the contacts administration screen.
  D. You specify the Job Title field as required by setting the Required flag to TRUE in the appropriate applet(s).
  E. You specify the Job Title field as required by setting the Required flag to TRUE in the appropriate business component.
  E. You specify the Job Title field as required by setting the Required flag to TRUE in the appropriate business component.