Free Bachelor of Science in Computer Science : Database Management Systems Questions and Answers

Question 1

Which of the following is not a function performed by a DBMS?

Accepted Answer

Creating and processing forms

Answer

A Database Management System (DBMS) is primarily responsible for creating, maintaining, and processing data within a database, as well as administering the database system itself. While forms are used to input and display data, the creation and processing of these forms are typically handled by application programs or front-end tools that interact with the DBMS, rather than being a core DBMS function itself.

Question 2

What is the definition of a database management system (DBMS)?

Accepted Answer

Software system used to create, maintain, and provide controlled access to a database

Answer

A Database Management System (DBMS) is a software system specifically designed to create, maintain, and provide controlled access to a database. It acts as an interface between the database and its users or application programs, ensuring data integrity, security, and efficient retrieval. The 'controlled access' aspect is crucial for managing permissions and data consistency.

Question 3

An _______ within a table signifies a connection or link between a group of values.

Accepted Answer

Record

Answer

Within a table, a record (also known as a row or tuple) signifies a complete set of related values that describe a single entity. Each record contains data for all the fields (attributes) defined for that table, representing a unique instance of the entity. For example, in a 'Students' table, one record would contain all the information for a single student.

Question 4

The term attribute pertains to a ________ within a table.

Accepted Answer

Field

Answer

The term 'attribute' in the context of a database table pertains to a field (or column). An attribute represents a specific characteristic or property of the entity that the table describes. For example, in a 'Students' table, 'Name', 'ID', and 'City' would be attributes, each corresponding to a field.

Question 5

The expression _______ is employed to denote a row.

Accepted Answer

Record

Answer

In database terminology, the expression 'record' is employed to denote a row within a table. Each record represents a single, complete entry or instance of the entity that the table stores information about. It contains a set of related data values for each of the table's fields.

BSCS - Bachelor of Science in Computer Science Practice Test

BSCS - Bachelor of Science in Computer Science Practice Test

Free Bachelor of Science in Computer Science : Database Management Systems Questions and Answers