Database Practice

What does a local database mean?

• A database accessible worldwide

• A database held inside a network to keep it secure

• A database stored on a personal computer

• A database that is always online

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

• To create and use spreadsheets

• To create and use your own database

• To manage email accounts

• To design websites

Which language is used by a DBMS to create and search a database?

• HTML

• Python

• SQL

• Java

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Secure Query Language

What is the purpose of data validation?

• To ensure data is always correct

• To check data on input to see if it meets certain rules

• To delete incorrect data

• To encrypt data

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 in the correct format

• Checks if values are within a sensible range

• Verifies data is not duplicated

• Confirms data is encrypted

What is a format check in data validation?

• Checking if data is encrypted

• Checking if data is in the required format

• Checking if data is duplicated

• Checking if data is within a range

What is a check digit used for in data validation?

• To encrypt data

• To verify data is in the correct format

• To use digits in a code to check data is right

• To ensure data is not duplicated

What does DDL stand for in SQL?

• Data Description Language

• Data Definition Language

• Data Design Language

• Data Development Language