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?
- A) Schema
- B) View
- C) Table
- D) None
Q.2 How many primary types of Database Schemas are usually discussed (Physical and Logical)?
- A) 2
- B) 3
- C) 4
- D) None
Q.3 What does the acronym DBA stand for?
- A) Database Admin
- B) Data Administrator
- C) Database Administrator
- D) None
Q.4 Who is primarily responsible for the design, development, and maintenance of a Database?
- A) Database Admin
- B) Data Administrator
- C) Database Administrator
- D) None
Q.5 Data that describes the properties and structure of other data is known as?
- A) Meta Data
- B) Data Administrator
- C) Database
- D) None
Q.6 At which level are all the complex details related to database design and storage hidden from the end user?
- A) User Level
- B) Programmer level
- C) System level
- D) None
Q.7 At which level are the details of database design and logical structure visible to the developer?
- A) User Level
- B) Programmer level
- C) System level
- D) None
Q.8 The details regarding the physical storage of data on a disk are typically hidden from the programmer at the?
- A) User Level
- B) Programmer level
- C) System level
- D) None
Q.9 Which level is responsible for the actual storage and management of the database by the operating system?
- A) User Level
- B) Programmer level
- C) System level
- D) None
Q.10 The collection of information stored in a database at a specific point in time is called a(n)?
- A) Schema
- B) Instance
- C) System
- D) None
Q.11 What does the acronym E-R Model stand for?
- A) Entry Relation model
- B) Entity Relationship model
- C) Entity Relationship mode
- D) None
Q.12 In database terms, what is an 'Entity'?
- A) Any real-world object
- B) A specific person or thing
- C) Both A & B
- D) None
Q.13 In an ER Diagram, an entity is graphically represented by which shape?
- A) Circle
- B) Rectangle
- C) Oval
- D) None
Q.14 A collection of similar kinds of entities is known as a(n)?
- A) Entity
- B) Entity set
- C) Strong Entity
- D) None
Q.15 An entity set that possesses a primary key and can stand alone is called a?
- A) Weak Entity Set
- B) Entity set
- C) Strong Entity set
- D) None
Q.16 An entity set that does not have a primary key of its own is known as a?
- A) Weak Entity Set
- B) Entity set
- C) Strong Entity set
- D) None
Q.17 What is the term for a property or characteristic of an entity?
- A) Entity set
- B) Attribute
- C) Domain
- D) None
Q.18 An attribute that uniquely identifies an entity within an entity set is called a?
- A) Key Attribute
- B) Simple Attribute
- C) Domain
- D) None
Q.19 An attribute that consists of a single component and cannot be divided further is a?
- A) Composite Attribute
- B) Simple Attribute
- C) Domain
- D) None
Q.20 An attribute that can be further divided into smaller sub-parts is called a?
- A) Composite Attribute
- B) Simple Attribute
- C) Domain
- D) None