For The View Create View Instructorinfo Asp Pre Langsql #330
For the view Create view instructor_info as</p> <pre><code class="language-sql"> select ID, name, building from instructor, department where instructor.dept name= department.dept name;</code></pre> <p>If we insert tuple into the view as insert into instructor info values (’69987’, ’White’, ’Taylor’);<br /> What will be the values of the other attributes in instructor and department relations?
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Views - Quiz No.1.
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes