Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Exam COF-C02 All Questions
Exam COF-C02 All Questions

View all questions & answers for the COF-C02 exam

Snowflake SnowPro Core Certification COF-C02 Question # 144 Topic 16 Discussion

COF-C02 Exam Topic 16 Question 144 Discussion:
Question #: 144
Topic #: 16

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?


A.

The temporary table will take precedence over the permanent table.


B.

The permanent table will take precedence over the temporary table.


C.

An error will say there cannot be two tables with the same name in a schema.


D.

The table that was created most recently will take precedence over the older table.


Get Premium COF-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.