 |
| Computer Science 12th Chapter 3 - Database Design Process Questions Bank |
Computer Science 2nd Year Chapter 3 - Database Design Process Solved MCQs, Important Short Questions and Long Questions Bank
MCQs
Please select the right answer.
1. ___ components of physical database design refers to the correctness and consistency of data :
2. ___ is not component of physical database design :
3. ___ is used to associate entities with one another :
4. ___ defines the nature of the relationship :
5. ___ is an example of one-to-many relationship :
6. ___ is related of modality :
7. ___activities is performed in logical design process :
8. ___components of physical database design is another form of data protection :
9. ___components of physical database design is related to the networking through which the data of database is shared among different users :
10. ___is a type of relationship :
11. ___is an example of one-to-one relationship :
12. ___is called the preliminary investigation of the required database :
13. ___is not a basic data distribution strategy :
14. ___is not related to an entity :
15. ___is the basic data distribution strategy :
16. ___represents entity :
17. ___tools in involved to the Data Analysis :
18. A factor to consider when choosing a file organization is:
19. A person's name, birthday and social security number are examples of:
20. A technique for physically arranging the records of a file on secondary storage device is called
21. All the hardware costs are considered during
22. All the relationships are
23. An advantage of partitioning is:
24. An entity related to itself in an ERD model refers to
25. An index may be created on
26. Critical fragments are stored at ____site(s)
27. Customers, cars and parts are examples of:
28. Data is stored at single site while following
29. Database development process involve mapping of conceptual data model into
30. Database users require _____________ information
31. Father & children is an example of
32. In _______________database is divided critical and non critical fragments
33. In _______________database is divided into fragments
34. In an E-R diagram, a rectangle represents
35. In database correctness and consistency refers to the
36. In E-R diagram, a diamond shape is used to represent a(n) :
37. In E-R diagram, a rectangular box is used to represent a(n) :
38. In E-R diagram, an oval shape is used to represent a(n) :
39. In ERD model, the relationship between two entities is represented by a
40. In ERD there are
41. In hybrid distribution which kind of fragments are stored at only one site
42. In hybrid distribution which kind of fragments is stored at only one site :
43. In hybrid distribution, what types of fragments are stored at only one site?
44. In which phase proper market analysis is also worked out
45. In which strategy full copy of database is assigned to more than one sites in the network
46. In which strategy there is a problem of update
47. In components of physical database design, the size of database is estimated :
48. In___ activities, the cost factors are taken into consideration :
49. In___activities, the possible inputs for the database are collected :
50. Merging the relation is also known as:
51. Merging the relations is also called :
52. Organizing the database in computer disk storage is done in:
53. Organizing the database on secondary storage is related to :
54. Possible inputs and the required functionality output of system is determined during
55. Refers to a method of database distribution in which one database contains data that are included in another database.
56. The implementation model of database design is derived from
57. The optional relationship is represented by :
58. The primary objective of ERD is to represent
59. The process to identify the data objects and the relationships between them is :
60. The relationship between entities is represented graphically by using.
61. The relationship between the entities is represented graphically by using :
62. The relationship can be:
63. What indicates the connection between entities
64. What is the major objective of database design :
65. Which component of physical database design refers to the consistency of data? Indexes
66. Which Involves the area identification and selection
67. Which of the following activities are involved in data analysis?
68. Which of the following are ingredients of data modeling?
69. Which of the following is a one-to-many relationship?
70. Which of the following is an example of one-to-one relationship?
71. Which of the following is related to modality?
72. Which of the following is used to describe the characteristics of an object?
73. Which of the following keys does not hold uniqueness property
74. Which of the following keys is not unique?
75. Which one is not a data distribution strategy
76. Which one is the ingredient of data modeling :
Short Questions
1. Define an attribute. Give examples.
2. Define analysis.
3. Define entity or object.
4. Define Modality.
5. Define the term analysis.
6. Differentiate between cardinality and modality.
7. Differentiate between security and integrity?
8. How can you identify if a relationship is optional or mandatory?
9. How is database integrity maintained?
10. Identify different components of ER diagram.
11. List different types of relationships.
12. List four data distribution strategy.
13. Name the symbols used in ER model for attribute, entity and relationship.
14. What data distribution strategy?
15. What is “File Organization”?
16. What is “Merge Relations”?
17. What is a relationship? Give an example.
18. What is an entity?
19. What is centralized strategy and also write its disadvantages?
20. What is conceptual OR logical database design?
21. What is data analysis?
22. What is data modeling and its ingredients?
23. What is data modeling?
24. What is database design?
25. What is database implementation?
26. What is E-R diagram?
27. What is ERD?
28. What is hybrid strategy OR differentiate between critical and non-critical fragments?
29. What is index?
30. What is logical database design?
31. What is Many-to-Many relationship?
32. What is meant by cardinality of relation?
33. What is meant by centralized database distribution?
34. What is meant by degree of relation?
35. What is meant by integrity constraints?
36. What is meant by Normalize the Relations?
37. What is meant by requirements' analysis?
38. What is modality?
39. What is One-to-Many relationship?
40. What is One-to-One relationship?
41. What is partitioned database distribution?
42. What is partitioned?
43. What is physical database design?
44. What is project planning?
45. What is Recursive relationship?
46. What is relationship?
47. What is replicated database distribution?
48. What is replicated strategy?
49. What is the importance of project planning?
50. What is the major objective of physical database design?
51. What is the primary objective of ER diagram?
52. What is the purpose of analysis?
53. What is the purpose of database design process?
54. What is the purpose of logical database design?
55. What is the use of data volume and usage analysis?
56. What symbols are used to show the cardinality of one and many?
57. Which activities are involved in data analysis?
58. Which are the major three inputs to physical database design?
59. Why is requirement analysis conducted?
60. Write any four criteria used to select file organization?
61. Write any three constrains for selecting a file organization.
62. Write some examples of entity.
63. Write the components of physical database design?
64. Write the ingredients of data modeling?
65. Write the purpose of feasibility study.
66. Write three types of relationship between two attributes with one example of each?
Long Questions
1. Define Normalization and different steps involved in it.
2. When a relation is in Second Normal Form? Explain with the help of an example.
3. What is data integrity? Also discuss its two types.
4. Explain the difference between data integrity and data security.
5. Define the terms Synonyms, Homonyms, Redundant information and mutually exclusive data.
6. What are database anomalies? Briefly discuss insertion deletion and modification anomalies.
7. When a relation is in First Normal Form? Explain with the help of an example.
8. When a relation is in Third Normal Form? Explain with the help of an example.
9. Write a note on functional dependency.