Which of the following is a correct statement? 1. create table t1 as select * from emp; 2. create table t1 as emp; 3. copy table emp to t1; 4. Create t1 from emp;

The subject in question relates to SQL, which is a topic within the field of Computers and Technology, commonly studied at the College level. The question requires understanding SQL syntax for creating tables based on existing tables or data selection.
Let’s evaluate each statement:

create table t1 as select * from emp;

This is a correct SQL statement. It creates a new table t1 by selecting all columns and rows from an existing emp table. This operation is known as 'Creating a table using an existing table' or 'Creating a table with a subquery'.


create table t1 as emp;

This is not a valid SQL statement as it lacks a subquery or data definition. The 'AS' keyword typically requires a 'SELECT' clause to specify the columns and data to use.


copy table emp to t1;

This statement is invalid in standard SQL. SQL does not typically use a 'copy table' command for copying data from one table to another.


Create t1 from emp;

This is not a valid SQL command as it does not correctly follow SQL syntax. SQL requires a more defined approach with either 'CREATE TABLE' or use of a query.



Based on this analysis, statement 1 is the correct SQL syntax for creating a new table from an existing table using a subquery to select data.
Therefore, the correct answer is the first option: create table t1 as select * from emp;

Answered by EmmaGraceJohnson | 2025-07-22