2.2 Programming Fundamentals

Question 1

Whats casting

Answer 1

Changing the data type of a variable

Question 2

What is SQL

Answer 2

Used to search database tables for specific data.

Question 3

Whats the overall purpose of SQL?

Answer 3

SCRUD:
to
Search,
Create,
Read,
Update,
Delete data.

Question 4

What does the SQL statement SELECT do

Answer 4

For searching and reading

SELECT (field names) from (table name)

Question 5

What does the SQL command WHERE do

Answer 5

For filtering so that only some records are returned

SELECT * FROM results WHERE name=”Bob”

Question 6

Whats a procedure

Answer 6

Set of instructions stored under one name (a sub program)

Question 7

Whats a function

Answer 7

A sub program like a procedure but it always returns a value