DBMS MCQs - CSE MCQs Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Materialised views make sure that

View definition is kept stable

View definition is kept up-to-date

View definition is verified for error

View is deleted after specified time

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Updating the value of the view

Will affect the relation from which it is defined

Will not change the view definition

Will not affect the relation from which it is defined

Cannot determine

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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?

The from clause has only one database relation.

The query does not have a group by or having clause.

The select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification.

All of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

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 ?

With

Check

With check

All of the mentioned