Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?
A.
SALES can be the name of a schema.
B.
SALES can be the name of a package.
C.
SALES can be the name of an existing alias.
D.
SALES can be the name of a declared global temporary table.
Explanation:
C)
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000910.html
The CREATE ALIAS statement defines an alias for a module, nickname, sequence, table, view, or another alias. Aliases are also known as synonyms.
0
0