Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A permanent table and a temporary table with the same name, TBL1, exist in the same schema. What is the result of executing the query SELECT * FROM TBL1;?*
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.
