Evaluación: Esquemas Conceptuales en Bases de Datosse Quiz

What does a conceptual schema represent in a database?

• A set of SQL instructions.

• An abstract and high-level representation of data and its relationships.

• A physical data storage structure.

• A database user interface model.

How does a conceptual schema depend on the database software?

• It requires specific extensions to be used.

• It depends completely for its execution.

• It is a built-in function in the software.

• It does not depend; it is independent of the database software.

What are entities in a conceptual schema?

• The queries made to the database.

• The end users of the database.

• Objects from the real world represented in the database.

• The operations that can be performed in the database.

What characterizes attributes in a conceptual schema?

• They are the operations allowed on the data.

• They are characteristics or properties of the entities.

• They are the data types available in the database.

• They are mathematical functions applied to the data.

What do relationships represent in a conceptual schema?

• Associations between different entities.

• Commercial transactions between entities.

• The physical connections between storage devices.

• Possible queries in a programming language.

What is the main benefit of using a conceptual schema in managing a library?

• Increasing the complexity of queries.

• Increasing the physical storage size.

• Improving the efficiency and organization of its operations.

• Reducing the number of books in the library.

What level of detail is typically found in a conceptual schema?

• Low-level details about programming.

• High level of abstraction without implementation details.

• Specific hardware instructions.

• Error codes and troubleshooting solutions.

Why is it important for a conceptual schema to be independent of the physical implementation?

• To simplify the graphic design of the database.

• To ensure its applicability in different systems and technologies.

• To limit access to developers.

• To increase hardware dependency.

In a conceptual schema, what is the logical connection between two entities called?

• An attribute.

• A method.

• A relationship.

• A function.

What is sought to be achieved by creating a conceptual schema for a database?

• Decreasing the amount of necessary data.

• Providing a clear framework for understanding the data structure.

• Establishing security parameters for data access.

• Encoding the database in a specific programming language.