Have an account?

Need An Account,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

Sorry, you do not have permission to ask a question, You must login to ask a question. Please subscribe to paid membership

Don't have account,
Please subscribe to paid membership

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Home/ Featured/Basics of DBMS Solved MCQs

Quearn Latest Articles

On: July 6, 2023 Posted in Featured Comments: 0 Views: 213

Basics of DBMS Solved MCQs

1.Which of the following is a Data Model?
A.entity-relationship model
B.relational data model
C.object-based data model
D.all of the above
Answer» D. all of the above

2.A collection of related data.
A.Information
B.Valuable information
C.Database
D.Metadata
Answer» C. Database
Explanation: A database is a collection of related data that is organized and structured in a way that allows for easy access and manipulation. It typically includes data tables, indices, and other components that are used to store, manage, and retrieve data. A database is a useful tool for storing and managing large amounts of structured data, and it is commonly used in a wide range of applications, including business, finance, healthcare, and more.

3.DBMS is software.
A.True
B.False
C.none
D.all
Answer» A. True

4.DBMS manages the interaction between __________ and database.
A.Users
B.Clients
C.End Users
D.Stake Holders
Answer» C. End Users

5.Which of the following is not involved in DBMS?
A.End Users
B.Data
C.Application Request
D.HTML
Answer» D. HTML

6.Database is generally __________
A.System-centered
B.User-centered
C.Company-centered
D.Data-centered
Answer» B. User-centered

7.A characteristic of an entity.
A.Relation
B.Attribute
C.Parameter
D.Constraint
Answer» B. Attribute

8.The restrictions placed on the data.
A.Relation
B.Attribute
C.Parameter
D.Constraint
Answer» D. Constraint

9.IMS stands for?
A.Information Mastering System
B.Instruction Management System
C.Instruction Manipulating System
D.Information Management System
Answer» D. Information Management System

10.A model developed by Hammer and Mc Leod in 1981.
A.SDM
B.OODBM
C.DDM
D.RDM
Answer» A. SDM

 (1)

11.Object=_________+relationships.
A.data
B.attributes
C.entity
D.constraints
Answer» C. entity

12.Duplication of data at several places is called as _______________.
A.Data Inconsistency
B.Data Isolation
C.Atomicity Problem
D.Data Redundance
Answer» D. Data Redundance

13.Data Redundancy increases the cost of storing and retrieving data.
A.False
B.True
C.none
D.all
Answer» B. True

14.Which of the information is not redundant.
A.name
B.mobile
C.account-no
D.address
Answer» C. account-no

15.If in redundant file common fields are not matching then it results in _____________.
A.Data Inconsistency
B.Data Integrity Problem
C.Data Isolation
D.Data Redundancy
Answer» A. Data Inconsistency

16.It is difficult to access conventional file system than Database System.
A.True
B.False
C.none
D.all
Answer» A. True

17.An ________ is a set of entities of the same type that share the same properties, or attributes.
A.Entity set
B.Attribute set
C.Relation set
D.Entity model
Answer» A. Entity set

18.Entity is a _________
A.Object of relation
B.Present working model
C.Thing in real world
D.Model of relation
Answer» C. Thing in real world

19.The descriptive property possessed by each entity set is _________
A.Entity
B.Attribute
C.Relation
D.Model
Answer» B. Attribute

20.The function that an entity plays in a relationship is called that entity’s _____________
A.Participation
B.Position
C.Role
D.Instance
Answer» C. Role

21.The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
A.Simple attribute
B.Composite attribute
C.Multivalued attribute
D.Derived attribute
Answer» B. Composite attribute

22.In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.
A.Desciptive
B.Derived
C.Recursive
D.Relative
Answer» A. Desciptive

23.Object based logical model(s) are used to describe data at – [Select Appropriate Option(s)]
A. Level
B.Logical Level
C.Physical Level
D.None of these
Answer» C. Physical Level

24.Which of the following is example of Object based logical model ?
A.Relational Model
B.Hierarchical Model
C.Network Model
D.Entity Relationship Model
Answer» D. Entity Relationship Model

 (1)

26.Which of the following gives a logical structure of the database graphically?
A.Entity-relationship diagram
B.Entity diagram
C.Database diagram
D.Architectural representation
Answer» A. Entity-relationship diagram

27.Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
A.One to many
B.One to one
C.Many to many
D.Many to one
Answer» B. One to one

28.We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________
A.Diamond , diamond
B.Rectangle, diamond
C.Rectangle, rectangle
D.Diamond, rectangle
Answer» D. Diamond, rectangle

29.An entity set that does not have sufficient attributes to form a primary key is termed a __________
A.Strong entity set
B.Variant set
C.Weak entity set
D.Variable set
Answer» C. Weak entity set

30.For a weak entity set to be meaningful, it must be associated with another entity set, called the
A.Identifying set
B.Owner set
C.Neighbour set
D.Strong entity set
Answer» A. Identifying set

31.If you were collecting and storing information about your music collection, an album would be considered a(n) _____
A.Relation
B.Entity
C.Instance
D.Attribute
Answer» B. Entity

32.What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
A.Relation
B.Instance
C.Table
D.Column
Answer» B. Instance

33._____________ can help us detect poor E-R design.
A.Database Design Process
B.E-R Design Process
C.Relational scheme
D.Functional dependencies
Answer» D. Functional dependencies

34.If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
A.A many-to-many relationship set
B.A multivalued attribute of an entity set
C.A one-to-many relationship set
D.Both A many-to-many relationship set and A multivalued attribute of an entity set
Answer» D. Both A many-to-many relationship set and A multivalued attribute of an entity set

35.Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
A.A many-to-many relationship set
B.A multivalued attribute of an entity set
C.A one-to-many relationship set
D.All of the mentioned
Answer» A. A many-to-many relationship set

36.In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
A.A many-to-many relationship set
B.A multivalued attribute of an entity set
C.A one-to-many relationship set
D.All of the mentioned
Answer» B. A multivalued attribute of an entity set

37.Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
A.Unique-role assumption
B.Unique-key assignment
C.Role intergral assignment
D.None of the mentioned
Answer» A. Unique-role assumption

38.Designers use which of the following to tune the performance of systems to support timecritical operations?
A.Denormalization
B.Redundant optimization
C.Optimization
D.Realization
Answer» A. Denormalization

39.In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which dependency have lead to this relation ?
A.Dept name, year->size
B.Year->size
C.Dept name->size
D.Size->year
Answer» A. Dept name, year->size

40.Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
A.Fourth NF
B.BCNF
C.Third NF
D.Second NF
Answer» B. BCNF

41.Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
A.Instance
B.Snapshot
C.Both Instance and Snapshot
D.All of the mentioned
Answer» B. Snapshot

42.Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
A.Cross-tabs
B.Snapshot
C.Both Cross-tabs and Snapshot
D.All of the mentioned
Answer» A. Cross-tabs

43.Data Model is collection of conceptual tools for describing –
A.Data
B.All of these
C.Data Schema
D.Consistency Constaints
Answer» B. All of these

44.Data Models in DBMS are classified into ______ categories.
A.3
B.2
C.5
D.4
Answer» C. 5
BasicsMCQ
Previous article
Next article

You must login to add a comment.

Need An Account,