IBM

C2090-610 · Question #54

Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

The correct answer is C. SALES can be the name of an existing alias. See the full explanation below for the reasoning.

Question

Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

Options

ASALES can be the name of a schema.
BSALES can be the name of a package.
CSALES can be the name of an existing alias.
DSALES can be the name of a declared global temporary table.

How the community answered

(29 responses)

A
3% (1)
B
10% (3)
C
83% (24)
D
3% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-610 Practice