Programming Fundamentals Part 2

Which of these is the string returned by this code?

phrase = "Character"

phrase.subString(0,4)

• "hara"

• "cter"

• "Cha"

• "Char"

What would be the result of the following query on the this database table?

SELECT Name FROM Students WHERE House = "King" AND Year = "9"

• ["Ted","King",9,"D"]

• "Ted"

• "Poppy"

• "Sam"

What would be the result of this SQL query on the database table shown?

SELECT * FROM Students WHERE Grade = "C" AND House= "Curie"

• "Cher"

• ["Poppy","King",8,"C"]

• "Sam"

• ["Sam","Curie",7,"C"]

Which data structure would be suitable for storing a single list of values such as the wind speeds measured over a week?

• Table

• 2-dimensional array

• 1-dimensional array

• Record

Which SQL command is used to view or query a database?

• CHOOSE

• FIND

• SELECT

To add data to an open file from variables or data structures in memory is what file operation?

• Close

• Write

• Open

• Read

What file operation would this command initiate?

myFile = open("sample.txt")

• Open

• Read

• Close

• Write

• Append

What name do we give to code that is used to query a database, it stands for Structured Query Language and includes SELECT, FROM, WHERE?

• SQL

• LQS

• QLS

• QSL

Python does not provide an array data structure, but what can we use instead?

• List

• Function

• File

• Record

What is the name for a collection of related data items called fields, often stored as a row in a database, it represents something in the real world like a person or product?

• Array

• Record

• Field

• Database