Database Views Quiz PDF: Questions and Answers - 35

MCQ 171: A view is updatable, if the Select clause does not have any

1. Expressions
2. Aggregates
3. Distinct specification
4. All of the Above

MCQ 172: SQL provides a way of renaming the attributes of a result relation, taking the form

1. old-name to new-name
2. old-name as new-name
3. ALTER old-name to new-name
4. ALTER old-name at new-name

MCQ 173: The schema for relation r, with 'R' denoting the set of attributes, can be expressed by the notation

1. r
2. R
3. r(R)
4. R (r)

MCQ 174: The pass that determines which transactions to undo is known as

1. Redo pass
2. Analysis pass
3. Undo pass
4. Logical pass

MCQ 175: The Data model that is widely used in the database design is

1. Object-based Data model
2. Relational Model
3. Semi-structured data model
4. Entity relationship model