Select the SQL statement that corresponds to the record definition.
A.
SELECT A.PRODUCT_ID, A.CUSTOMER, B.DESCR, A.PLATFORM,
A.PRODUCTION_STATUSFROM PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE
A.CUSTOMER_ID = B.CUSTOMER_ID
Field definitions can have multiple labels.
B.
SELECT A.PRODUCT, A.CUSTOMER_ID, B.DESCR, A.PRODUCTION_STATUSFROM
PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE A.CUSTOMER_ID =
B.CUSTOMER_ID
Some field definition properties can be changed only with PeopleCode.
C.
SELECT A.PRODUCT, A.CUSTOMER_ID, B.DESCR, A.PLATFORM,
A.PRODUCTION_STATUSFROM PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE
A.CUSTOMER_ID = B.CUSTOMER_ID
Modifying a field definition automatically alters all tables in which the field occurs.
D.
SELECT A.PRODUCT, A.CUSTOMER_ID, B.DESCR, A.PLATFORM,
A.PRODUCTION_STATUSFROM PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE
A.CUSTOMER_ID = A.CUSTOMER_ID
After you save a field definition, you cannot change the data type without deleting the field.
A.
SELECT A.PRODUCT_ID, A.CUSTOMER, B.DESCR, A.PLATFORM,
A.PRODUCTION_STATUSFROM PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE
A.CUSTOMER_ID = B.CUSTOMER_ID
Field definitions can have multiple labels.
B.
SELECT A.PRODUCT, A.CUSTOMER_ID, B.DESCR, A.PRODUCTION_STATUSFROM
PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE A.CUSTOMER_ID =
B.CUSTOMER_ID
Some field definition properties can be changed only with PeopleCode.
C.
SELECT A.PRODUCT, A.CUSTOMER_ID, B.DESCR, A.PLATFORM,
A.PRODUCTION_STATUSFROM PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE
A.CUSTOMER_ID = B.CUSTOMER_ID
Modifying a field definition automatically alters all tables in which the field occurs.
D.
SELECT A.PRODUCT, A.CUSTOMER_ID, B.DESCR, A.PLATFORM,
A.PRODUCTION_STATUSFROM PS_PSU_CUST_PROD A, PS_PSU_CUST_TBL BWHERE
A.CUSTOMER_ID = A.CUSTOMER_ID
After you save a field definition, you cannot change the data type without deleting the field.
E.
Field definitions are stand-alone definitions that do not need to be associated with record
definitions.
Explanation:
QUESTIONNO: 57
Select the three correct statements about PeopleSoft field definitions. (Choose three.)