How do Dynamic Repository Variables differ from Static Repository Variables?
A.
Dynamic Repository Variables are not initialized by the Initialization Block.
B.
Dynamic Repository Variables cannot be used in the Expression Builder.
C.
Dynamic Repository Variables can be changed by data that is returned from queries.
D.
Dynamic Repository Variables cannot be used in a CASE statement.
Explanation:
Dynamic Repository Variables:
You initialize dynamic repository variables in the same way as static variables, but the values are
refreshed by data returned from queries. When defining a dynamic repository variable, you will
create an initialization block or use a pre-existing one that contains a SQL query. You will also set
up a schedule that the Oracle BI Server will follow to execute the query and periodically refresh
the value of the variable.
Note: The value of a static repository value is initialized in the Variable dialog box. This value
persists, and does not change until an Oracle BI Administrator decides to change it.
C
static repository variable keep the initialized value till the administrator makes change with it.
Dynamic repository variable vary each time the query defined in the Initialization Block return varied value.