Database Design & Development 2

In a relational database, which normal form ensures that there are no transitive dependencies?

• 1NF

• 2NF

• 3NF

• BCNF

What is the primary purpose of an index in a database?

• To enforce referential integrity

• To optimise query performance

• To store large binary objects

• To maintain database schemas

Which of the following is a disadvantage of de-normalisation?

• Improved query performance

• Increased redundancy

• Reduced data integrity

• Simplified querying

Which SQL command is used to remove a table from a database?

• DELETE

• DROP

• TRUNCATE

• REMOVE

In database design, what does the term 'cardinality' refer to?

• The uniqueness of data values

• The number of rows in a table

• The number of relationships between tables

• The number of attributes in a table

Which type of join returns all rows when there is a match in either table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

In an ER diagram, what does a diamond shape represent?

• Entity

• Attribute

• Relationship

• Primary Key

What is the purpose of a foreign key in a database?

• To uniquely identify records in a table

• To enforce referential integrity between tables

• To define the schema of a table

• To store large text data

In SQL, which clause is used to filter the results of a query based on conditions?

• SELECT

• WHERE

• FROM

• GROUP BY

Which normal form is achieved when a table is in 2NF and all non-key attributes are fully functionally dependent on the primary key?

• 1NF

• 2NF

• 3NF

• BCNF