Advance Database Management System (ADBMS) MCQs and Notes

Explanation: A typeface refers to a set of characters, letters, and symbols that share a common design. Examples of typefaces include Times New Roman, Arial, and Helvetica. The term "keyface" is not commonly used in the context of typography, while "formation" and "calligraph" do not specifically refer to sets of characters. A stencil is a type of template used to create a repeated design.

Explanation: The software that is used to create text-based documents are referred to as word processors. Therefore, the correct option is (d) word processors.

Explanation: The correct answer is (c) multiprocessing. The simultaneous execution of two or more instructions is called multiprocessing. Multiprocessing refers to the ability of a computer system to execute multiple processes or threads at the same time, using multiple CPUs or cores.

Explanation: A collection of conceptual tools for describing data, relationships, semantics, and constraints is referred to as a Data Model. Therefore, the correct option is (c) Data Model.

Explanation: Data inconsistency is one reason for problems of data integrity. Data inconsistency occurs when the same data is stored in different locations in the database and the data values do not match. This can happen due to errors in data entry, incomplete or outdated data, or software bugs. Data inconsistency can lead to incorrect and unreliable results when data is queried or processed. It can also make it difficult to maintain data quality and accuracy over time. Ensuring data consistency is an important aspect of maintaining data integrity in a database.

Explanation: DBMS (Database Management System) provides total solutions to reduce data redundancy, inconsistency, dependence, and unauthorized access of data. DBMS is a software system that enables users to define, create, maintain, and control access to the database. It provides mechanisms for data integration, data sharing, data security, and data consistency. The DBMS manages the storage, retrieval, and modification of data in the database. It reduces data redundancy by eliminating duplicate data and ensures data consistency by enforcing data integrity constraints. It also provides tools for data backup and recovery in case of data loss or corruption.

Explanation: Batch processing is a technique in which a large volume of data or transactions is collected over a period of time and then processed all at once, usually overnight or during a period of low activity. This is in contrast to real-time or online systems, which process data immediately as it is entered or received. A database management system is a software system used to manage and organize data in a database.

Explanation: (d) spreadsheets. Spreadsheets are computer programs that allow users to organize data into rows and columns, and perform calculations and analyses on that data. They are commonly used in business for tasks such as budgeting, financial analysis, and record-keeping. Transaction sheets and registers are types of forms used to record specific types of business transactions, while "business forms" and "sheet-spreads" are not commonly used terms in this context.

Explanation: Attributes can be defined for an entity. Therefore, the correct option is (a) entity.