Basic Concepts in Programming and Databases

What does the term “data integrity” refer to?

• The size of the database

• The accuracy and consistency of stored data

• The format of data entries

• The use of graphic interfaces

What is an algorithm in programming?

• A step-by-step procedure to solve a problem

• A programming language

• A data storage unit

• A software design pattern

What is the purpose of indexing in a database?

• To store backup files

• To improve the speed of data retrieval

• To delete duplicate records

• To allow access to unauthorized users

What is the primary purpose of debugging in programming?

• Designing a user interface

• Formatting text output

• Identifying and fixing errors in code

• Creating backup copies

What is a primary key used for in a database table?

• To decorate the first column

• To mark rows for deletion

• To encrypt sensitive information

• To uniquely identify each record in a table

Which of the following best defines a variable in programming?

• A fixed number that never changes

• A named storage location in memory

• A graphical element in a game

• A piece of hardware

What is one disadvantage of using a database management system (DBMS)?

• It always loses data

• It can be expensive to set up and maintain

• It only works on weekends

• It removes user access completely

Which of the following is an example of a control structure in programming?

• if-else

• spreadsheet

• server

• diagram

What is a function used for in programming?

• To store data

• To group reusable code for a specific task

• To create files

• To draw graphics

What is the purpose of a loop in programming?

• To stop execution immediately

• To repeat a set of instructions until a condition is met

• To store variables

• To delete data