MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is the correct command to create a view?
A
CREATE VIEW Inv ____ 1 AS
B
SELECT VIEW Inv ____ 1 FROM
C
CREATE TABLE VIEW Inv ____ 1 AS
D
CREATE VIEW TABLE Inv ____ 1 FROM
Explanation: 

Detailed explanation-1: -A view is created with the CREATE VIEW statement.

Detailed explanation-2: -The syntax for the CREATE VIEW Statement in Oracle/PLSQL is: CREATE VIEW view name AS SELECT columns FROM tables [WHERE conditions]; view name. The name of the Oracle VIEW that you wish to create.

Detailed explanation-3: -A. Database views are created using the CREATE VIEW statement.

There is 1 question to complete.
Previous
Next