Database Management Syatem

What does DBMS stand for?

• Digital Base Management System

• Database Management Software

• Database Management System

• Data Block Management System

  
  

In a database, what is a collection of related data entries called?

• Cell

• Key

• Table

• Schema

What is a single entry in a database table called?

• Key

• Record

• Field

• Pointer

What is DBMS?

• DBMS is a high-level language

• DBMS stores, modifies and retrieves data

• DBMS is a programming language

• DBMS is a collection of queries

What is a record in a database?

• A single piece of data in a table

• A collection of fields that store related data

• A database schema

• A primary key

What uniquely identifies a record in a database table?

• Foreign key

• Primary key

• Field name

• Schema

What type of database relationship links records in two tables based on common values?

• Foreign key relationship

• Foreign link

• Dynamic link

• Embedded link

What does a composite key mean in a DBMS?

• A key that is composed of two or more columns

• A key that is used in complex queries

• A key that is composed of duplicate values

• A key that can be divided into multiple parts

In a file processing system, what is meant by data redundancy?

• Data is stored in multiple locations unnecessarily

• Data is deleted after backup

• Data is encrypted multiple times

• Data is compressed repeatedly

What is a major advantage of a DBMS over the file processing system?

• Limited accessibility

• Data redundancy

• Data independence

• Increased complexity