Oracle Oracle Certifications 1Z0-510 Questions & Answers

• Question 81:

  You are creating a primary table and an auxiliary table for an Item descriptor in the versioned schema. What are the properties that must be added to the tables?

  A. You only need to add asset_version to both the tables.

  B. You need to add asset_version to both the tables. in addition, the primary table required seven other columns, such as version_editable, version_deleted, etc.

  C. You need to add asset_version to both the tables. in addition, the auxiliary table requires seven other columns, such as version_editable, version_deleted, etc.

  D. You need to add asset_version and seven other columns, such as version_editable, version deleted to both the tables.

  E. You need to add asset, version to the primary table and seven columns, such as version_editable, version deleted, etc. to the auxiliary tables.

  F. You need to add seven columns, such as version_editable, version deleted, etc. to the primary table and only asset_version to the auxiliary table.

  Correct Answer: B

  Create and Install the Versioned Database Schema

  In order to store asset version metadata, the asset management server's database schema requires additional columns for the primary tables used by your application's repositories, and additional tables to store versioning information.

  Create the Versioned Schema

  To modify the asset management server's database schema to store versioning data, follow these steps:

  1.

  Copy each database DDL file that you plan to modify.

  2.

  Add the following columns to every table that represents a primary table for an item descriptor:

  asset_version INT NOT NULL workspace_id VARCHAR(40) NOT NULL branch_id VARCHAR(40) NOT NULL is_head NUMERIC(1) NOT NULL version_deleted NUMERIC(1) NOT NULL version_editable NUMERIC(1) NOT NULL pred_version INT NULL checkin_date TIMESTAMP NULL

  3.

  Add the following column to every table that represents an auxiliary or multi table in an item descriptor: asset_version INT NOT NULL

• Question 82:

  What is the reanimated order?

  A. INCOMPLETE orders that have not been checked out by customers and instead have remained idle for a duration of time

  B. Previously abandoned orders that have since been modified by the customer in some way, such as adding items or changing item quantities.

  C. Previously abandoned orders that have been successfully checked out by the customer.

  D. Abandoned orders that have been abandoned for so long that reanimation of the order is no longer considered realistic.

  Correct Answer: B

  Reanimated orders

  Previously abandoned orders that have since been modified by the customer in some way, such as adding items or changing item quantities.

• Question 83:

  How many current and saved orders does ATG allow a user profile to have?

  A. ATG allows one current order and one saved order per user profile.

  B. ATG allows one current order and a collection of saved orders per user profile.

  C. ATG allows multiple current orders and a collection of saved orders per user profile.

  D. Only one order can exist for a Give user profile in ATG. There is no support for saved orders.

  Correct Answer: B

  Note: loadShoppingCarts

  public void loadShoppingCarts(RepositoryItem pProfile,

  OrderHolder pShoppingCart)

  throws CommerceException

  Parameters:

  pProfile - the user profile

  pShoppingCart - the OrderHolder component for this user Throws:

  CommerceException - is any errors occur while loading the shopping carts

  This method finds all the shopping carts for the user and places them into the session-scope OrderHolder component. "Shopping Carts" are defined to be orders whose state is INCOMPLETE. The orders are sorted by last activity date, and

  the last order touched is made the current order. This method will optionally merge the current shopping cart for the session (from the OrderHolder.current property) with the first persistent order loaded from the database. This functionality is

  toggeled through the mergeOrders property of this form handler. NOTE: This method used to acquire a transaction lock, but we've found deadlock issues and have decided to remove the locks. See bug 146012. This method now performs its

  actions without a lock.

• Question 84:

  What is the role of the allocateItemRelQuantity chain?

  A. to mark Shipping group as shipped

  B. to purchase items from pre-order, back order, or regular stock using inventory

  C. to reorganize Items across shipping groups

  D. to allocate items related to the quantity on hand

  Correct Answer: B

  Note: The allocateItemRelQuantity chain is executed when called by the allocateItemRelationship chain.

  allocateItemRelQuantityChain This processor executes the allocateItemRelQuantity chain. After execution, execution of this chain then stops. Transactional mode: TX_MANDATORY Nucleus component: /atg/commerce/fulfillment/processor/AllocateItemRelQuantityChain PipelineProcessor object: atg.commerce.pricing.processor.ProcSendScenarioEvent Transitions: None. This is the last link in the chain and causes the PipelineManager to return to the caller.

• Question 85:

  Which three reasons justify why customers should choose Oracle ATG Web Commerce as their cross channel commerce platform?

  A. It is the most complete and integrated e-commerce solution in the market.

  B. It has the most flexible, modular, and elegant architecture compared to other competing solutions.

  C. It features production-ready reference applications that can be easily customized to meet your application requirements.

  D. It is the easiest platform to implement a compared e-commerce solution in the market.

  E. It has the best online merchandising business tools and applications of all competing solutions.

  Correct Answer: ABD

  A: To further enhance the customer experience, Oracle offers an integrated set of software-as-a-service (SaaS) commerce services that provide the flexibility and intelligence to target the right visitors at the right time with the right offer in the right channel to drive high-value sales. Through these services, your company can engage with customers at the point of interaction through personalized recommendations, targeted promotions, and guided assistance.

  B: Because it's built on a flexible, component-based e-commerce software architecture, ATG Web Commerce is an easily implemented best-in-class commerce solution that increases revenue, improves customer service, helps companies achieve maximum, long-term business growth, and is available as either a licensed solution or hosted on-demand solution.

  D: Oracle's ATG Web Commerce Applications

  Oracle's ATG Web Commerce is the industry's top-ranked commerce solution that powers the world's best brands, and delivers a consistent, personalized cross-channel customer experience. ATG Web Commerce offers a complete commerce software platform that enables you to deliver a personalized customer buying experience across all customer touchpoints, including the web, contact center, mobile devices, social media, physical stores, and more.

• Question 86:

  Which two ASE tasks can be performed from the ACC but not the BCC?

  A. creating a custom product catalog

  B. creating targeters

  C. creating scenarios

  D. creating slots

  E. creating products and SKUs

  Correct Answer: CD

  Scenarios, slots, and workflows are not managed through the ATG Business Control Center (BCC). To create and edit these items, use the ATG Control Center (ACC)

  D: You can create slot components in two ways:

  By manually creating a .properties file

  Through the slot wizard in the ACC.

  Note ACC: ATG Control Center.

  Note BCC: The ATG Business Control Center is a browser-based interface that you use to create and edit many of the elements required to set up and maintain an ATG-based Web site