database views

mcqspedia.com has 5 Question/Answers about Topic database views

SQL does not define a standard way of specifying that a view is

SQL does not define a standard way of specifying that a view is
  • A. Materialized
  • B. Not materialized
  • C. Stored
  • D. Not stored
  • Correct Answer: Option A

A view is updatable, if Select clause does not have any

A view is updatable, if Select clause does not have any
  • A. Expressions
  • B. Aggregates
  • C. Distinct specification
  • D. All of Above
  • Correct Answer: Option D

View relation is created whenever

View relation is created whenever
  • A. Needed
  • B. Demanded
  • C. Both A and B
  • D. Stored
  • Correct Answer: Option C

A view is updatable, if clause does not have any expression, aggregation and distinct specifications, i.e.

A view is updatable, if clause does not have any expression, aggregation and distinct specifications, i.e.
  • A. Define clause
  • B. Where clause
  • C. Select clause
  • D. Having clause
  • Correct Answer: Option C

Any relation that is not part of logical model, but is made visible to a user as a

Any relation that is not part of logical model, but is made visible to a user as a
  • A. Natural relation
  • B. Absolute relation
  • C. Virtual relation
  • D. Linear relation
  • Correct Answer: Option C