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
|