1. Which of the following is a logical model in database design?
A. Relational model
B. Physical model
C. Columnar model
D. File system model
Answer: A
Rationale: The relational model is a logical model in database design, where data is
stored in tables and manipulated using SQL.
2. The many-to-one relationship in a database means:
A. Many records in one table can correspond to one record in another table.
B. One record in a table corresponds to many records in another table.
C. A record in one table corresponds to a unique record in another table.
D. One record in a table corresponds to no records in another table.
Answer: A
,Rationale: A many-to-one relationship means that many records in one table can
correspond to a single record in another table.
3. Which of the following is a primary characteristic of a relational database?
A. Data is stored in tables, which are related to each other.
B. Data is stored in files.
C. Data is stored in objects.
D. Data is stored in nodes.
Answer: A
Rationale: A relational database stores data in tables, with relationships between
those tables defined by keys. Each table consists of rows and columns, and data is
organized in a way that facilitates easy retrieval and manipulation.
4. Which of the following is a feature of Object-Oriented Databases?
A. Support for complex data types and inheritance.
B. Tables and rows for data storage.
C. Strict use of foreign keys.
D. Schema-less storage.
, Answer: A
Rationale: Object-oriented databases support complex data types, inheritance, and
encapsulation, storing data as objects that can represent real-world entities more
naturally than relational databases.
5. What is the main advantage of using normalized tables?
A. Data redundancy is minimized.
B. It allows for faster queries.
C. Data is stored in a denormalized form.
D. It makes the database schema more complex.
Answer: A
Rationale: Normalized tables minimize data redundancy, ensuring that the data is
stored efficiently and reducing anomalies related to data manipulation.
6. What does SQL GROUP BY do?
A. Groups rows that have the same values into summary rows.
B. Sorts the rows in the result set.
C. Combines multiple tables into a single result.
A. Relational model
B. Physical model
C. Columnar model
D. File system model
Answer: A
Rationale: The relational model is a logical model in database design, where data is
stored in tables and manipulated using SQL.
2. The many-to-one relationship in a database means:
A. Many records in one table can correspond to one record in another table.
B. One record in a table corresponds to many records in another table.
C. A record in one table corresponds to a unique record in another table.
D. One record in a table corresponds to no records in another table.
Answer: A
,Rationale: A many-to-one relationship means that many records in one table can
correspond to a single record in another table.
3. Which of the following is a primary characteristic of a relational database?
A. Data is stored in tables, which are related to each other.
B. Data is stored in files.
C. Data is stored in objects.
D. Data is stored in nodes.
Answer: A
Rationale: A relational database stores data in tables, with relationships between
those tables defined by keys. Each table consists of rows and columns, and data is
organized in a way that facilitates easy retrieval and manipulation.
4. Which of the following is a feature of Object-Oriented Databases?
A. Support for complex data types and inheritance.
B. Tables and rows for data storage.
C. Strict use of foreign keys.
D. Schema-less storage.
, Answer: A
Rationale: Object-oriented databases support complex data types, inheritance, and
encapsulation, storing data as objects that can represent real-world entities more
naturally than relational databases.
5. What is the main advantage of using normalized tables?
A. Data redundancy is minimized.
B. It allows for faster queries.
C. Data is stored in a denormalized form.
D. It makes the database schema more complex.
Answer: A
Rationale: Normalized tables minimize data redundancy, ensuring that the data is
stored efficiently and reducing anomalies related to data manipulation.
6. What does SQL GROUP BY do?
A. Groups rows that have the same values into summary rows.
B. Sorts the rows in the result set.
C. Combines multiple tables into a single result.
