DATABASE MANAGEMENT CT-1

Which of the following best defines a database?

• A collection of programs

• A type of software

• A collection of data

• A type of computer

What is the primary function of a Database Management System (DBMS)?

• Managing software installation

• Data processing

• Data storage and retrieval

• Computer networking

In the context of database security, what does the term 'authentication' refer to?

• Verifying user identity

• Encrypting data

  
  

• Ensuring data is not corrupted

• Backing up data

Which of the following best describes an attribute in an ER model?

• A characteristic or property of an entity

• A link between entities

• A primary key

• A type of relationship

Which type of data can be stored in the database?

• Image oriented data

• Text, files containing data

• Data in the form of audio or video

• All of the above

In which of the following formats data is stored in the database management system?

• Image

• Text

• Table

• Graph

Which of the following is not a feature of DBMS?

• Minimum Duplication and Redundancy of Data

• High Level of Security

• Single-user Access only

• Support ACID Property

The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.

• Referential

• Primary

• Referencing

• Specific

The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.

• Data and the DBMS

• Application and SQL

• The user and the software

• Database application and the database

The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________

• TCL (Transaction Control Language)

• DML (Data Manipulation Langauge)

• DDL (Data Definition Langauge)

• DCL (Data Control Language)