Data Base Management System MCQs

by

Hello Friends !!! I am from quickstudyhelper.com. In today’s post, we are going to see very important ‘Data Base Management System MCQs | BCE MCQs’ which help you in your examination.

RGPV Unit – 5 Data Base Management System MCQs

Q1. ______ is a repository or collection of logically related and similar data.

  1. DBMS
  2. Database
  3. File
  4. Entity

Answer:- 2) Database

Q2. The information stored inside a database is represented using

  1. Data modeling
  2. Database
  3. File system
  4. Entity

Answer:- 1) Data modeling

Q3. ______ is the physical device on which the database system resides.

  1. Software
  2. Hardware
  3. Hard disk
  4. CPU

Answer:- 2) Hardware

Q4. ______ handles requests from the users to access the database for addition, deletion, or retrieval data.

  1. DBMS
  2. Database
  3. File
  4. Entity

Answer:- 1) DBMS

Q5. ______ implies that several distinct data files are unified in a manner that redundancy among these data files is wholly or partially eliminated.

  1. Integrated data
  2. Data
  3. DBMS
  4. Files data

Answer:- 1) Integrated data

Q6. ______ implies that the data stored in the database can be shared among multiple users.

  1. Integrated data
  2. Share data
  3. DBMS
  4. Files data

Answer:- 2) Share data

Q7. ______ means storing the same data at multiple locations.

  1. Data inconsistent
  2. Database
  3. Data isolation
  4. Data redundancy

Answer:- 4) Data redundancy

Q8. ______ means having different data values for the common fields in different files.

  1. Data inconsistent
  2. Database
  3. Data isolation
  4. Data redundancy

Answer:- 1) Data inconsistent

Q9. ______ approach provides solutions for handling the problems of the file system approach.

  1. Data modeling
  2. Database
  3. File system
  4. Entity

Answer:- 2) Database

Q10. Minimizing data redundancy using database system ______ data inconsistency too.

  1. Reduces
  2. More
  3. Moderate
  4. Zero

Answer:- 1) Reduces

Q11. ______ means sharing the same data among more than one user.

  1. Data sharing
  2. Database
  3. Data isolation
  4. Data redundancy

Answer:- 1) Data sharing

Q12. ______ is the separation of data description metadata from the application programs that use the data.

  1. Share data
  2. Data independent
  3. Data dependent
  4. Data security

Answer:- 2) Data independent

Q13. ______ definition is maintained in the data dictionary.

  1. Data constraint
  2. Database
  3. Data isolation
  4. Data redundancy

Answer:- 1) Data constraint

Q14. ______ and recovery are supported by the software that logs change to the database.

  1. Backup
  2. Startup
  3. Redundancy
  4. Isolation

Answer:- 1) Backup

Q15. The ______ describes the structure of the database.

  1. Data model
  2. Database
  3. File system
  4. Entity

Answer:- 1) Data model

Q16. The data models are generally divided into ______ categories.

  1. 5
  2. 3
  3. 1
  4. 6

Answer:- 2) 3

Q17. ______ is the logical structure of the database.

  1. Schema
  2. Coherent
  3. Virtual
  4. Instances

Answer:- 1) Schema

Q18. ______ are the actual data contained in the database at a particular point in time.

  1. Schema
  2. Coherent
  3. Virtual
  4. Instances

Answer:- 4) Instances

Q19. The content of the database may change from time to______

  1. Many times
  2. One time
  3. Time
  4. Three time

Answer:- 3) Time

Q20. Ensures that all the functional and data required of the users are______

  1. Specific
  2. Unspecific
  3. Actual
  4. Consistent

Answer:- 1) Specific

Q21. An ______ is the basic unit for modeling.

  1. DBMS
  2. Database
  3. File
  4. Entity

Answer:- 4) Entity

Q22. An ______ describes some property or characteristics of the entity.

  1. Entity
  2. Attributes
  3. Database
  4. DBMS

Answer:- 2) Attributes

Q23. Diagrammatically an attribute is represented as an ______ connected to the entity with a line.

  1. Hyperbola
  2. Ellipse
  3. Parabola
  4. Circle

Answer:- 2) Ellipse

