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?

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?

Accepted Answer

D. SET LIST_SIZE = MAX_CARDINALITY(RECENT_CALLS)

Answer

A. SET LIST_SIZE = MAX(RECENT_CALLS)

Answer

B. SET LIST_SIZE = ARRAY_MAX(RECENT_CALLS)

Answer

C. SET LIST_SIZE = ARRAY_LAST(RECENT_CALLS)

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…