Which of the following statements is incorrect in the view?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *