DBMS Day 2 Part 2

Which of the following is not a disadvantage of hierarchical data model?

• Difficulty in managing data with many-to-many relationships

• Inability to handle complex data structures

• Limited flexibility

• Difficulty in handling large data sets

In the hierarchical data model, how are data elements organized?

• In a tree-like structure

• In a network of interconnected nodes

• In a matrix

• In a list

Which of the following is not a type of index in indexed file organization?

• Primary index

• Secondary index

• B-tree index

• Ternary index

In the random file organization, how are records accessed?

• In sequential order

• Using a key

• By the order they were inserted

• In reverse order

In the sequential file organization, how are records stored?

• In no particular order

• In ascending order

• In descending order

• In the order they were inserted

In the network data model, what is a set?

• A table

•  A record

•  A relationship

• A group of related records

In the ER approach, what does a diamond symbol represent?

• Entity

• Attribute

• Relationship

• Key

Which of the following is not a type of relationship in the ER approach?

• One-to-one

• One-to-many

• Many-to-one

• Many-to-many-to-many

In the relational data model, what is a tuple?

• row

• column

• A table

• A key