You work as a Database Administrator for Domain.com. You have written the following code for
creating a view:
CREATE VIEW Student_View
AS SELECT Stu_ID, Stu_Description
FROM Students
WHERE Stu_ID = 512
ORDERED BY Stu_Description;
After executing the above code, you got an error. Which of the following statements is incorrect in
the view?
A.
ORDERED BY Stu_Description;
B.
WHERE Stu_ID = 512
C.
CREATE VIEW Student_View
D.
AS SELECT Stu_ID, Stu_Description