Oracle 1Z0-976 Cloud Service Implementation Essentials Exam Set 2

An administrator tries to change the document views on an attribute from a participant profile on a given step. But the attribute is not listed in the list of attributes that are available for editing. What are two reasons for this behavior? (Choose two.)


Options are :

  • The attribute is not added to the layout.
  • The attribute is being referenced in an active Hiding rule.
  • The attribute is hidden on the Attribute Details page.
  • The attribute is a system attribute.
  • A,B

Answer : A,B

Which two items are necessary to migrate between environments? (Choose two.)


Options are :

  • Administrators must have FullAccess logins for both environments
  • C,D
  • Environments must be on the same minor release (for example, 2016R2 update 2).
  • Entities to be migrated must be deployed within 24 hours of the migration.
  • Environments must be on the same major release (for example, 2016R2).
  • Environments must have similar urls (for example, testcustomer and devcustomer).

Answer : C,D

Consider the following requirements for integration with Salesforce: Transaction information needs to be pushed back to Salesforce and synchronized. You must be able to synchronize a transaction with up to 1,000 lines back to the Opportunity Product object in Salesforce. On the basis of these requirements, which three XSL sets should you use to provide the integration? (Choose three.)


Options are :

  • SFDC Products – Upset All (200, 400, 600, 800, 1000)
  • SFDC Quote – Upset
  • SFDC Opportunity – Upload
  • SFDC Opportunity – Import
  • SFDC Quote – Process Updates

Answer : SFDC Products – Upset All (200, 400, 600, 800, 1000)

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 7

How can action buttons be hidden in Commerce?


Options are :

  • by using profiles and steps in Commerce
  • by putting the action button bar on a hidden tab in Commerce
  • by using Commerce hiding rules
  • by using Configuration hiding rules

Answer : by using Commerce hiding rules

For a multi-language Document Designer template, which of the following two activities are possible for the nondefault language view? (Choose two.)


Options are :

  • Add or remove table element’s rows and columns.
  • Modify date and currency formats.
  • A,E
  • Move text elements between elements and layouts
  • Add new image element in a section
  • Change text content.

Answer : A,E

When creating a connection for a CPQ SOAP Endpoint in ICS, which format is expected?


Options are :

  • https:///ics/catalog
  • https://
  • https:///v2_0/receiver/commerce/oraclecpqo?WSDL
  • https:///v1/receiver?WSDL

Answer : https:///v2_0/receiver/commerce/oraclecpqo?WSDL

1Z0-520 Oracle EBS R12 Purchasing Essentials Practice Exam Set 4

A multi-select attribute with five options is displayed as check boxes. Depending on the conditions, the Configurator should show a user three of these five options. How do you accomplish this?


Options are :

  • by writing a Pricing rule
  • by writing a Constraint rule
  • by writing a Recommendation rule
  • by writing a Hiding rule

Answer : by writing a Hiding rule

What is the correct navigation path to create Account Integrations?


Options are :

  • Admin > Accounts >Add >Integration
  • Admin > Accounts > Import >Integration > Add
  • Admin > Process Definition > Integrations > List > Add
  • Admin > Accounts > Integration > Add

Answer : Admin > Accounts > Integration > Add

When using Web Services 1.0, consider the following sequence of a client system calling CPQ Cloud WebServices. 1. Call Security Login WebServices with User ID and Password. 2. Create a Commerce update Transaction WebServices call by using an existing transaction ID. 3. Make the following updates in the web service XML: Set Session ID. Set “_shipTo_first_name” to “myName” 4. Submit the WebService call. 5. Call Security Logout WebServices with the Session ID to close the session. Based on the given sequence, which two statements are true? (Choose two.)


Options are :

  • The Commerce transaction should be updated with the new Ship To name.
  • The call in step 4 will throw an error
  • The session will still be open.
  • Step 5 is unnecessary. Session ID is not needed to log out
  • A,D
  • Step 3 does not specify an action to execute; therefore, nothing is updated in the transaction

Answer : A,D

1Z0-520 Oracle EBS R12 Purchasing Essentials Practice Exam Set 4

Which three discount types are available in pricing? (Choose three.)


Options are :

  • absolute price
  • percent discoun
  • quantity-dependent discount
  • amount discount
  • A,D,E
  • promotion discount

Answer : A,D,E

Identify two standard ways to modify the overall integration behavior of CPQ Cloud and Salesforce. (Choose two.)


Options are :

  • Write a custom BML Util library function in CPQ Cloud.
  • Use the integration XSLs within the Commerce process to modify integration behavior at the object and field levels
  • Use the Site Setup object and CPQ Cloud Commerce Package settings in Salesforce to meet varying customer requirements
  • A,C
  • Write a Salesforce API to change integration behavior in CPQ Cloud.

Answer : A,C

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 17

Identify two ways in which you can display a message to a user while using simple table-based lookups for an attribute. (Choose two.)


