Oracle 1Z0-202 問題集

質問 1：
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. IS LIKE (Mar?iot?)
B. IS LIKE (Mar*iot*)
C. Mar?iot?
D. Mar?iot?*
E. Mar*iot*
正解：E

質問 2：
You are creating a new view in Siebel Tools. When you attempt to add applets, you do not see the applet you want to add listed in the Available Applets list. Which two would cause this? (Choose two.)
A. You failed to assign a Project.
B. You selected the wrong Business Object for the view.
C. The applet object definition has Inactive set to FALSE.
D. The Business Component that the applet is based on is not part of the Business Object the view is based on.
E. You picked the wrong Web Template.
正解：B,D

質問 3：
View the Exhibit.
On the Opportunity business component, what should the Join Specification look like when you are joining to the S_ORG_EXT table to access account information such as NAME?

A. Destination Column = PAR_ROW_ID and Source Field = Id
B. Destination Column = NAME and Source Field = Account Name
C. Destination Column = PAR_ROW_ID and Source Field = Account Id
D. There is no explicit Join or Join Specification.
E. Destination Column = ROW_ID and Source Field = Id
正解：C

質問 4：
Your business model requires that you change the Job Title for contacts to be a required field. Select the true statement.
A. Existing contacts whose Job Title is NULL will be visible only in the contacts administration screen.
B. You specify the Job Title field as required by setting the Required flag to TRUE in the appropriate business component.
C. You must modify the JOB_TITLE column of the S_CONTACT table to make it non- nullable.
D. You specify the Job Title field as required by setting the Required flag to TRUE in the appropriate applet(s).
E. You cannot copy records whose Job Title is NULL.
正解：B

質問 5：
Which statement is true of Master data?
A. includes dynamic, transactional data
B. is created and managed by end-users of the application
C. cannot be grouped into catalogs and categories
D. access is controlled at the level of catalog and category
正解：D

質問 6：
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. Validate there is a foreign key to the Industry business component main table on the S_ORG_INDUST table.
C. Create a new foreign key on S_INDUST that points to S_ORG_EXT.
D. Validate there is a foreign key on the Industry business component main table that points to the S_ORG_EXT table.
E. Validate there is a foreign key on S_ORG_EXT that points to the Industry business component main table.
正解：E

質問 7：
You want to add a business service step to a workflow. Which three are steps that you might perform to configure the business service step? (Choose three.)
A. create input arguments by right-clicking the business service step and selecting Show Input Arguments
B. create additional process properties
C. create one or more output argument records for the business service and set the type to Business Service
D. assign a value to the Business Service Name property
E. assign a default value to the Object Id process property
F. assign a value to the Business Service Method property
正解：B,D,F

質問 8：
Why are implicit joins used for joining party data?
A. Implicit joins are not used with party data.
B. To bring party data into a non-party business component.
C. To bring party data into another party business component.
D. To map columns in party extension tables to party business components.
正解：D

質問 9：
Which two statements are true about using the Table wizard to create a new intersection table between two non-party tables? (Choose two.)
A. The new table will have type setting of Data (Intersection)
B. The parent tables must have a type set to Data (Intersection)
C. The new table will include two foreign key columns
D. The new table will include a PAR_ROW_ID column
正解：A,C