Blog

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 posts as p    INNER JOIN users as u    ON p.user_id = u.user_id;SELECT *FROM posts as p   RIGHT JOIN users as u    ON p.user_id = u.user_id; These queries will return the same output. True or False?

Settled agriculture was a development of the Paleolithic Era, more than 40,000 years ago.

Phillip of Macedon had two primary goals:  (1) Unification of the Greeks and (2) conquest of the Persians.

Write a query to retrieve the sales amounts from transactions made at dealerships located in the state of Florida.  Fill in the blank: SELECT s.sales_amount,  s.dealership_id, d.dealership_id ,  d.state   FROM saletransactions AS sINNER JOIN ( SELECT __(1)___ FROM dealerships  WHERE  state=’FL’ ) AS dON __________(2)____________ ;   

In the blank spaces below, write the output produced by each line of the following program, as it would appear on the console. def slogan(one, four, two): print(four, “minus”, two, “is”, one) one = one + “1” def main(): four = “ten” one = “cat” twelve = “two” two = “dog” three = four + “4” slogan(two, twelve, one) slogan(one, “twelve”, three) slogan(one, four, twelve) slogan(twelve + “2”, four, twelve) slogan(“one”, “mouse”, four) 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.

The Greek polis was:

In ancient Greece, woman were always allowed to participate directly in the political process, especially in Athens, where they could vote and serve as members of the Boule.

Hannibal attacked Rome from the _______________ during the Second Punic War.

The Tigris and Euphrates rivers flowed from south to north and watered much of Egypt.