Options are :

  • B,D
  • defining a static text message for that attribute
  • setting the message type as Static Entry when selecting an attribute to populate
  • setting the message type as Table Column when selecting an attribute to populate
  • defining an advanced BML (CPQ Cloud Language) function for that attribute

Answer : B,D

Identify the three data types available for part custom fields. (Choose three.)


Options are :

  • “Multi Select menu”
  • “Float,” can be changed to “Integer”
  • “Currency”
  • “Date,” can include time
  • “String,” can be changed to “Single Select Menu”
  • B,D,E
  • “Boolean”

Answer : B,D,E

Which attribute type cannot be displayed on the line item grid?


Options are :

  • Single-select menu attributes
  • HTML attributes
  • Currency attributes
  • Text attributes

Answer : Text attributes

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 6

The Related Parts data table exists in the QA environment and in the production environment. The table has 3,000 records in the QA environment and 4,000 records in the production environment. How many records will be present in the data table in the production environment if this table is migrated from the QA environment?


Options are :

  • 3,000
  • 7,000
  • 4,000
  • 1,000

Answer : 4,000

When designing an integration with an ERP system, you must communicate with a third party integration tool (such as a middleware or a hub). Which three methods can be used to communicate with a middleware in this scenario? (Choose three.)


Options are :

  • B,E,F
  • Commerce Integration XSLs on an Action
  • Send XML on a Transition Rule via Real Time Integration
  • Automated FTP
  • Formula Management
  • DataCube Reporting
  • Commerce Integration Cloud Service Integration on an Action
  • urldata function call in a Commerce Advanced Modification BML function

Answer : B,E,F

What is the correct method to add new parts data to the CPQ Cloud database?


Options are :

  • Use Bulk Upload to upload the data from the remote part system into a .csv file and import the file into the CPQ Cloud site.
  • Use the “Import from Source” function in the Migration Center to connect to the remote part system and upload the part data directly to the CPQ Cloud database.
  • Export the part data from your current part system into a .csv file, put the .csv file into a compressed zip file, and use Bulk Upload to upload the part data to the CPQ Cloud site.
  • Use the “Import from Source” function in the Migration Center to connect to the remote part system and upload the part data into a .csv file, put the .csv file in a compressed ZIP file, and use Bulk Upload to upload the part data to the CPQ Cloud site
  • Perform a bulk-downloaded of at least one part to capture the part file format that the CPQ Cloud site uses, populate the new part data into the downloaded part file (.csv file), enter “add” in the Update column for each new part, save the spreadsheet as a .csv file, put the .csv file in a compressed zip file, and use Bulk Upload to upload the part data to the CPQ Cloud site

Answer : Use the “Import from Source” function in the Migration Center to connect to the remote part system and upload the part data into a .csv file, put the .csv file in a compressed ZIP file, and use Bulk Upload to upload the part data to the CPQ Cloud site

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 3

Which three BOM Mapping Tables are required to map Configuration attributes to BOM items and Commerce Transaction Line attributes using a simple TableBased BOM Mapping Configuration rule? (Choose three.)


Options are :

  • BOM Attribute Translation
  • A,C,E
  • BOM Attribute Definition
  • BOM Item Definition
  • BOM Attribute Mapping
  • BOM Item Mapping

Answer : A,C,E

Which two scenarios can be automated with File Transfer Protocol (FTP)? (Choose two.)


Options are :

  • B,D
  • Every night, an administrator queries the inventory database and updates a CPQ Cloud data table with the new inventory levels.
  • Every month, an administrator needs to apply changes requested by the marketing department on descriptions for parts in CPQ Cloud.
  • An administrator needs to update Configuration Attribute Value Pricing on a Model and deploy the changes.
  • An administrator needs to bulk update attachments on a multiple Commerce Transactions.

Answer : B,D

In which two locations are the keywords for mobile processing of quotes defined when setting up approvals? (Choose two.)


Options are :

  • Mobile Approval Email Notification
  • Submit sub-action – Reject
  • Submit sub-action – Submit for Approval
  • Submit sub-action – Approve
  • B,C

Answer : B,C

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 4

Which format will datetostr (getdate()) return when no format is supplied?


Options are :

  • HH:mm:ss DD/mm/yyyy
  • DD/mm/yyyy HH:mm:ss
  • HH:mm:ss MM/dd/yyyy
  • MM/dd/yyyy HH:mm:ss

Answer : MM/dd/yyyy HH:mm:ss

Which two scenarios are valid for looping by using XSL Snippets? (Choose two.)


Options are :

  • The data in the line item grid must be displayed as a table
  • C,D
  • The data needs to be manipulated before being used in loop conditions.
  • You want to display a table of single-select, quote-level Commerce attributes
  • The grid selector cannot handle the conditions that you need to implement.

Answer : C,D

Along with Part Number, Quantity, and Price, you also want to send additional recommended item details from Configuration to Commerce by using a Recommended Item rule. Which two options enable you to achieve this? (Choose two.)


Options are :

  • Pass the additional details by storing them in a Price Book
  • A,E
  • Concatenate the additional details to Part Number.
  • Use the Comment field to pass additional details.
  • Use BOM Mapping rules.
  • This is not feasible. Only Part Number, Quantity, and Price can be passed from Config to Commerce by using Recommended Item rules.

