adplus-dvertising
frame-decoration

Question

Which one of the following is not true for a view:

a.

View is derived from other tables

b.

View is a virtual table

c.

A view definition is permanently stored as part of the database

d.

View never contains derived columns

Posted under DBMS

Answer: (c).A view definition is permanently stored as part of the database

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which one of the following is not true for a view:

Similar Questions

Discover Related MCQs

Q. To delete a particular column in a relation the command used is:

Q. The ______ operator is used to compare a value to a list of literals values that have been specified.

Q. _____________ function divides one numeric expression by another and returns the remainder.

Q. A data manipulation command the combines the records from one or more tables is called

Q. _________ is a virtual table that draws its data from the result of an SQL SELECT statement.

Q. A table joined with itself is called

Q. _________ data type can store unstructured data.

Q. SQL is a standard language for ________.

Q. SQL stands for _________.

Q. Structured Query Language is an __________ Standard.

Q. Which of the following function cannot be performed by SQL ?

Q. The command to eliminate a table from a database is:

Q. The command to eliminate a row from a table is:

Q. Which one of the following sorts rows in SQL?

Q. Which of the following is the correct processing order for SQL SELECT statements?

Q. A view is which of the following?

Q. Which of the following is valid SQL for an Index?

Q. Find the SQL statement below that is equal to the following:
SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Q. Which of the following is the original purpose of SQL?

Q. The benefits of a standard relational language include which of the following?