A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?

Question

A permanent table and temporary table have the same name, TBL1, in a schema.What will happen if a user executes select * from TBL1 ;?

Benvindo Almeida · Accepted Answer

The temporary table will take precedence over the permanent table.

Benvindo Almeida · Answer

The permanent table will take precedence over the temporary table.

Benvindo Almeida · Answer

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

Benvindo Almeida · Answer

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

List of questions