Database Management System Quiz

What is the main purpose of a Database Management System (DBMS)?

• To create web pages using HTML

• To store, manage, and retrieve data efficiently

• To design user interfaces for software applications

• To calculate statistical data only

Which of the following best describes a DBMS?

• A software used only for network security

• A system that allows users to define, create, maintain, and control access to databases

• A program for editing images

• A tool for writing programming code

Which of the following is NOT a component of a DBMS?

• Data Dictionary

• Query Processor

• Image Renderer

• Storage Manager

What is the function of the Query Processor in a DBMS?

• To print reports

• To backup files

• To interpret and execute database queries

• To design user interfaces

What distinguishes data from information in databases?

• Information is less useful than data

• Data is always numeric

• Information is processed data with meaning

• Data and information are always the same

Which of the following best defines a schema in a database?

• A set of rules for data entry

• The structure that defines the organization of data in a database

• The security level of a database

• A list of programming functions

What is a tuple in a database context?

• A programming statement

• A row in a database table

• A column in a table

• A data model

What is the purpose of a Primary Key in a relational database?

• To store large text

• To duplicate records

• To uniquely identify each record in a table

• To sort data randomly

What does normalization in databases aim to achieve?

• To slow down queries

• To add more data types

• To reduce data redundancy and improve data integrity

• To delete duplicate records only

Which of the following is an advantage of using a DBMS?

• It is slower than file systems

• It provides data consistency and security

• It always uses manual input

• It works without any software