Answer : A,E

1Z0-409 Oracle Linux Fundamentals Practice Exam Set 7

Which are three testing strategies for Oracle CPQ Cloud? (Choose three.)


Options are :

  • Perform isolated tests as well as intra-system and cross-system integration tests.
  • Avoid using a test case tracking tool because it is time consuming to track all of the testing team’s efforts
  • Create specific test data for accounts, opportunities, and contracts in the CRM system and use that data to perform end-to-end tests for CPQ Cloud quotes.
  • Test cases should be directly linked to business requirements.
  • B,C,D

Answer : B,C,D

Your customer wants to create a user that has complete access to the site and has the ability to add and edit new users. Which procedure should you follow to accomplish this?


Options are :

  • Click the Add button on the User Administration List page; enter values for the required fields (Login, Email, and First Name); set the Type field to FullAccess; click the Add button to add the user to the system; click the new user’s name on the User Administration List page to edit the user, select the Create/Modify Users check box; and click the Update button to save the changes.
  • Click the Add button on the User Administration List page; enter values for the required fields (Login, Email, and First Name); click the Add button to add the user to the system; click the new user’s name on the User Administration List page to edit the user; select the Create/Modify Users check box; and click the Update button to save the changes.
  • Click the Add button on the User Administration List page; enter values for the required fields (Login, Email, and First Name); set the Type field to FullAccess; select the Create/Modify Users check box, and click the Add button to add the user to the system.
  • Click the Add button on the User Administration List page; enter values for the required fields (Login, Password, Email, First Name, Last Name, and Phone Number); set the Type field to Admin; click the Add button to add the user to the system; click the new user’s name on the User Administration List page to edit the user; select the Add New Users check box; and click the Add button to save the changes.
  • Click the Add button on the User Administration List page, set the Type field to Admin, click the Add button to add the user to the system, click the new user’s name on the User Administration List page to edit the user, select the Create/Modify Users check box, and click the Update button to save the changes.

Answer : Click the Add button on the User Administration List page; enter values for the required fields (Login, Email, and First Name); set the Type field to FullAccess; select the Create/Modify Users check box, and click the Add button to add the user to the system.

A red “X” appears instead of a part (item) in a configuration. What causes this?


Options are :

  • The Recommended Item rule is not firing
  • The Recommended Item rule is recommending a part that does not exist.
  • The Recommended Item rule is recommending more than one-part number
  • The Recommended Item rule is recommending more than one-part number

Answer : The Recommended Item rule is recommending a part that does not exist.

Oracle 1Z0-207 Billing & Revenue Mgmt Pricing Practice Exam Set 7

Identify three values that you can find in the Usage Metrics Report for the last month. (Choose three.)


Options are :

  • The number of logins by internal users in the last 30 days and the percentage of active users logged in.
  • The total number of partner organizations and the number of active partner organizations
  • B,D,E
  • A list of active partner organization users with the most recent login date and time and the number of logins.
  • The number of configurations completed for different product families by internal users and partner organization users.
  • The number of transactions for different Commerce processes created by internal users and partner organization users.
  • The total data size of the CPQ site occupied on the server

Answer : B,D,E

Your users receive a notification for a transaction from CPQ when an approval has been retracted and is no longer needed. The notification contains a generic message about this action. However, users would like to get more details about the transaction. What is the Oracle-recommended best practice to fulfill this requirement in CPQ?


Options are :

  • When a transaction needs to be revised, allow the transaction owner to send a parallel email to approvers, which should include the necessary transaction details.
  • All of the above
  • Switch the system-generated email-to-email template, which will include the desired transaction information when approvers are notified.
  • Trigger an email action to notify users by custom defining the email’s subject and body, which contain the transaction details, by using the advanced function available in the Revise action.

Answer : Trigger an email action to notify users by custom defining the email’s subject and body, which contain the transaction details, by using the advanced function available in the Revise action.

Using standard functionality, how do you prevent a user from manually adding or removing rows in an array set?


Options are :

  • by hiding the control attribute
  • by selecting the “Disable user override” property on the configurable array set editor page
  • by hiding the control attribute and marking it as a forced set
  • by using CSS to hide icons

Answer : by hiding the control attribute

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 1

You want to perform a configuration migration from a development site to a QA site. What is the Oracle-recommended way to accomplished this?


Options are :

  • Using a DB Link, log in to the development site through the Migration Center section, select the components that need to be migrated, and start the migration
  • Open Migration Center in the QA site, log in to the development site through the Migration Center section, select the components that need to be migrated, and start the migration.
  • Open Migration Center in the development site, log in to the QA site through the Migration Center section, select the components that need to be migrated, and start the migration.
  • Download the components that need to be migrated from the development site and upload them to the QA site.

Answer : Open Migration Center in the QA site, log in to the development site through the Migration Center section, select the components that need to be migrated, and start the migration.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions