2014 Latest Oracle 1Z0-870 Exam Demo Free Download!

QUESTION 1
Adam works as a Database Administrator for Pass4sure.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
FROM SELECT * FROM Students;
C.    CREATE TABLE Class
(SELECT * FROM Students);
D.    CREATE TABLE Class
AS SELECT * FROM Students;

Answer: D

Continue reading