adplus-dvertising
frame-decoration

Question

Materialised views make sure that

a.

View definition is kept stable

b.

View definition is kept up-to-date

c.

View definition is verified for error

d.

View is deleted after specified time

Answer: (b).View definition is kept up-to-date

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Materialised views make sure that

Similar Questions

Discover Related MCQs

Q. Updating the value of the view

Q. SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

Q. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?

Q. A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

Q. Relational schema and other metadata about relations are stored in a structure called the ____________ .

Q. ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

Q. A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

Q. A tablespace is further broken down into ________

Q. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

Q. ________ is the smallest unit of allocation in an Oracle database.

Q. DML is provided for

Q. The language used in application programs to request data from the DBMS is referred to as the

Q. The way a particular application views the data from the database that the application uses is a

Q. The DBMS language component which can be embedded in a program is

Q. A DBMS query language is designed to

Q. The full form of DDL is

Q. DDL Stands for ___________.

Q. DML Stands for _____________.

Q. Which of the following language is used to specify database Schema ?

Q. Set of definitions that are used to specify schema are expressed using __________.