Question 1

Question 1Assertion (A): Database management system is an application software which arranges data in a well-organized manner in the form of tables.Reasoning (R): DBMS acts as an interface between the database stored in the computer memory and the user.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationDatabase Management System (DBMS) is an application software that acts as an interface between the database stored in the computer memory and the user. It enables users to interact with the database and store data in a well-organized manner in the form of tables. The purpose of the DBMS software is to allow the user to create, access, modify, and control a database.

Question 2

Question 2Assertion (A): In hierarchical model, the data is organized in a tree-like structure.Reasoning (R): In hierarchical model, searching for a particular record is a time-consuming process.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationThe hierarchical model arranges data in a tree structure, where each record has a parent-child relationship. Searching for a specific record in such a model may require traversing through multiple levels of the hierarchy, which is time-consuming.

Question 3

Question 3Assertion (A): A database consists of multiple tables.Reasoning (R): A foreign key is used to represent the relationship between two tables.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationIn a database system, data is organized into multiple tables for better organization, management, and query efficiency. A foreign key is a non-key attribute whose value is derived from the primary key of another table in a database. It references the primary key in another table, thereby establishing a relationship between the two tables.

Question 4

Question 4Assertion (A): The limitations of traditional file system are overcome by storing data in a database.Reasoning (R): We can organize related data logically in a database.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationTraditional file systems have limitations such as data redundancy, inconsistency, and difficulties in data sharing and security. In contrast, databases store data in a structured and organized manner, which helps overcome these limitations. They allow us to logically organize related data, making data management, retrieval, and manipulation more efficient.

Question 5

Question 5Assertion (A): The number of attributes in a relation is called the degree of the relation.Reasoning (R): The number of tuples in a relation is called the cardinality of the relation.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true but R is not the correct explanation of A.ExplanationThe degree of a relation and the cardinality of a relation are two separate concepts in database management. The number of attributes or columns in a relation is called the degree of the relation, while the number of tuples or records in a relation is called the cardinality of the relation.

Question 6

Question 6Assertion (A): Each table must have one primary key.Reasoning (R): Primary key is a set of one or more attributes that uniquely identifies a tuple in a relation.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationIn a database, each table can have only one primary key, which is unique and non-redundant in nature. The primary key is a set of one or more attributes or fields that uniquely identify a tuple or row in a relation.

Question 7

Question 7Assertion (A): A database can have only one table.Reasoning (R): If a piece of data is stored in two places in a database, it leads to wastage of storage space.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

A is false but R is true.ExplanationA database can have multiple tables. Data redundancy, which occurs when the same data is repeated in multiple places within a database, leads to wastage of storage space. A DBMS eliminates data redundancy by integrating files, ensuring that multiple copies of the same data are not stored.

Question 8

Question 1A Database is an organized collection of records.

Accepted Answer