| 1. | Which of the following is correct regarding Aggregate functions? |
|
Answer: (a).it takes a list of values and return a single values as result
|
| 2. | Which of the following option is use to retrieval of data? |
|
Answer: (d).Query
|
| 3. | Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of: |
|
Answer: (b).Data integrity constraints
|
| 4. | ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations. |
|
Answer: (b).Referential Integrity Constraint
|
| 5. | Which of the following is a physical storage media ? |
|
Answer: (d).All of the mentioned
|
| 6. | Which of the following creates a virtual relation for storing the query ? |
|
Answer: (b).View
|
| 7. | Which of the following is the syntax for views where v is view name ? |
|
Answer: (c).Create view v as “query expression”;
|
| 8. | Select course_id from physics_fall_2009 where building= ’Watson’; Here the tuples are selected from the view.Which one denotes the view ? |
|
Answer: (c).Building
|
| 9. | Materialised views make sure that |
|
Answer: (b).View definition is kept up-to-date
|
| 10. | Updating the value of the view |
|
Answer: (a).Will affect the relation from which it is defined
|
