Database Management System Class 10 MCQ with Answer

Database Management System Class 10 MCQ with Answer

Database Management System Class 10 MCQ with Answer. Basic DBMS Multiple choice questions with answers pdf.

Are you a student of Class 10 looking for Database Management System Multiple Choice Questions with answers? Look no further! This article is the perfect solution for you.

Here, you will find accurate Database Management System Class 10 MCQs, along with their solutions. Additionally, this article provides an overview of the various topics related to Database Management System in Class 10. Preparing for an examination has never been easier!

Database Management System

What is Database Management System

A Database Management System (DBMS) is a software program that enables you to manage and organize data in a structured manner. It allows you to store, retrieve and manipulate data in an efficient and secure way.

With the increasing reliance on digital information, having a DBMS has become essential for businesses of all sizes.

There are several types of DBMS available today, including relational, object-oriented, hierarchical and network-based systems. Each type has its own unique features and benefits, depending on the specific needs of your organization.

For instance, if you need to process large amounts of data quickly, then a relational database system may be the best option for you.

One major advantage of using a DBMS is that it helps to ensure data accuracy and consistency. This is achieved through the use of data integrity constraints which prevent incorrect or incomplete data from being entered into the database.

Database Management System Class 10 MCQ

1. Administrative the DBMS and related software’s is the responsibility of ___.
a. DBD
b. DBA
c. End users
d. Tool developers
Ans. B

2. Tools are the third party ___ which are not available with the DBMS.
a. Optional software packages
b. Compulsory software packages
c. Designing software packages
d. None of the above
Ans. A

3. In three-scheme architecture which level is independent of both software and hardware.
a. Internal level
b. Conceptual level
c. External level
d. View level
Ans. B

4. ___ is the property that describes an entity.
a. DDL
b. DML
c. Model
d. Attributes
Ans. D

5. ___ processes schema definitions specified in the DDL and stores descriptions of the schema in the DBMS catalog.
a. DDL computer
b. DML computer
c. Run time database processor
d. Query processor
Ans. A

6. A relation database is ___, not design-driven:
a. Relation has driven
b. Query driven
c. Data-driven
d. None of the above
Ans. C

7. Which is the most basic unit of data on the disk?
a. a bit of information
b. a byte of information
c. both a & b
d. None of the above
Ans. A

8. Which techniques permit continuous reading or writing of data on consecutive disk blocks, which eliminates the seek time and rotational delay for all but the first block transfer.
a. Buffering
b. Disk fragmentation
c. Spooling
d. Double buffering Ans. D

9. Hashing for disk files is ___.
a. Chaining
b. Dynamic hashing
c. External hashing
d. None of the above
Ans. C

10. A ___ is an index specified by the ordering key field.

a. First field
b. Second field
c. Primary index
d. None of the above

Ans. C

11. B tree eliminates the ___ storage of search key values.
a. Redundant
b. Unique
c. Disputed
d. None of the above
Ans. A

12. The number of tuples is relations are called?
a. Degree of relation
b. Physical database design
c. The cardinality of the relation
d. Functionality of relation
Ans. C

13. Which kind of schema describes the data type, relationship, and constraints.
a. Conceptual schema
b. Logical schema
c. Internal schema
d. External schema
Ans. A

14. ___ is a “thing” in the real world with an independent existence that is distinguishable from al other objects.
a. Flow
b. Entity
c. Attribute
d. Relation
Ans. B

15. What do we call a set of entities of the same type that share the same properties or attributes.
a. Entity sets
b. Composite entities
c. Multivalue entities
d. Derived entity
Ans. A

16. Each attribute is associated with a set of values called ___.
a. Entities
b. Relations
c. Degree of attribute
d. Domain
Ans. D

17. Attributes which are not divided into subparts are called?
a. Single attributed
b. Atomic attributes
c. Related attributed
d. None of the above
Ans. B

18. Some entity types may not have any key attribute of their own, they are called ___.
a. Existing entity
b. Strong entity
c. Weak entity
d. Relational entity
Ans. B

19. A relation is defined as a set of ___.
a. Entities
b. Tuples
c. Columns
d. Attributes
Ans. B

20. Which mathematical symbol is used to denote the select operator.
a. δ
b. ∑
c. λ
d. σ
Ans. D

21. ___ is used to select only a few columns from a table.
a. Projection operation
b. Intersection operation
c. Both a & b
d. Cartesian product
Ans. A

22. Which symbol is used to denote the rename operator.
a. ρ
b. σ
c. δ
d. λ
Ans. D

23. ___ of relational algebra and relational calculus are equivalent.

a. Tuple
b. Relational power
c. Expressive power
d. None of the above

24. Which clause filters the rows returned by the group by clause?
a. Having clause
b. Order clause
c. Like clause
d. Order by clause
Ans. A

25. The query within a ___ clause is called the inner query or subquery.
a. Order by clause
c. Having clause
d. Order clause
Ans. B

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top