Q24. An association or link between two entities is represented using a ______

  1. Relationship
  2. Attribute
  3. Entity
  4. None of these

Answer:- 1) Relationship

Q25. ______ model is a model of the real world.

  1. ER model
  2. TR model
  3. RT model
  4. RT model

Answer:- 1) ER model

Q26. The Conceptual Data Model is transformed into the ______ Data Model.

  1. Representation
  2. Presentation
  3. Database
  4. Attribute

Answer:- 1) Representation

Q27. The Relational Database Model was proposed in the year.

  1. 1987
  2. 1985
  3. 1970
  4. 1975

Answer:- 3) 1970

Q28. A relational database model is the most common type of ______ model.

  1. Database
  2. DBMS
  3. Both 1 & 2
  4. None of these

Answer:- 1) Database

Q29. The Hierarchical Database Model was developed by.

  1. BMI
  2. MBT
  3. NET
  4. IBM

ANSWER:- 1) BMI

Q30. The schema of a hierarchical database is represented ______ structure diagram

  1. linear
  2. coplanar
  3. tree
  4. hexagonal

Answer:- 3) tree

Q31. The schema is based on ______relationship.

1. Parent-child
2. Grandparents child
3. Manager
4. Child parent

Answer:- 1) Parent-child

Q32. The Network Database Model was formalized by 

1. ARPNET
2. DBTG
3. COI
4. IDMS

Answer:- 2) DBTG

Q33. The view of total database content is

1.conceptual view
2. internal view
3. external view
4. physical view

Answer:- 1) conceptual view

Q34. Architecture of the database can be viewed as

1. two levels
2. four levels
3. three levels
4. one level

Answer:- 3) three levels

Q35. In a relational model, relations are termed as

1. tuples
2. attributes
3. tables
4. rows

Answer:- 3) tables

Also Read –

Q36. The database schema is written in

1. HLL
2. DML
3. DDL
4. DCL

Answer:- 3) DDL

Q37. In the architecture of a database system, the external level is the

1. physical level
2. logical level
3. conceptual level
4. view level

Answer:- 4) view level

Q38. The method of file organization in which data records in a file are arranged in a specified order according to the key field is known as the

1. sequential access method
2. queuing method
3. predetermined method
4. direct access method

Answer:- 1) sequential access method

Q39. Which of the following is not a  storage manager component

1. Transaction manager
2. Logical manager
3. File manager
4. Database manager

Answer:- 2) Logical manager

Q40. In an entity-relationship diagram, rectangles represent

1. Entity set
2. Attributes
3. Table
4. Database

Answer:- 1) Entity set

Q41. Which of the following is not a function of DBA?

1. Network Maintenance
2. Routine Maintenance
3. Schema Definition
4. Authorization for data access

Answer:- 1) Network Maintenance

Q42. Which of the following is a Data Model?

1. Entity-Relationship model
2. Relational data model
3. Object-Based data model
4. All of the above

Answer:- 4) All of the above

Q43. Which of the following represents a relationship among a set of values.

1. A Row
2. A Table
3. A Field
4. A Column

Answer:- 1) A Row

Q44. Column header is referred as

1. Table
2. Relation
3. Attributes
4. Domain

Answer:-  3) Attributes

Q45. In precedence of set operators the expression is evaluated from:

1. Left to Left
2. Left to Right
3. Right to Right
4. Right to Left

Answer:- 2) Left to Right

Q46. In DBMS FD stands for

1. Facilitate data
2. Functional data
3. Facilitate dependency
4. Functional dependency

Answer:- 4) Functional dependency

Q47. How many types of keys in
Database Design?

1. Candidate key
2. Primary key
3. Foreign key
4. All of these

Answer:- 4) All of these

Q48. Which of the following is based on
Multi-Valued Dependency?

1. First
2. Second
3. Third
4. Fourth

Answer:- 2) Second

Q49. The data model which describes how the data is actually stored is

1. Internal model
2. External model
3. Logical model
4. None of these

Answer:- 1) Internal model

Q50. Which one is an example of a network database?

1. Unify
2. Ingress
3. IDMS
4. None of the above

Answer:- 3) IDMS

