edited by
792 views
0 votes
0 votes

Which of the following is/are true with reference to ‘view’ in DBMS?

  1. A ‘view’ is a special stored procedure executed when certain event occurs
  2. A ‘view’ is a virtual table, which occurs after executing a pre-compiled query
  1. Only (i) is true
  2. Only (ii) is true
  3. Both (i) and (ii) are true
  4. Neither (i) nor (ii) are true
edited by

3 Answers

1 votes
1 votes
By definition, VIEW is a virtual table, through which a selective portion of the data from one or more tables can be seen. A view does not contain data of its own.
0 votes
0 votes
A ‘view’ is virtual table and it is not a special stored procedure. View only occurs after executing a pre-complied query.
So, option (B) is correct.
0 votes
0 votes
A ‘view’ is virtual table and it is not stored own data or special stored, View only occurs after executing a pre-complied query.
So that here option (B) is correct.
Answer:

Related questions

1 votes
1 votes
2 answers
1
Arjun asked Nov 5, 2017
3,067 views
Which speed up could be achieved according to Amdahl's Law for infinte number of processes if $5\%$ of a program is sequential and the remaining part is ideally parallel?...
0 votes
0 votes
1 answer
2
Arjun asked Nov 5, 2017
2,519 views
Which of the given wireless technologies used in IoT, consumes the least amount of power?ZigbeeBluetoothWi-FiGSM/CDMA
0 votes
0 votes
2 answers
3
Arjun asked Nov 5, 2017
4,592 views
Which of the following is not a Clustering method?K-Means methodSelf Organizing feature map methodK- nearest neighbor methodAgglomerative method