What is a view? Discuss the difference between a view and a base relation.

What will be an ideal response?


View is the dynamic result of one or more relational operations operating on the base relations to
produce another relation. Base relation exists as a set of data in the database. A view does not
contain any data, rather a view is defined as a query on one or more base relations and a query on
the view is translated into a query on the associated base relations.

Computer Science & Information Technology

You might also like to view...

In the catch block below, what is e?

``` catch (DivideByZeroException e) { Console.WriteLine(e); } ``` a) The type of the exception being caught b) The name of catch block’s exception parameter c) A finally block d) An exception handler

Computer Science & Information Technology

When a collision is detected in Ethernet, it is resolved using

a. stop-and-wait ARQ b. go-back-N ARQ c. priority backoff d. random backoff

Computer Science & Information Technology

In the accompanying figure, which selection would have been easiest to make using the Polygonal Lasso tool?

A. 1 B. 2 C. 3 D. 4

Computer Science & Information Technology

public static int func2(int m, int n){    if (n == 0)        return 0;    else        return m + func2(m, n - 1);}What is the limiting condition of the code in the accompanying figure?

A. n >= 0 B. m > n C. m >= 0 D. n > m

Computer Science & Information Technology