PrepAway - Latest Free Exam Questions & Answers

What will be the result if the user executes the following statement?

A user executes the following statements:

СREATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;

What will be the result if the user executes the following statement?

DROP ALIAS a1;

A. The alias A1 will be dropped

B. The table T1 will be dropped
C. Both T1 and A1 will be dropped
D. Nothing, the statement will result in an error


Leave a Reply