FUNDAMENTALS OF DATABASE SYSTEMS

Which of the following is NOT a core concept in data modeling?

• Entities

• Attributes

• Normalization

• Relationships

Which database type is best suited for handling highly structured data with complex relationships?

• NoSQL

• Relational

• Relational

• Hierarchical

Which of the following is a key benefit of database normalization?

• Increased data redundancy

• Improved data integrity

• More complex queries

• Slower data retrieval

Which SQL command is used to modify the structure of an existing table?

• CREATE

• ALTER

• UPDATE

• INSERT

What does DML stand for in the context of SQL?

• Data Manipulation Language

• Data Modeling Language

• Database Management Language

• Data Definition Language

Which SQL clause is used to filter results based on a specific condition?

• ORDER BY

• GROUP BY

• WHERE

• HAVING

Which type of join returns all rows from the left table and matching rows from the right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

What is a view in SQL?

• A physical table stored on disk

• A virtual table based on a query

• A stored procedure

• A user-defined function

Which psql command is used to list all available databases?

• \l

• \d

• \c

• \q

Which PostgreSQL data type is best suited for storing large blocks of text?

• INTEGER

• VARCHAR

• TEXT

• BOOLEAN