SnowPro Advanced: Architect — Question 172

An Architect executes the following statements in order:

create table emp(id integer);
insert into emp values (1),(2);
create temporary table emp(id integer);
insert into emp values (1) ;

The Architect then executes the following statements:

select count(*) from emp;
drop table emp;
select count(*) from emp;

What will be the result?

Answer options

• A. COUNT (*) 2 COUNT (*) 1
• B. COUNT (*) 1 COUNT (*) 2
• C. COUNT (*) 2 COUNT (*) 2
• D. The final query will result in an error.

Correct answer: D

Explanation

The final query will result in an error because the original table 'emp' has been dropped after the first count, and the subsequent count query attempts to reference a non-existent table. The other options incorrectly assume the count is valid after the drop operation.