first lecture

Question 1

the four basic operations you can perform on a database

Answer 1

CRUD

Question 2

When working with databases in Visual Basic,
CRUD operations are typically carried out using…

Answer 2

SQL statements embedded in your Visual Basic code

Question 3

Purpose - To add new records to the database.

Answer 3

Create (Insert)
SQL Statement - INSERT INTO

Question 4

Purpose - To retrieve records from the database.

Answer 4

Read (Select)
SQL Statement - SELECT

Question 5

Purpose - To modify existing records in the database.

Answer 5

Update
SQL Statement - UPDATE

Question 6

Purpose - To remove records from the database.

Answer 6

Delete
SQL Statement - DELETE

Question 7

The ___ is used to execute a block of code if a specified condition is true.
If the condition is false, another block of code can be executed using the Else statement

Answer 7

If-Else statement

Question 8

The ___ is used when you need to evaluate an expression against multiple possible values. It provides a cleaner and more readable alternative to multiple

Answer 8

Select Case statement

Question 9

___ when there are many conditions to check.

Answer 9

If-ElseIf statements

Question 10

The ___ is used when you know in advance how many times you want to execute a block of code. It iterates over a sequence of values.

Answer 10

For loop

Question 11

The ___ executes a block of code as long as a specified condition is True. It’s useful when the number of iterations is not known in advance.

Answer 11

While loop

Question 12

The ___ is similar to the While loop, but with a key difference: the condition is evaluated after the loop’s body is executed. This means that the loop will always execute at least once.

Answer 12

Do-While loop