You colleague created a list item that will be populated at run time by the JOBS Record Group. JOBS is populated from the EMP table using one or more of the following three columns:
– SAL column, whose data type is number
– TITLE column, whose data type is varchar2
– JOB column, whose data type is varchar2
Assuming that any variables used are properly declared, which built-ins can you to create JOBS?
A.
RETRIVE_LIST(list_id, ‘JOBS’);
B.
POPULATE_GROUP_WITH_QUERY (‘JOBS’,
‘SELECT distinct initcap(job) as Job,’||
‘job as JOB from emp’);
C.
POPULATE_GROUP_WITH_QUERY (‘JOBS’,
‘SELECT initcap(title) as Job,’||
‘sal as Salary from emp’);
D.
rgid := CREATE_GROUP_FROM_QUERY (‘JOBS’,
‘SELECT distinct initcap(job) as Job ,’||
‘job as JOB from emp’);
E.
rgid := CREATE_GROUP_FROM_QUERY (‘JOBS’,
‘SELECT initcap(title)as Job.’||
‘sal as Salary from emp’ )
F.
rgid := CREATE_GROUP_FROM_QUERY (‘JOBS’,
‘SELECT distinct initcap(job) as Job,’||
‘job as JOB, sal as Salary from emp’);