Question Bank: Database Concepts

What does DBMS stand for?

Which of the following is a function of a Database Management System?

Which type of key in a database is used to uniquely identify each record?

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

Which of the following best describes data redundancy?

How does a DBMS help reduce data inconsistency?

What is meant by 'database schema'?

Which DBMS command is used to retrieve data?

Data isolation refers to which of the following?

What is the purpose of a database constraint?

In DBMS, what does the term 'cardinality' mean?

What will happen if a foreign key is assigned a value that does not exist in its related primary key table?

Which of the following commands would you use to remove an existing record in a DBMS?

In the context of relational databases, what is a composite key?

What does the term 'query' refer to in a DBMS?

Which of the following is a non-relational database management system?

What is meant by data redundancy in a file system?

Which limitation of file systems relates to difficulty in retrieving data?

Data inconsistency in a file system can lead to:

What does a composite primary key consist of?

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

Which of the following is NOT a limitation of a file system?

How does a database management system handle data redundancy compared to a file system?

What is data isolation in a file system?

What impacts data dependence in a file system?

Which design aspect is crucial in a file system to minimize redundancy?

What is the primary purpose of a file in a file system?

Which aspect of file systems complicates data sharing?

How can you resolve data inconsistency in a file system?

What is one characteristic of a database management system compared to a file system?

What is the relationship between primary keys and foreign keys?

What is the primary purpose of a database?

Which of the following is NOT a benefit of using a database system over manual records?

What data type is typically NOT stored in a database?

Why is it important to keep data consistent in a database?

In a database, which of the following describes a 'record'?

Which statement about databases is accurate?

What does the term 'data redundancy' refer to?

When a student leaves a school, what is a primary action in the database?

What role does a 'file system' play in the context of data management?

Which of the following is a limitation of manual record keeping?

What is a 'database management system' (DBMS)?

In relational databases, what is the purpose of 'keys'?

Which data model organizes data in tabular form?

What practice is essential for ensuring data accuracy in databases?

What is a potential consequence of having inconsistent data in a database?

What is the primary key in a relational database?

Which of the following describes a candidate key?

What is a composite primary key?

Which of the following can be a foreign key?

When is a primary key allowed to have a NULL value?

Which use of keys can help avoid data redundancy?

What primarily differentiates a foreign key from a primary key?

If a table has multiple candidate keys, how is the primary key chosen?

Which attributes would ideally make the best candidate key?

What is the role of alternate keys in a database?

In what scenario might a foreign key accept NULL values?

Which of the following is a characteristic of candidate keys?

Why is it crucial to define primary and foreign keys effectively?

When utilizing a composite primary key, what must be ensured?

Which statement accurately reflects the function of keys in a relational database?

What is a key feature of the relational data model?

In an attendance relation, which two attributes would form a composite primary key?

Which of the following best describes a foreign key?

What is the degree of a relation?

Which property states that all data values in an attribute must be of the same domain?

What does cardinality refer to in a relational database?

What happens if an attribute defined as a primary key contains null values?

Which of the following attributes would NOT be a candidate key for the GUARDIAN table?

What is the significance of using NULL in a relational database?

If a relation has 6 attributes, what is its degree?

What must be true for two tuples in a relation to be considered distinct?

Which attribute combination would not create a valid primary key?

What is necessary for an attribute to be used as a foreign key?

In a relational database, what is the best way to ensure data integrity?

Which statement best describes a primary key?

Which of the following is a NOT a characteristic of a relational model?