Database Management System Quiz

What does a local database mean?

• A database accessible worldwide

• A database held inside a network to keep it secure

• A database that is stored on a cloud server

• A database that is only accessible offline

What is the main feature of an online database?

• It is only accessible within a local network

• It can be accessed around the world

• It requires physical access to the server

• It is stored on a personal computer

What does a Database Management System (DBMS) allow you to do?

• Only view data

• Create and use your own database

• Delete databases permanently

• Only store data without any modifications

Which of the following is a function of a DBMS?

• It only allows data viewing

• It creates tables and fields

• It only deletes data

• It only stores data without any security

What is SQL used for in a DBMS?

• To design graphics

• To create and search a database

• To manage network connections

• To encrypt data

What does DDL stand for?

• Data Description Language

• Data Definition Language

• Data Development Language

• Data Deployment Language

What is the purpose of DML in SQL?

• To set up tables

• For updates and search queries

• To delete databases

• To encrypt data

What does data validation ensure?

• Data is always correct

• Data meets certain rules

• Data is encrypted

• Data is stored in the cloud

What is a presence check in data validation?

• Checking if data is in the correct format

• Checking if data has been entered and not left blank

• Checking if data is within a sensible range

• Checking if data is encrypted

What does a range check in data validation do?

• Ensures data is encrypted

• Checks if data is in the correct format

• Checks if values are in a sensible range

• Checks if data is stored in the cloud