【题解】Quiz: Many-to-Many Relationships and Python (Using Databases with Python)

吐槽：有点难...= =听了课还是差点没满分...

题目：

1. In the following Python code sequence (assuming cur is a SQLite cursor object),

cur.execute('SELECT count FROM Counts WHERE org = ? ', (org, ))

row = cur.fetchone()

what is the value in row if no rows match the WHERE clause?

A. An empty list

B. None

C. -1

D. An empty dictionary

fetchone() ：返回单个的元组，也就是一条记录(row)，如果没有结果，则返回None（https://blog.csdn.net/Odaokai/article/details/101026437）。

2. What does the LIMIT clause in the following SQL accomplish?

SELECT org, count FROM Counts

ORDER BY count DESC LIMIT 10

A. It only retrieves the first 10 rows from the table

B. It only sorts on the first 10 characters of the column

C. It reverses the sort order if there are more than 10 rows

D. It avoids reading data from any tabl