IBM
C2090-312 · Question #151
C2090-312 Question #151: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-312 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.
Question
You have defined the array type PHONENUMBERS using the following DDL: CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50]; You also defined a variable named RECENT_CALLS based on this new array type as follows: CREATE VARIABLERECENT_CALLS PHONENUMBERS: Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?
Options
- ASET LIST_SIZE = MAX(RECENT_CALLS)
- BSET LIST_SIZE = ARRAY_MAX(RECENT_CALLS)
- CSET LIST_SIZE = ARRAY_LAST(RECENT_CALLS)
- DSET LIST_SIZE = MAX_CARDINALITY(RECENT_CALLS)
Unlock C2090-312 to see the answer
You've previewed enough free C2090-312 questions. Unlock C2090-312 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.