Oracle 1Z0-218 Online Practice Questions and Exam Preparation

Oracle 1Z0-218 Online Questions & Answers

• Question 91:

  Which three statements describe the benefits of using tableset sharing in the PeopleSoft system? (Choose three.)

  A. Tableset sharing uses SetID to restrict or grant access to data within a table.
  B. Tableset sharing allows organizations to track and report business information.
  C. Tableset sharing enables organizations to group rows of data within a control table by using a high-level key called a SetID.
  D. Tableset sharing uses Department ID in conjunction with department security tree to restrict or grant access to data within a table.
  E. Tableset sharing enables organizations to utilize indexing capabilities on mapped records for faster search results on employee data.
  F. Tableset sharing enables organizations to share information instead of entering it multiple times, when large portions of data are the same for various business units.
  A. Tableset sharing uses SetID to restrict or grant access to data within a table.
  C. Tableset sharing enables organizations to group rows of data within a control table by using a high-level key called a SetID.
  F. Tableset sharing enables organizations to share information instead of entering it multiple times, when large portions of data are the same for various business units.

• Question 92:

  Your organization is using Tree-based data permission security. How many department security trees must you create?

  A. none
  B. one tree
  C. one tree for every unique Department
  D. one tree for every unique Business unit
  E. one tree for every unique Regulatory region
  F. one tree for every unique SetID of the Department table
  F. one tree for every unique SetID of the Department table

• Question 93:

  You are at your client site working on PeopleSoft HRMS implementation. One of your tasks is to add systemwide defaults in order to save time when a user is entering information in transaction tables. Identify which field is NOT a default option in the Org Default by Permission List component.

  A. SetID
  B. Country
  C. Company
  D. To Currency
  E. Business Unit
  F. Compensation Frequency
  F. Compensation Frequency

• Question 94:

  Data permission is set up through Tree-based security. You have created a new effective- dated department security tree. Which batch process would you execute?

  A. Department Activation
  B. Refresh SJT_OPR_CLS
  C. Refresh SJT_CLASS_ALL
  D. RefreshTrans_SJT_tables
  E. Nightly_SJT_Refresh_Process
  F. Refresh tree using Tree Manager
  C. Refresh SJT_CLASS_ALL

• Question 95:

  Which table has to be set up before configuring Job Codes?

  A. SetID
  B. Location
  C. Company
  D. Pay Group
  E. Department
  F. Regulatory Region
  A. SetID

• Question 96:

  What should you do when system performance is affected and you no longer want to maintain all employee records on the Job table?

  A. Purge employee data from the system.
  B. UsePeopleCode to hide data on the Job Data page.
  C. Access the Job Data page in Correct History mode and change the status to Inactive.
  D. Insert a new effective dated row on the Job Data page and change the status to Inactive.
  E. Change the description field on the Job Data page to state that this row is no longer active.
  A. Purge employee data from the system.

• Question 97:

  Your client has set up two companies, ABC in Country A and DEF in Country D Your client has also set up several business units based on company and service lines. To reduce the data redundancy, your client has implemented one shared SetID across business units so that the majority of table values can be shared across the organization. However, your client has two separate salary administration plans that are specific to employees in each country. You have created two SetIDs, DEF01 and ABC01, to be used as high-level key for the new Salary Plans that you are going to create. What should you do next before you can set up the Salary Administration Plans for this client?

  A. Go to the Company table,change ABC's SetID to ABC01 and DEF's SetID to DEF01.
  B. Go to Business Units Options Defaults table,change the SetID to DEF01 for Business Units in Country D and to ABC01 for Business Units in Country A.
  C. Go toTableSet Control table, change the SetID for Record Group HR_05 Plan Salaries to DEF01 for Business Units in Country D and to ABC01 for Business Units in Country A.
  D. Go to Org Defaults by PermissionLst table, bring up the primary permission list and associate the Business Units in Country D with SetID DEF01 and Business Units in Country A with SetID ABC01.
  C. Go toTableSet Control table, change the SetID for Record Group HR_05 Plan Salaries to DEF01 for Business Units in Country D and to ABC01 for Business Units in Country A.

• Question 98:

  Select four statements that are true about Record Groups and how they are set up. (Choose four.)

  A. Using Record Groups limits you to oneSetID for a Business Unit.
  B. Using Record Groups does not limit you to oneSetID for a Business Unit.
  C. You cannot modify theSetID for Record Groups to share or restrict data.
  D. Mapping of Business Units toSetIDs is done in the TableSet Control component.
  E. Record Groups ensure thatTableSet Sharing is applied consistently across all related tables and views in your system.
  F. Mapping aSetID to a Record Group for a Business Unit links this same SetID to all views and tables that are contained within a Record Group.
  B. Using Record Groups does not limit you to oneSetID for a Business Unit.
  D. Mapping of Business Units toSetIDs is done in the TableSet Control component.
  E. Record Groups ensure thatTableSet Sharing is applied consistently across all related tables and views in your system.
  F. Mapping aSetID to a Record Group for a Business Unit links this same SetID to all views and tables that are contained within a Record Group.

• Question 99:

  While you are entering a new hire into Job Data, you come to the Salary Plan page. You notice that the Salary Step field is populated. From which table did the default value come from?

  A. Location
  B. Job Code
  C. Paygroup
  D. Company
  E. Department
  B. Job Code

• Question 100:

  When hiring a person using the template-based hire feature, you choose the Save for Later option. What is the hiring status that is assigned to the transaction?

  A. Draft
  B. Pending Hire
  C. Save for Later
  D. Hire in Progress
  A. Draft