| 1. | Which of the following is correct regarding Aggregate functions? |
| a. | it takes a list of values and return a single values as result |
| b. | it takes a list of values and return a list of values as result |
| c. | it takes a single value and returns a list of values as result |
| d. | it takes a single value and returns a single value as result |
| View Answer Report Discuss Too Difficult! Search Google |
|
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? |
| a. | Stack |
| b. | Data Structure |
| c. | Linked list |
| d. | Query |
| View Answer Report Discuss Too Difficult! Search Google |
|
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: |
| a. | Attributes |
| b. | Data integrity constraints |
| c. | Method constraints |
| d. | Referential integrity constraints |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).Data integrity constraints
|
| 4. | ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations. |
| a. | Entity Integrity Constraints |
| b. | Referential Integrity Constraint |
| c. | Domain Integrity Constraints |
| d. | Domain Constraints |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).Referential Integrity Constraint
|
| 5. | Which of the following is a physical storage media ? |
| a. | Tape Storage |
| b. | Optical Storage |
| c. | Flash memory |
| d. | All of the mentioned |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (d).All of the mentioned
|
| 6. | Which of the following creates a virtual relation for storing the query ? |
| a. | Function |
| b. | View |
| c. | Procedure |
| d. | None of the mentioned |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).View
|
| 7. | Which of the following is the syntax for views where v is view name ? |
| a. | Create view v as “query name”; |
| b. | Create “query expression” as view; |
| c. | Create view v as “query expression”; |
| d. | Create view “query expression”; |
| View Answer Report Discuss Too Difficult! Search Google |
|
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 ? |
| a. | Course_id |
| b. | Watson |
| c. | Building |
| d. | physics_fall_2009 |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (c).Building
|
| 9. | 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 |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).View definition is kept up-to-date
|
| 10. | Updating the value of the view |
| a. | Will affect the relation from which it is defined |
| b. | Will not change the view definition |
| c. | Will not affect the relation from which it is defined |
| d. | Cannot determine |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).Will affect the relation from which it is defined
|
