Adam works as a Database Administrator for Domain.com. He creates a table named Students.
He wants to create a new table named Class with the help of the Students table. Which of the
following syntaxes will Adam use to accomplish the task?
A.
CREATE TABLE Class
INSERT INTO SELECT * FROM Students;
B.
CREATE TABLE Class
AS SELECT * FROM Students;
C.
CREATE TABLE Class
(SELECT * FROM Students);
D.
CREATE TABLE Class
FROM SELECT * FROM Students;