stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
DBMS 2 ND UNIT Flashcards | StudBud
Explore
/
DBMS 2 ND UNIT
DBMS 2 ND UNIT
20 terms
·
StudBud Administration
·
20 plays
Imported from external platform
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
20. Which of the following is NOT a normalization rule?
d) Data should be structured properly
a) A relation should have a primary key
c) Data should be stored in logical tables
b) Data should be redundant
2
15. What is the term for the number of attributes in a relation?
b) Cardinality
c) Domain
a) Degree
d) Tuple
3
12. Which of the following is NOT an advantage of the Hierarchical Model?
c) Easy modification of structure
b) Security of data
d) Proper ordering of records
a) Fast data access
4
16. The number of rows in a relation is called:
c) Attribute set
d) Key
a) Degree
b) Cardinality
5
18. Which key is a candidate key that is not chosen as the primary key?
c) Composite Key
b) Foreign Key
a) Alternate Key
d) Super Key
6
19. What is a Foreign Key?
b) A key used for sorting data
c) A key that references a primary key in another table
a) A key that uniquely identifies a record
d) A key that can have duplicate values
7
17. Which key uniquely identifies a record in a table?
a) Foreign Key
c) Primary Key
d) Composite Key
b) Candidate Key
8
2. Which of the following is not a type of data model?
d) Cloud model
a) Hierarchical model
b) Network model
c) Relational model
9
3. What does the E-R model primarily focus on?
a) Data retrieval methods
b) Graphical representation of entities and relationships
d) Data encryption techniques
c) File storage structures
10
13. In a Relational Database Model, data is stored in the form of:
a) Graphs
c) Tables
b) Trees
d) Lists
11
4. In an E-R diagram, how is an entity represented?
a) Oval
d) Triangle
c) Rectangle
b) Diamond
12
9. Which type of relationship represents "one entity instance related to multiple instances of another entity"?
b) One-to-One
c) Many-to-Many
d) Many-to-One
a) One-to-Many
13
14. Who developed the Relational Model?
b) Edgar F. Codd
a) Charles Bachman
c) Larry Ellison
d) Michael Stonebraker
14
7. Which of the following is an example of a composite attribute?
a) Age
d) Phone Number
c) Employee ID
b) Name
15
5. Which type of entity does not depend on any other entity?
a) Weak entity
d) Composite entity
b) Strong entity
c) Derived entity
16
1. What is a Data Model in DBMS?
b) A collection of concepts to describe a database structure
a) A collection of programs to manage data
c) A tool for creating user interfaces
d) A programming language
17
10. What does an object in the Object-Oriented Data Model encapsulate?
a) Only attributes
c) Both attributes and methods
d) Only relationships
b) Only methods
18
6. What symbol is used to represent an attribute in an E-R diagram?
a) Rectangle
b) Oval
c) Diamond
d) Triangle
19
11. What is a class in Object-Oriented Data Model?
c) A function to process data
a) A single object
d) A primary key
b) A collection of similar objects
20
8. What type of attribute is derived from another attribute?
c) Key attribute
a) Composite attribute
d) Multi-valued attribute
b) Derived attribute
