Data Base Management MCQs ( Multiple Choice Question)

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 Overall design of a database is called?





ANSWER= (A) Schema

 

Q.2 How many types of Schema ?





ANSWER= (A) 2

 

Q.3 DBA Stands For ?





ANSWER= (C) Database Administrator

 

Q.4 Who is responsible for the design and development of a Database ?





ANSWER= (C) Database Administrator

 

Q.5 Who is decribe the properties of other data ?





ANSWER= (A) Meta Data

 

Q.6 All the details relted to database design,development & storage are hidden from the user at this evel name is ?





ANSWER= (A) User Level

 

Q.7 All the details relted to database design,development & storage are visible from the user at this evel name is ?





ANSWER= (B) Programmer level

 

Q.8 All the details relted to the storage of database into physical memory{Disk} is hidden for the programmer this name is ?





ANSWER= (B) Programmer level

 

Q.9 who level of the operating system stores and manage the Database ?





ANSWER= (C) System level

 

Q.10 The collection of informtiom stored in the databse at a particular moment is known as ?





ANSWER= (B) Instance

 

Q.11 E-R Model stands for ?





ANSWER= (B) Entity Releationship model

 

Q.12 An Entity





ANSWER= (C) A,B both

 

Q.13 In ER Diagram an entity can be represented as





ANSWER= (B) Rectangle

 

Q.14 A collection of similar kinds of entities is known as ?





ANSWER= (B) Entity set

 

Q.15 The entity set which contain at lest one Primary Key is known as ?





ANSWER= (C) Strong Entity set

 

Q.16 The Entity set which Not contain any primary Key is known as ?





ANSWER= (A) Weak Entity Set

 

Q.17 The Property of Entity ?





ANSWER= (B) Attribute

 

Q.17 The attribute which can uniquely identify an entityfrom the entity set is known as





ANSWER= (A) Key Attribute

 

Q.19 The attribute which can not be devided further is called ?





ANSWER= (B) Simple Attribute

 

Q.20 The attribute which can be devided further is called ?





ANSWER= (A) Composite Attribute