McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Master of Computer Applications (MCA) .
Chapters
| 1. |
Which of the following is related to information? |
| A. | Data |
| B. | Communication |
| C. | Knowledge |
| D. | All of these. |
| Answer» A. Data | |
| 2. |
Data is: |
| A. | A piece of fact |
| B. | Metadata |
| C. | Information |
| D. | None of these. |
| Answer» A. A piece of fact | |
| 3. |
Which of the following is element of the database? |
| A. | Data |
| B. | Constraints and schema |
| C. | Relationships |
| D. | All of these. |
| Answer» D. All of these. | |
| 4. |
What represent a correspondence between the various data elements? |
| A. | Data |
| B. | Constraints |
| C. | Relationships |
| D. | Schema |
| Answer» C. Relationships | |
| 5. |
Which of the following is an advantage of using database system? |
| A. | Security enforcement |
| B. | Avoidance of redundancy |
| C. | Reduced inconsistency |
| D. | All of these. |
| Answer» D. All of these. | |
| 6. |
Which of the following is characteristic of the data in a database? |
| A. | Independent |
| B. | Secure |
| C. | Shared |
| D. | All of these. |
| Answer» D. All of these. | |
| 7. |
Relationships could be of the following type: |
| A. | One-to-one relationship |
| B. | One-to-many relationships |
| C. | Many-to-many relationships |
| D. | All of these. |
| Answer» D. All of these. | |
| 8. |
In a file-oriented system there is: |
| A. | Data inconsistency |
| B. | Duplication of data |
| C. | Data independence |
| D. | Al of these. |
| Answer» D. Al of these. | |
| 9. |
In a database system there is: |
| A. | Increased productivity |
| B. | Improved security |
| C. | Economy of scale |
| D. | All of these. |
| Answer» D. All of these. | |
| 10. |
VDL is used to specify: |
| A. | Internal schema |
| B. | External schema |
| C. | Conceptual schema |
| D. | None of these. |
| Answer» D. None of these. | |
| 11. |
The DML provides following functional access to the database: |
| A. | Retrieve data and/or records |
| B. | Add (or insert) records |
| C. | Delete records from database files |
| D. | All of these |
| Answer» B. Add (or insert) records | |
| 12. |
4GL has the following components inbuilt in it: |
| A. | Query languages |
| B. | Report generators |
| C. | Spreadsheets |
| D. | All of these. |
| Answer» D. All of these. | |
| 13. |
Which of the following is database element? |
| A. | Data |
| B. | Constraints and schema |
| C. | Relationships |
| D. | All of these. |
| Answer» D. All of these. | |
| 14. |
What separates the physical aspects of data storage from the logical aspects of data representation? |
| A. | Data |
| B. | Schema |
| C. | Constraints |
| D. | Relationships |
| Answer» D. Relationships | |
| 15. |
What scheme defines how and where the data are organized in a physical data storage? |
| A. | External |
| B. | Internal |
| C. | Conceptual |
| D. | None of these. |
| Answer» A. External | |
| 16. |
Which of the following schemas defines the stored data structures in terms of the database model used? |
| A. | External |
| B. | Conceptual |
| C. | Internal |
| D. | None of these |
| Answer» B. Conceptual | |
| 17. |
Which of the following schemas defines a view or views of the database for particular users? |
| A. | External |
| B. | Conceptual |
| C. | Internal |
| D. | None of these |
| Answer» B. Conceptual | |
| 18. |
A collection of data designed to be used by different people is called. |
| A. | Database |
| B. | RDBMS |
| C. | DBMS |
| D. | None of these |
| Answer» A. Database | |
| 19. |
Which of the following is an object-oriented feature? |
| A. | Inheritance |
| B. | Abstraction |
| C. | Polymorphism |
| D. | All of these |
| Answer» B. Abstraction | |
| 20. |
In ……………technique, data splits at decision points based on entropy |
| A. | Cluster detection |
| B. | Decision trees |
| C. | Link analysis |
| D. | All of the above |
| Answer» D. All of the above | |
| 21. |
Association of unknown instances with known instances is a process of………….technique |
| A. | Memory based reasoning |
| B. | Link analysis |
| C. | Neural network |
| D. | Genetic algorithm |
| Answer» A. Memory based reasoning | |
| 22. |
Which technique is based on linking of variables |
| A. | Cluster detection |
| B. | Decision trees |
| C. | Link analysis |
| D. | All of the above |
| Answer» B. Decision trees | |
| 23. |
Forward propagation network is a structure of…………….. |
| A. | Memory based reasoning |
| B. | Link analysis |
| C. | Neural network |
| D. | Genetic algorithm |
| Answer» B. Link analysis | |
| 24. |
Data mining applications include |
| A. | Customer segmentation |
| B. | Market basket analysis |
| C. | Risk management |
| D. | All of the above |
| Answer» D. All of the above | |
| 25. |
Fraud detection is an application of |
| A. | Data warehousing |
| B. | Data mining |
| C. | Both I and ii |
| D. | None of the above |
| Answer» D. None of the above | |
| 26. |
…………….is a best source of data for a data mining operation |
| A. | OLAP |
| B. | Data warehouse |
| C. | OLTP |
| D. | None of the above |
| Answer» B. Data warehouse | |
| 27. |
…………….uncovers relationships and patterns in the existing data |
| A. | Data mining |
| B. | Data warehouse |
| C. | OLAP |
| D. | None of the above |
| Answer» D. None of the above | |
| 28. |
…………….steps comprise the knowledge discovery process |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» A. 3 | |
| 29. |
Data mining is |
| A. | Data driven |
| B. | User driven |
| C. | Both I and ii |
| D. | None of the above |
| Answer» B. User driven | |
| 30. |
OLAP is |
| A. | Data driven |
| B. | User driven |
| C. | Both I and ii |
| D. | None of the above |
| Answer» B. User driven | |
| 31. |
Which of the following is an advantage of a database? |
| A. | Reduction in Redundancy |
| B. | Avoidance of inconsistency |
| C. | Security enforcement |
| D. | All of the above |
| Answer» D. All of the above | |
| 32. |
Which of the following is an example of a database application? |
| A. | Computerized library systems |
| B. | ATMs |
| C. | Flight reservation systems |
| D. | All of the above |
| Answer» D. All of the above | |
| 33. |
DBMS stands for________________? |
| A. | Data blocking and Management Systems |
| B. | Database Management Systems |
| C. | Database Business Management Systems |
| D. | None of the above |
| Answer» B. Database Management Systems | |
| 34. |
What is the name of the system database that contains descriptions of the data in the database? |
| A. | Metadata |
| B. | Data dictionary |
| C. | Table |
| D. | None of the above |
| Answer» B. Data dictionary | |
| 35. |
IMS stands for ___________ |
| A. | Information Management System |
| B. | Internal Mechanical Security |
| C. | International Managers Society |
| D. | None of the above |
| Answer» A. Information Management System | |
| 36. |
Which of the following is the oldest database model? |
| A. | Hierarchical |
| B. | Network |
| C. | Relational |
| D. | Object Oriented |
| Answer» A. Hierarchical | |
| 37. |
Which category of users need not be aware of the presence of the database system? |
| A. | DBA |
| B. | Naive |
| C. | Casual |
| D. | Application Programmers |
| Answer» B. Naive | |
| 38. |
The different classes of relations created by the technique for preventing modification anomalies are called: |
| A. | normal forms. |
| B. | referential integrity constraints. |
| C. | functional dependencies. |
| D. | None of the above is correct. |
| Answer» A. normal forms. | |
| 39. |
A relation is in this form if it is in BCNF and has no multivalued dependencies: |
| A. | second normal form. |
| B. | third normal form. |
| C. | fourth normal form. |
| D. | domain/key normal form. |
| Answer» C. fourth normal form. | |
| 40. |
The primary key is selected from the: |
| A. | composite keys. |
| B. | determinants. |
| C. | candidate keys. |
| D. | foreign keys. |
| Answer» C. candidate keys. | |
| 41. |
In the relational model, relationships between relations or tables are created by using: |
| A. | composite keys. |
| B. | determinants. |
| C. | candidate keys. |
| D. | foreign keys. |
| Answer» D. foreign keys. | |
| 42. |
A relation is considered a: |
| A. | Column. |
| B. | one-dimensional table. |
| C. | two-dimensional table. |
| D. | three-dimensional table. |
| Answer» C. two-dimensional table. | |
| 43. |
For some relations, changing the data can have undesirable consequences called: |
| A. | referential integrity constraints. |
| B. | modification anomalies. |
| C. | normal forms. |
| D. | transitive dependencies. |
| Answer» B. modification anomalies. | |
| 44. |
If attribute A determines both attributes B and C, then it is also true that: |
| A. | A → B. |
| B. | B → A. |
| C. | C → A. |
| D. | (B,C) → A. |
| Answer» A. A → B. | |
| 45. |
One solution to the multivalued dependency constraint problem is to: split the relation into two relations, each with a single theme. |
| A. | change the theme. |
| B. | create a new theme. |
| C. | add a composite key. |
| D. | none |
| Answer» A. change the theme. | |
| 46. |
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): |
| A. | transitive dependency. |
| B. | insertion anomaly. |
| C. | referential integrity constraint. |
| D. | normal form. |
| Answer» C. referential integrity constraint. | |
| 47. |
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity. |
| A. | Parent |
| B. | Child |
| C. | Instance |
| D. | Subtype |
| Answer» A. Parent | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.