DBMS

What does DBMS stand for?

• Database Management System
• Dynamic Bandwidth Management System
• Digital Business Management Software
• Data Backup Management System

Which of the following is a primary function of a DBMS?

• Operating system management

• Data storage and retrieval

• Graphic design

• Network routing

Which component of a DBMS is responsible for managing data access?

• Backup system

• Data dictionary

• User interface

• Query processor

What is a common language used to interact with a DBMS?

• SQL

• HTML

• JavaScript

• Python

What is the purpose of a Data Dictionary in a database?

• To store user passwords securely
• To optimize database performance
• To generate random data entries
• The purpose of a Data Dictionary in a database is to provide a centralized repository of metadata that describes the structure, relationships, and constraints of the data.

Which of the following is a utility program function?

• Backing up and restoring data

• Creating passwords

• Disk defragmentation
• File encryption

What is SQL used for?

• Manipulating and retrieving database data

• Creating website designs

• Writing Java code

• Making phone calls

Which of the following SQL tasks is used to remove data from a table?

• DELETE
• UPDATE
• INSERT
• SELECT

Which of these is TRUE about SQL keywords?

• SQL keywords are optional and can be omitted in any SQL statement.
• They are not case-sensitive

• SQL keywords have no specific meaning and can be freely modified.
• SQL keywords can be used as variable names without restrictions.

What symbol is commonly used to end an SQL statement in some DBMS systems?

• Semicolon(;)

• Colon (:)

• Comma(,)

• Period (.)