recategorized
2,551 views
1 1 vote

Views are useful for ____ unwanted information, and for collecting together information from more than one relation into a single view.

  1. Hiding
  2. Deleting
  3. Highlighting
  4. All of the above

2 Answers

1 1 vote

Answer A: hiding

What is a view?

  • Views are subset of table.
  • View also has set of records in the form of rows and columns.
  • But it is created based on the records in one or more tables. 
  • A table will have large number of data and table will be fired with specific frequently. In such case, instead of rewriting the query again and again, a name is given to the query and it will be called whenever it is required.
  • Hence view is also called as named query or stored query.
1 1 vote
Ans is A views are logical masks over table(s) to display selected information from multiple relation and hiding rest
Answer:
Position:
Show:

Related questions

1 1 vote
2 2 answers
2.3k
2.3k views
go_editor asked Jul 21, 2016
2,281 views
Thoma’s-write rule isTwo phase locking protocolTimestamp ordering protocolOne phase locking protocolSliding window protocol
1 1 vote
2 2 answers
2.0k
2.0k views
go_editor asked Jul 21, 2016
1,990 views
Cross_tab displays permit users to view ____ of multidimensional data at a time.One dimensionTwo dimensionsThree dimensionsMultidimensions
1 1 vote
1 1 answer
2.3k
2.3k views
go_editor asked Jul 21, 2016
2,324 views
Usage of Preemption and Transaction Rollback prevents _____.Unauthorized usage of data fileDeadlock situationData manipulationFile pre-emption
3 3 votes
1 1 answer
7.2k
7.2k views
go_editor asked Jul 6, 2016
7,217 views
Which level of abstraction describes what data are stored in the database? Physical levelView levelAbstraction levelLogical level