Create View Studentdetbr Select Id Address Namebr From Studentp #58
create view studentdet<br /> select ID, address, name<br /> from student;</p> <p>What is the result of the above query?
This multiple choice question (MCQ) is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Intermediate and Advanced SQL - Views and Transactions - Quiz No.1.
create view studentdet
select ID, address, name
from student;
select ID, address, name
from student;
What is the result of the above query?
It creates a view named studentdet with 3 attributes
It creates a view named studentdet with 1 attribute
It creates a view named ID with 2 attributes
It is syntactically wrong and does not give a result
