Programming - Functions and SQL

What is the purpose of  *?

• Selects ALL fields from the table
• Selects only the first field in the table
• Selects the last field in the table
• Shows only the first row in the table

With SQL, how do you select all the columns from a table named "Persons"?

•  SELECT [all] FROM Persons
•  SELECT *.Persons
•  SELECT * FROM Persons
•  SELECT Persons

Which query would return the fields Name and Form?

• SELECT Name, Set FROM Pupils

• SELECT Name, Group FROM Pupils

• SELECT Name, Form FROM Pupils

• SELECT Name, Gender FROM Pupils

Return only the customers who have ER anywhere in their last name. 

• last_name LIKE "%er%"
• last_name = "%er"
• last_name = "%er%"
• last_name LIKE "%er"

What is a function?

• A section of code that will return a value

• A section of code that will return nothing

• A section of code that will return a command

• None of the above

What is a subroutine?

• Function

• Procedure

• Parameter

• Functions and Procedures

What will print?

• nothing
• 5
• 6
• an error message

What is a function?

• A section of code that will return a value

• A section of code that will return nothing

• A section of code that will return a command

• None of the above

What is a Procedure?

• A section of code that will return a value

• A section of code that will return nothing

• A section of code that will return a command

• None of the above

Subroutine

• A named block of code designed to carry out a specific task.

• A named block of code that returns a value.

• Data being passed into a subroutine.

• An item of data being passed to a subroutine.