gs gs117 SQL: Queries, Constraints and Triggers - Views - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL: Queries, Constraints and Triggers. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Select course_id from physics_fall_2009 where building= ’Watson’;Here the tuples are selected from the view. Which one denotes the view?
Instructor:
| ID | Name | Dept_name | Salary |
| 1001 | Ted | Finance | 10000 |
| 1002 | Bob | Music | 20000 |
| 1003 | Ron | Physics | 50000 |
Department:
| Dept_name | Building | Budget |
| Biology | Watson | 40000 |
| Chemistry | Painter | 30000 |
| Music | Taylor | 50000 |
Which of the following is used to create view for these relations together?
Create view instructor_info as select ID, name, building from instructor, department where instructor.dept name= department.dept name; Create view instructor_info select ID, name, building from instructor, department; Create view instructor_info as select ID, name, building from instructor; Create view instructor_info as select ID, name, building from department;Create view faculty as Select ID, name, dept name from instructor;Find the error in this query.
Online Quizzes of gs117 Database Management System
