Which of the following creates a virtual relation for storing the query?
Function
View
Procedure
None of the mentioned
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1
Discuss
|
Consider the two relations instructor and department
Department:
Which of the following is used to create view for these relations together?
Solution |
||||||||||||||||||||||||||||
2
Discuss
|
Find the error in this query.
Solution |
||||||||||||||||||||||||||||
3
Discuss
|
SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?
Solution |
||||||||||||||||||||||||||||
4
Discuss
|
For the view Create view instructor_info as
If we insert tuple into the view as insert into instructor info values (’69987’, ’White’, ’Taylor’);
Solution |
||||||||||||||||||||||||||||
5
Discuss
|
Updating the value of the view
Solution |
||||||||||||||||||||||||||||
6
Discuss
|
Materialized views make sure that
Solution |
||||||||||||||||||||||||||||
7
Discuss
|
Which of the following is the syntax for views where v is view name?
Solution |
||||||||||||||||||||||||||||
8
Discuss
|
Here the tuples are selected from the view.Which one denotes the view.
Solution |
||||||||||||||||||||||||||||
9
Discuss
|
Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?
Solution |
||||||||||||||||||||||||||||
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved