Computer DataBase Management system Mcqs | BS Computer MCQS
Mcqs of database management for BS Bsc and MCS
1. A database is an organized collection of __________ related data.
a. Logically
b. Physically
c. Loosely
d. Badly
2. The objectives of database management systems include:
a. Database integrity
b. Data integration
c. Availability
d. All
3. Data that causes inconsistency lacks:
a. Good data
b. Data integrity
c. Data redundancy
d. Data anomaly
4. The major component of DBMS is called:
a. Database manager
b. File manager
c. Data manager
d. All
5. Which of the following enables the user to modify data structures without affecting existing programs that use them?
a. Data dependence
b. Data independence
c. Data integration
d. Data
relationships
6. Which one of the following is an advantage of database management approach?
a. Program data independence b. Reduced security
c. Increased Duplication of data
d. None
7. A set of related files created and managed by a DBMS is called:
a. Field
b. Record
c. Database
d. None
8. Roll No of a student should be stored in a
a. Record
b. Field
c. Cell
d. File
9. Which of the three schemas used in three-schema model is a complete logical view of database?
a. External
b. Internal
c. Implementation
d. Conceptual
10. The older logical database model that organizes data in a tree like structure is
a. Hierarchical
b. Network
c. Relational
d. Object
11. DBA stands for
a. Database Administrator
b. Database Application
c. Database Authority
d. None
12. The advantage of partitioning is
a. Efficiency
b. Extra space and update time
c. Both A and B
d. None
13. Basic data distribution strategies include:
a. Centralized
b. Partitioned
c. Replication
d. All
14. Characteristics of an entity are called
a. Entity
b. Attribute
c. Identifier
d. Relationship
15. Which of the following represent entities?
a. Teacher
b. Student
c. Doctor
d. All
16. An identifier may be
a. Unique
b. Non-unique
c. Composite
d. All
17. A single-entity instance of one type related to a single-entity instance of another type?
a. One to one Relationship
b. One to many Relationship
c. Many to many relationship
d. None
18. A single-entity instance of one type related to many entity instances of another type?
a. One to one relationship
b. One to many relationship
c. Many to many relationship
d. None
19. Many entity instances of one type be related to many entity instances of another type?
a. One to one relationships
b. One to many relationship
c. Many to many relationship
d. None
20. Which of the following is a one to many relationship?
a. Student Reg_No
b. Person_Automobilec. Mother_Sond. Both b and c
21. Which of the following is related to modality?
a. Optional
b. Mandatory
c. Unidirectional
d. Both a and b
22. A relationship consists of three entities are called
a. Unary
b. Binary
c. Ternary
d. None
23. ________ indicates the maximum number of entities that can be involved in a relationship?
a. Minimum cardinality
b. Maximum cardinality
c. Both a and b
d. None
24. In an E-R Diagram, an ellipse represents an:
a. Entity class
b. Weak entity
c. Relationship
d. Attribute
25. An attribute which consists of a group of attributes is called
a. Multi-valued attributes
b. Composite attributes
c. Composite identifiers
d. Identifiers
26. _________ refers to relationships that are subtypes, when the identifiers of the entities are
same.
a. HAS-A relationships
b. IS-A relationships
c. Binary Relationships
d. None
27. An entity type whose existence depends on another entity is called _________ entity.
a. Strong
b. Weak
c. Dependent
d. Variant
28. An identifier of an entity instance:
a. May be unique
b. Must be unique
c. May consist of more than one attribute d. a and c
29. _______ refers to the degree of relationship.
a. Number of entities
b. Maximum cardinality
c. Minimum cardinality
d. None
30. The type of attribute that is composed of other attributes?
a. Simple
b. Meta
c. Group
d. Compound
31. Composite and compound objects together known as:
a. Hybrid objects
b. Association objects
c. Subtype objects
d. Archetype objects
32. Which of the following contains at least one object attribute?
a. Simple objects
b. Composite objects
c. Compound objects
d. Hybrid objects
33. Which of the following are used to represent the specialization of objects?
a. Hybrid objects
b. Association objects
c. Subtype objects
d. Archetype objects
34. Which of the following refers to an attribute whose maximum cardinality is 1?
a. Multi value attribute
b. Non-object attribute
c. Paired attribute
d.Single value attribute
35. A group identifier
a. Has more than one attribute
b. Identifies a group of instances
c. Identifies a group of attributes in an object
d. Is the identifier for a group of
semantic objects
36. Foreign key is found in
a. Parent table
b. Dependent table
c. Pivot table
d. Index table
37. Two dimensional table consists of a data is called
a. Group b. Set c. Declaration d. Relation
38. An index can be used to:
a. Improve the performance of the database
b. Document the structure of the database itself
c. Reduce data dependency for application programs
d. All
39. Which of the following are properties of relations?
a. Each attribute has a unique name
b. No two rows are identical
c. No multivalued attributes
d. All
40. How many primary keys can a table have?
a. One
b. At-least one but not more than two
c. No limit
d. None of above
41. Choose the most appropriate primary key?
a. Student’s name
b. Student’s address
c. Student DOB
d. Student’s Reg_No
42. A candidate key is
a. Primary key
b. Primary key selected to be the key of a relation
c. An attribute or group of attributes that can be the primary key
d. All
43. In 2NF, which dependency is removed?
a. Functional
b. Partial
c. Associative
d. Transitive
44. In 3NF, which dependency is removed?
a. Functional
b. Partial
c. Associative
d. Transitive
45. Each foreign key value must match a primary key value in the other relation is called:
a. Referential integrity constraint
b. Entity key group rule
c. Both
d. None
46. Different attributes in two different tables having same name as referred to as:
a. Synonym
b. Homonym
c. Acronym
d. Mutually Exclusive
47. In functional dependency, the attribute on the left side is called:
a. Candidate key
b. Determinant
c. Foreign key
d. Primary key
48. The main purpose of normalization is to:
a. Increase relations
b. Remove anomalies
c. Increase Redundancy
d. None
49. A functional dependency between two or more non-key attributes is called:
a. Partial dependency
b. Partial non-key dependency
c. Transitive dependency
d. None
50. Restrictions and checks on a relation are called:
a. Deletion anomaliesa
b. Insertion anomalies
c. Modification anomalies
d. Referential integrity constraints
