Hey Guys Welcome CSE Study247
This page provide you Data Base Management System Multiple Choice Question With Answer , That is very useful of many exam like Semester, DRDO, ISRO, Railway, Banking , Gate Etc.
✍ These MCQ on a Database Architecture & ER-MODEL
Q.1 The overall design or structure of a database is called a?
Schema
View
Table
None
Explanation
A database schema is the skeleton structure that represents the logical view of the entire database.
Q.2 How many primary types of Database Schemas are usually discussed (Physical and Logical)?
2
3
4
None
Explanation
Database schemas are generally divided into two types: Logical Schema and Physical Schema.
Q.3 What does the acronym DBA stand for?
Database Admin
Data Administrator
Database Administrator
None
Explanation
DBA stands for Database Administrator, the person responsible for managing and maintaining the database.
Q.4 Who is primarily responsible for the design, development, and maintenance of a Database?
Database Admin
Data Administrator
Database Administrator
None
Explanation
The Database Administrator (DBA) manages the database’s integrity, security, and overall performance.
Q.5 Data that describes the properties and structure of other data is known as?
Meta Data
Data Administrator
Database
None
Explanation
Meta data is ‘data about data’, such as definitions of tables, columns, and constraints.
Q.6 At which level are all the complex details related to database design and storage hidden from the end user?
User Level
Programmer level
System level
None
Explanation
The User Level (External Level) provides a simplified view of the data, hiding the underlying complexity.
Q.7 At which level are the details of database design and logical structure visible to the developer?
User Level
Programmer level
System level
None
Explanation
The Programmer Level (Conceptual Level) describes what data is stored and the relationships among those data points.
Q.8 The details regarding the physical storage of data on a disk are typically hidden from the programmer at the?
User Level
Programmer level
System level
None
Explanation
Abstraction ensures that the programmer interacts with logical structures without needing to manage physical disk sectors.
Q.9 Which level is responsible for the actual storage and management of the database by the operating system?
User Level
Programmer level
System level
None
Explanation
The System Level (Physical/Internal Level) manages how the data is physically stored on the hardware.
Q.10 The collection of information stored in a database at a specific point in time is called a(n)?
Schema
Instance
System
None
Explanation
While the schema is the design, the instance is the actual data present in the database at a specific moment.
Q.11 What does the acronym E-R Model stand for?
Entry Relation model
Entity Relationship model
Entity Relationship mode
None
Explanation
The Entity-Relationship (ER) model is a high-level conceptual data model used in database design.
Q.12 In database terms, what is an 'Entity'?
Any real-world object
A specific person or thing
Both A & B
None
Explanation
An entity is a ‘thing’ or ‘object’ in the real world that is distinguishable from other objects.
Q.13 In an ER Diagram, an entity is graphically represented by which shape?
Circle
Rectangle
Oval
None
Explanation
Rectangles are used in ER diagrams to represent entity sets.
Q.14 A collection of similar kinds of entities is known as a(n)?
Entity
Entity set
Strong Entity
None
Explanation
An entity set is a group of entities of the same type that share the same properties or attributes.
Q.15 An entity set that possesses a primary key and can stand alone is called a?
Weak Entity Set
Entity set
Strong Entity set
None
Explanation
A strong entity set has sufficient attributes to uniquely identify its entities using a primary key.
Q.16 An entity set that does not have a primary key of its own is known as a?
Weak Entity Set
Entity set
Strong Entity set
None
Explanation
A weak entity set depends on a ‘strong’ owner entity for its identification.
Q.17 What is the term for a property or characteristic of an entity?
Entity set
Attribute
Domain
None
Explanation
Attributes are the descriptive properties possessed by each member of an entity set.
Q.18 An attribute that uniquely identifies an entity within an entity set is called a?
Key Attribute
Simple Attribute
Domain
None
Explanation
Key attributes (like an ID number) are used to distinguish one entity from another.
Q.19 An attribute that consists of a single component and cannot be divided further is a?
Composite Attribute
Simple Attribute
Domain
None
Explanation
Simple attributes (like Age) are atomic and cannot be broken down into smaller sub-parts.
Q.20 An attribute that can be further divided into smaller sub-parts is called a?
Composite Attribute
Simple Attribute
Domain
None
Explanation
Composite attributes (like Name, which can be divided into First Name and Last Name) consist of multiple sub-attributes.