MCQ Practice

All Countries 🌏 Mcq University Model MCQ Single Answer ENGLISH SQL SQL CREATE TABLE 2025

Focused practice with instant answer feedback, progress tracking, and community notes in one consistent workspace.

Answer feedback follows the same pattern everywhere on BrainBoost.

Green means correct, red means incorrect, and your selected answer is underlined in purple.

Question Set

Interest

Timer

Question

Which of the following SQL statement is used to create a table by copying only the selected columns from another table?

CREATE TABLE new_tablename AS (
SELECT Column1, Column2...Columnn
FROM old_tablename);

CREATE TABLE TABLE_NAME
(column1 datatype CONSTRAINT
column2 datatype CONSTRAINT
column3 datatype CONSTRAINT
...
columnn datatype CONSTRAINT);

CREATE TABLE new_tablename AS (
SELECT * FROM old_tablename WHERE condition);

CREATE TABLE new_tablename AS (
SELECT Column1, Column2...ColumnN 
FROM old_tablename1, old_tablename2...old_tablenamen);

Community Help

Added solution videos and notes for this question