PYTHON REFRESHER
ENGINEERING DESIGN PROCESS
SQL QUERIES
CYBERSECURITY
MISCELLANEOUS
100

This built-in function is used to iterate over a sequence of numbers. (Let's say I want to span over 1 to 5, what function would I use?)

What is range()?

100

The first step in the engineering design process where the problem is defined.

What is identifying the need?


100

This function establishes a connection to an SQLite database file, creating the file if it does not exist.

What is connect()?

100

Shifting each letter in the plaintext by a fixed number of positions down the alphabet.

What is a Ceaser Shift/Cipher?

100

This planet is known as the Red Planet.

What is Mars?

200

The function used to output text to the console.

What is print()?

200

This step involves ideation and generating potential solutions.

What is brainstorming solutions?

200

This method is used to instantiate a cursor object in SQLite3, which is necessary for executing SQL commands.

What is cursor()?

200

The three things contained in a block within a block chain.

What is data, hash, and previous block hash?

200

This iconic sitcom, known for its observational humor and cast including Elaine, George, and Kramer, aired from 1989 to 1998.

What is Seinfeld?

300

This data type is used to represent whole numbers in Python.

What is int?

300

The engineering design process is dynamic and each step should be revisited. It is the key of innovation.

What is iteration?

300

The command to create a new table named students with columns id and name.

What is CREATE TABLE?

300

The two methods Bitcoin uses to secure its blockchain.

What is POW(proof of work) and consensus?

300

This Canadian author is famous for his beloved children's books such as "Love You Forever" and "The Paper Bag Princess." His engaging storytelling and whimsical illustrations have made him a favourite among young readers.

Who is Robert Munsch?

400

This keyword is used to define a conditional statement in Python.

What is if?


400

The process of building a low fidelity version of the final design / product.

What is prototyping?

400

This type of column is used in SQLite to uniquely identify each row in a table and automatically increments its value with each new entry.

What is INTEGER PRIMARY KEY?

400

The two keys an individual has in asymmetric encryption.

What are public and private keys?

400

"Float like a butterfly, sting like a bee" was a famous catchphrase of this legendary boxer and cultural icon.

Who is Muhammad Ali?

500

This data structure in Python allows for key-value pair storage and is mutable.

What is a dictionary?

500

This final step involves presenting the effectiveness of the solution.

What is communication?

500

The method used to save changes to the database after executing an SQL command.

What is commit()?

500

Steps of Asymmetric Encryption.

What is exchanging public keys, encrypting the message with them, sending the message, and decrypting with the private key?

500

This Russian exclave, bordered by Poland and Lithuania, is known for its historical significance and was formerly known as Königsberg before World War II. It is also home to the unique Baltic Sea enclave.

What is Kaliningrad?

M
e
n
u