Question Bank: Database Concepts

What is the primary purpose of a database?

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

What does a file represent in a computer system?

What is a key function of a database management system (DBMS)?

Which of the following represents a common data inconsistency problem in manual recording?

When a student joins a new school, what is one advantage of using a database?

Which technology is primarily used to store data in a database?

What does the term 'data integrity' refer to in databases?

Why is automated data processing preferred over manual data entry?

In database systems, what is a 'key' used for?

What might happen if data is not backed up regularly?

Which of the following database structures allows for relationships between tables?

What does normalization of a database aim to achieve?

In a DBMS, which of the following actions is necessary when a student leaves the school?

What is the main advantage of separating student data from attendance records in a database?

What does DBMS stand for?

Which of the following is NOT a characteristic of a Database Management System?

Which of the following is a primary key?

What is a foreign key in a relational database?

Which of the following describes data redundancy?

What does normalization in a database help to achieve?

How does a DBMS control data access?

Which term describes the structure of a database?

Which of the following best describes an entity in a database context?

In a relational database, what rule does a composite key enforce?

What might result from negative data dependency in a file system?

Which operation is NOT typically performed by a DBMS?

What is a database constraint?

Which of the following best describes a data model?

Which SQL command is used to add a new record to a table?

What is a major limitation of file systems regarding data retrieval?

What does data redundancy in a file system refer to?

Which of the following best describes data inconsistency?

In a file system, what is data isolation?

Which operation can reduce data redundancy in a file system?

What is a significant advantage of using a database management system (DBMS) over a file system?

Which of the following can lead to data inconsistency?

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

What is a consequence of data dependence in a file system?

When data storage necessitates multiple applications to handle access, what issue is most likely encountered?

Which of the following can help maintain data consistency when using files?

What is the primary purpose of using a file system?

What is data security in relation to a file system?

Which of the following features distinguishes a database from a simple file system?

What is the definition of a primary key in a relational database?

What is a relation in a relational database model?

Which of the following can serve as an alternate key?

Which of the following is true regarding attributes in a relation?

In a relation, what is a candidate key?

What does the term 'cardinality' refer to in the context of a relation?

What characterizes a composite primary key?

In a relational database, how is a primary key defined?

Which of the following statements is true regarding null values in keys?

Which of the following statements is correct about NULL values in a relational database?

How does a foreign key relate to primary keys?

What characterizes a composite primary key?

What property must all attributes in a primary key have?

In the relational model, how are relations connected?

Which condition must be satisfied by a composite primary key?

What will happen if a relation does not have a primary key?

In which scenario would you use a composite primary key?

Which of the following best describes a candidate key?

What defines the uniqueness of a candidate key?

When is an attribute described as atomic?

What happens if two tuples in a relation have the same primary key value?

What role do foreign keys play in a relational database?

When should a database designer choose a composite primary key?

If the cardinality of a relation is five, what does this imply?

Which of the following can certainly be defined as the attribute with the highest significance in a relation?

Consider a scenario where two students share the same roll number in attendance. What must be done?

Which of the following statements about the relational model is incorrect?