Q51. Information and data are closely

1. Related
2. Different
3. More same
4. Totally different

Answer:- 1) Related

Q52. Database is a structured collection of

1. DBMS
2. Database
3. File
4. Data

Answer:- 4) Data

Q53. ______ allow multiple users to access and share the data at the same time.

1. Entity
2. Attributes
3. Database
4. DBMS

Answer:- 3) Database

Q54. A ______ System is a collection of programs that performs service for the end-user.

1. File
2. Data
3. Attributes
4. Entity

Answer:- 1) File

Q55. Each program of an application in the file-based approach ______ set of data.

1. Multiple data
2. Single data
3. Own data
4. Zero data

Answer:- 3) Own data

Q56. When data is scattered in a separate file it is ______ to access required data.

1. More difficult
2. Easy to take
3. Difficult
4. None of these

Answer:- 1) More difficult

Q57. The centralized store and manage data which can be exceeded and stored by the ______user.

1. Multiple
2. Single
3. Own
4. Zero

Answer:- 1) Multiple

Q58. DBMS is ……… software.

1. Not expensive
2. Expensive
3. Moderate
4. None of these

Answer:- 2) Expensive

Q59. Database management system processing speed is

1. Slow
2. Fast
3. Very slow
4. Zero

Answer:- 1) Slow

Q60. Set of operations to be performed on the ……..

1. Files
2. Data
3. DBMS
4. Entity

Answer:- 2) Data

Q61. Model data classify into

1. Two categories
2. Three categories
3. Five categories
4. One category

Answer:- 1) Two categories

Q62. The hierarchical model was developed in the year

1. 1965
2. 1987
3. 1985
4. 1960

Answer:- 4) 1960

Q63. Which of the following data model schema is represented using a tree-structured diagram?

1. Network data model
2. Hierarchical data model
3. Relational data model
4. Object-oriented data model

Answer:- 2) Hierarchical data model

Q64. Which of the following data model schema is based on the owner-member relationship?

1. Network data model
2. Hierarchical data model
3. Relational data model
4. Object-oriented data model

Answer:- 2) Network data model

Q65. Data dictionary keeps track of the

1. Structure of the database.
2. Relationships between the data structures.
3. Constraints applied to the data.
4. All of the above.

Answer:- 3) All of the above.

Q66. SQL is a

1. DML
2. DDL
3. DCL
4. All of the above

Answer:- 4) All of the above

Q67. Entity

1. is a real-world object
2. describes some properties
3. uniquely identifies the relations
4. none of the above

Answer:- 1) is a real-world object

Q68. Information is a

1. piece of fact
2. real-world object
3. processed data
4. none of the above

Answer:- 3) processed data

Q69. The number of attributes in a relation is said to be its

1. degree
2. cardinality
3. domain
4. link

Answer:- 1) degree

Q70. Data integrity refers to

1. Non-duplication of data
2. Accuracy of data
3. Security of data
4. Centralized data

Answer:- 2) Accuracy of data

Q71. Which of the following is not the component of a relational database?

1. Entity
2. Attribute
3. Table
4. Hierarchy

Answer:- 4) Hierarchy

72. The attribute that uniquely identifies the instances of the relation are called

1. Secondary key
2. Foreign key
3. Identifier
4. Primary key

Answer:- 4) Primary key

Q73. Which of the schema describes the storage structure of the database?

1. Internal
2. External
3. Logical
4. None of the above

Answer:- 1) Internal

Q74. Which of the following data model uses a collection of tables for storing the data?

1. Hierarchical
2. Network
3. Relational
4. Object-oriented

Answer:- 3) Relational

Q75. Which of the following ensures integrity?

1. Data
2. Constraints
3. Relationship
4. Schema

Answer:- 2) Constraints

If you need any help from us or you want to give any suggestion to us, then definitely talk to us.

You can also follow us on social media. You will find our social media links at the end of the page

Feel Free to talk with us on WhatsApp – Click Here

I hope you liked this post ‘Reciprocating Machines MCQs | BME MCQs’. More resources and study material are available at Quickstudyhelper.com.

Stay Updated, Stay Safe, Stay Healthy

Thank You!

Leave a Comment