In the blank spaces below, write the output produced by each line of the following program, as it would appear on the console. def statement(mary, john, fun): print(john, “to”, fun, “and”, mary, “extra”) fun = fun * 2 def main(): john = 4 mary = 12 george = 23 fun = 13 work = 7 statement(mary, john, fun) statement(george, work, john) again = fun statement(fun, again, 2) statement(george, mary, john) statement(george, 3, 1) main() Line 1: [l1] Line 2: [l2] Line 3: [l3] Line 4: [l4] Line 5: [l5]

In the blank spaces below, write the output produced by each line of the following program, as it would appear on the console. def say(foo, sam, sue): print(sam, “wants”, sue, “to be”, foo) def main(): foo = “and” sam = “sam” sue = “once” bill = “banana” hope = “cat” ten = “say” say(sam, sue, foo) say(foo, ten, sam) say(hope, bill, sue) bill = bill + “~2” say(bill, hope, sam) say(“foo”, “sue”, hope) main() Line 1: [l1] Line 2: [l2] Line 3: [l3] Line 4: [l4] Line 5: [l5]

Most RDBMSs can create a direct many-to-many relationship.

Phillip II of Macedon’s early success had much to do with his:

Suppose you have a discussion board database containing the following two small tables of posts and users: table name: posts, primary key: post_id post_id user_id post_type post_content 1 1 question ‘What is the meaning of life?’ 2 3 answer ‘The answer is 7.’ 3 2 question ‘Where is the library?’ 4 1 comment ‘I like turtles’ 5 4 question ‘Is water wet?’ 6 2 answer ‘Absolutely not.’ table name: users, primary key: user_id user_id display_name creation_date 1 ‘norbertnoodles’ ‘2022-08-05’ 2 ‘hedwighoot’ ‘2010-01-22’ 3 ‘gilderoygamer’ ‘2020-04-15’ 4 ‘dobbydocent’ ‘2019-06-03’ 5 ‘dracodullard’ ‘2023-04-01’ Here are two SQL queries that join these tables: SELECT *FROM users as u   INNER JOIN posts as p   ON u.user_id = p.user_id;SELECT *FROM users as u   LEFT JOIN posts as p   ON u.user_id = p.user_id; These queries will return the same output. True or False?

Suppose a new transaction was made: customer_id 11 purchased a scooter (product_id=9) at $ 500.00 on October 1st, 2024. Which of the following queries will update the saletransactions table with the new transaction record (customer_id=11, product_id=9, transaction_date = ‘2024-10-01’, sales_amount=500.00)?

In ancient Greece, “philosophy” meant …

Early Christianity could be referred to as one of the “cultic” or “mystery” religions that emerged in the wake of the rise and fall of the Hellenistic kingdoms.

In the blank spaces below, write the output produced by each line of the following program, as it would appear on the console. def equation(one, four, two): two = two + “two” print(four, “is half of”, two, “plus”, one) def main(): one = “four” two = “two” three = “one” four = “mouse” ten = “cat” equation(one, two, three) five = “a” equation(one, “rabbit”, three) equation(one, four, five) ten = four + three equation(five + “++”, four, five) equation(ten, “kitten”, four) main() Line 1: [l1] Line 2: [l2] Line 3: [l3] Line 4: [l4] Line 5: [l5]

Suppose you have a database containing the following two small tables: table name: customers  customer_id customer_name membership 1 Bob basic 2 Larry basic 3 Judy elite 4 Doug elite 5 Rachel basic table name: transactions,   transaction_id customer_id transaction_date transaction_amount 1 3 ‘2018-04-01’ 478.02 2 3 ‘2018-05-15’ 15.11 3 4 ‘2018-06-01’ 167.89 4 4 ‘2018-06-01’ 1004.21 5 4 ‘2018-07-04’ 452.52 6 1 ‘2018-08-21’ 19.01 Which of the following SQL queries returns the output below (Make sure the column names match the above table as well):   customer_id transaction_id customer_name transaction_date transaction_amount 3 1 Judy ‘2018-04-01’ 478.02 4 3 Doug ‘2018-06-01’ 167.89 4 4 Doug ‘2018-06-01’ 1004.21 4 5 Doug ‘2018-07-04’ 452.52