Understanding File Systems and DBMS

What is a file system?

• A file system is a programming language used for data manipulation.

• A file system is a hardware component of a computer.

• A file system is a type of software application.

• A file system is a method for storing and organizing files on a storage device.

How does a file system organize data?

• A file system stores data in a flat structure without directories.

• A file system uses a random access method without any hierarchy.

• A file system organizes data solely based on file size.

• A file system organizes data into a hierarchy of files and directories, maintaining metadata for efficient retrieval.

What are the main differences between a file system and a DBMS?

• File systems manage files and directories, while DBMSs manage structured data with relationships and support complex queries.

• File systems can handle complex queries like DBMSs do.

• File systems are only for storing images, while DBMSs are for text files.

• DBMSs are faster than file systems for all types of data access.

What is meant by data models in the context of databases?

• Data models are only used for data visualization.

• Data models are irrelevant to database performance.

• Data models define the structure, organization, and relationships of data in databases.

• Data models only describe the physical storage of data.

Can you name a common database language?

• SQL

• JavaScript

• CSS

• HTML

What are the primary services provided by a Database Management System?

• User interface design

• Network management

• Data storage, retrieval, manipulation, security, and integrity.

• Data analysis and reporting

What is the purpose of a data dictionary in a database?

• To serve as a backup for the database files.

• To store only the raw data without any metadata.

• To optimize the performance of database queries.

• The purpose of a data dictionary in a database is to provide a comprehensive description of the data elements, their relationships, and usage.

Define an entity in the context of an E-R model.

• An entity is a random collection of data without any attributes.

• An entity is a type of relationship between two objects.

• An entity is a graphical representation of data flow in a system.

• An entity is a distinct object or concept in an E-R model that has attributes and can be identified.

What is the relationship between entities in an E-R model?

• Entities in an E-R model are connected through physical links.

• Entities in an E-R model are independent and do not interact.

• Entities in an E-R model are connected through relationships that define their interactions.

• Entities in an E-R model are only defined by their attributes.

How does the Enhanced Entity Relationship Model differ from the basic E-R model?

• The EER model simplifies relationships by removing attributes.

• The EER model is only used for small databases, unlike the basic ER model.

• The EER model includes advanced features like specialization, generalization, and categories, which are not present in the basic ER model.

• The basic ER model includes features like specialization and generalization.