Online Access Free 1Z0-1079-21 Practice Test

What must you do in order to export data from the CONTACT table, so that the data only includes contacts with email addresses ending with "@oracle.com"?

• A.Create a CSVUTIL file that specifies the "@oracle.com" qualifier.
• B.Export the data first, and then use software such as MS Excel, MS Access, or direct SQL to filter the data.
• C.Use the "Where" clause on the CSV Export screen to specify the "@oracle.com" qualifier.
• D.The CSV utility is useful for managing large amounts of data, but it is not capable of filtering data during the export process.

Your customer has implemented OTM and has a requirement to have a selected menu to be displayed separately.
How should youassign this to a user?

• A.Assign it in User Role ID.
• B.Assign it in User Preference and assign this preference to User.
• C.It is a customization that OTM does not support.
• D.Assign it via Manage User Access.

You've executed a CSV upload in which you have modified some existing records, and created some new records. There were noerrors during the upload. However, OTM is still retrieving only the old data, not the new data that was just uploaded.
Select the action that you can take to address this.

• A.Rerun the upload, this time making sure that you specify the "ii" command.
• B.You must reboot the database server in order to commit the changes.
• C.Rerun the upload, this time making sure that you specify the "uu" command.
• D.Rerun the upload, this time making sure that you specify the "dd" command.
• E.You should clear the OTM cache.

Which business object do you use to set up the details of the classification data that you want to download and configure how it is mapped from the content provider's data to the Global TradeManagement (GTM) data structure?

• A.External System
• B.Data Load Type
• C.Product Classification Category
• D.Content Source

Select the three correct statementsregarding Freight Settlement in OTM. (Choose three.)

• A.Invoices in OTM must be tied to a shipment.
• B.Rules for matching, approval, and allocation are the cornerstones of automation in Freight Settlement.
• C.Freight Invoices may be created within OTM orinterfaced from an external system.
• D.Invoice checks may be printed out of OTM.
• E.Freight Settlement in OTM may be used to pay invoices to carriers as well as bill customers for freight.