📝 Question
#1085
For the view Create view instructor_info as SELECT ID, name, building FROM instructor, department WHERE instructor.dept name= department.dept name;
✓
Correct Answer
B. Null
💡
Explanation
The values take null if there is no constraint in the attribute else it is an Erroneous statement. 10. CREATE VIEW faculty AS SELECT ID, name, dept name FROM instructor; a) Instructor b) Select c) View …as d) None of the mentioned Syntax is – create view v as <query expression>;.
⌨️ Press
A
B
C
D
to select