Chapters
| 1. |
Which of the following is a Data Model? |
| A. | entity-relationship model |
| B. | relational data model |
| C. | object-based data model |
| D. | all of the above |
| Answer» D. all of the above | |
| 2. |
A collection of related data. |
| A. | Information |
| B. | Valuable information |
| C. | Database |
| D. | Metadata |
| Answer» C. Database | |
| Explanation: A database is a collection of related data that is organized and structured in a way that allows for easy access and manipulation. It typically includes data tables, indices, and other components that are used to store, manage, and retrieve data. A database is a useful tool for storing and managing large amounts of structured data, and it is commonly used in a wide range of applications, including business, finance, healthcare, and more. | |
| 3. |
DBMS is software. |
| A. | True |
| B. | False |
| C. | none |
| D. | all |
| Answer» A. True | |
| 4. |
DBMS manages the interaction between __________ and database. |
| A. | Users |
| B. | Clients |
| C. | End Users |
| D. | Stake Holders |
| Answer» C. End Users | |
| 5. |
Which of the following is not involved in DBMS? |
| A. | End Users |
| B. | Data |
| C. | Application Request |
| D. | HTML |
| Answer» D. HTML | |
| 6. |
Database is generally __________ |
| A. | System-centered |
| B. | User-centered |
| C. | Company-centered |
| D. | Data-centered |
| Answer» B. User-centered | |
| 7. |
A characteristic of an entity. |
| A. | Relation |
| B. | Attribute |
| C. | Parameter |
| D. | Constraint |
| Answer» B. Attribute | |
| 8. |
The restrictions placed on the data. |
| A. | Relation |
| B. | Attribute |
| C. | Parameter |
| D. | Constraint |
| Answer» D. Constraint | |
| 9. |
IMS stands for? |
| A. | Information Mastering System |
| B. | Instruction Management System |
| C. | Instruction Manipulating System |
| D. | Information Management System |
| Answer» D. Information Management System | |
| 10. |
A model developed by Hammer and Mc Leod in 1981. |
| A. | SDM |
| B. | OODBM |
| C. | DDM |
| D. | RDM |
| Answer» A. SDM | |
| 11. |
Object=_________+relationships. |
| A. | data |
| B. | attributes |
| C. | entity |
| D. | constraints |
| Answer» C. entity | |
| 12. |
Duplication of data at several places is called as _______________. |
| A. | Data Inconsistency |
| B. | Data Isolation |
| C. | Atomicity Problem |
| D. | Data Redundance |
| Answer» D. Data Redundance | |
| 13. |
Data Redundancy increases the cost of storing and retrieving data. |
| A. | False |
| B. | True |
| C. | none |
| D. | all |
| Answer» B. True | |
| 14. |
Which of the information is not redundant. |
| A. | name |
| B. | mobile |
| C. | account-no |
| D. | address |
| Answer» C. account-no | |
| 15. |
If in redundant file common fields are not matching then it results in _____________. |
| A. | Data Inconsistency |
| B. | Data Integrity Problem |
| C. | Data Isolation |
| D. | Data Redundancy |
| Answer» A. Data Inconsistency | |
| 16. |
It is difficult to access conventional file system than Database System. |
| A. | True |
| B. | False |
| C. | none |
| D. | all |
| Answer» A. True | |
| 17. |
An ________ is a set of entities of the same type that share the same properties, or attributes. |
| A. | Entity set |
| B. | Attribute set |
| C. | Relation set |
| D. | Entity model |
| Answer» A. Entity set | |
| 18. |
Entity is a _________ |
| A. | Object of relation |
| B. | Present working model |
| C. | Thing in real world |
| D. | Model of relation |
| Answer» C. Thing in real world | |
| 19. |
The descriptive property possessed by each entity set is _________ |
| A. | Entity |
| B. | Attribute |
| C. | Relation |
| D. | Model |
| Answer» B. Attribute | |
| 20. |
The function that an entity plays in a relationship is called that entity’s _____________ |
| A. | Participation |
| B. | Position |
| C. | Role |
| D. | Instance |
| Answer» C. Role | |
| 21. |
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called |
| A. | Simple attribute |
| B. | Composite attribute |
| C. | Multivalued attribute |
| D. | Derived attribute |
| Answer» B. Composite attribute | |
| 22. |
In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute. |
| A. | Desciptive |
| B. | Derived |
| C. | Recursive |
| D. | Relative |
| Answer» A. Desciptive | |
| 23. |
_____________ can help us detect poor E-R design. |
| A. | Database Design Process |
| B. | E-R Design Process |
| C. | Relational scheme |
| D. | Functional dependencies |
| Answer» D. Functional dependencies | |
| 24. |
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | Both A many-to-many relationship set and A multivalued attribute of an entity set |
| Answer» D. Both A many-to-many relationship set and A multivalued attribute of an entity set | |
| 25. |
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | All of the mentioned |
| Answer» A. A many-to-many relationship set | |
We're developing a website for study materials for students.
We would love to hear your answers to some of the questions.
