196k views
0 votes
Which of the following is not true regarding user views?

1) Application programs reference them.
2) People querying the database reference them.
3) They can be tailored to the needs of the database user.
4) Data updates are shown in a delayed fashion.

User Mmtootmm
by
7.7k points

1 Answer

6 votes

Final answer:

The incorrect statement about user views is that 'Data updates are shown in a delayed fashion.' User views reflect real-time data changes from the underlying database tables, contrary to the delayed updates assertion.

Step-by-step explanation:

The statement that is not true regarding user views is that 'Data updates are shown in a delayed fashion.' User views are virtual tables representing a subset of the database data, typically crafted to provide users with a specific, personalized view of the data for easier understanding and security reasons. When considering user views, the following points are valid:

  • Application programs do reference them to abstract the underlying table structures.
  • People querying the database do reference them as well for simplified or restricted access to data.
  • They can indeed be tailored to the needs of the database user, allowing for customization.

However, the statement about data updates being delayed in user views is incorrect. When an underlying table that a view is based on is updated, these changes are immediately visible in the view, provided that the view is set up to reflect these changes.

User Spaso Lazarevic
by
8.8k points