QUESTION 1

"For the ListCtrl, which statement sets up the left-most column title?"

		"self.list.InsertStringColumn(0, 'Date')"
		"self.list.InsertColumn(0, 'Date')"
		"self.list.SetColumn(1, 'Date')"
		"self.list.InsertColumn(1, 'Date')"

QUESTION 2

When adding a widget to a vertical box sizer, the EXPAND flag _____.

		if persent, has the widget expand to take up the whole horizontal space minus any border.
		if persent, has the widget expand relative to the stretch factor.
		makes every widget in the frame double in size.

QUESTION 3

You cannot execute the same create-table instruction twice.

True

False

QUESTION 4

If you are inserting a record in a SQLITE table you need to execute the commit method to insure the changes are made in the table itself.

True

False

QUESTION 5

What SQL statement selects all the rows in a table?

		SELECT * FROM addresses
		SELECT ALL FROM addresses
		SELECT state FROM addresses

QUESTION 6

What statement inserts this list into a table with 3 fields?

stripes = [ (brown, black, red) , (red, red, red), (gray, green blue) ]

		cur.execute("INSERT stripes INTO codes VALUES ( ?, ?, ?)")
		cur.executemany("INSERT INTO codes VALUES ( ?, ?, ?)", stripes)
		cur.executemany("INSERT INTO codes VALUES ('brown', 'black', 'red')")

QUESTION 7

"To set the range of possible number usable in a SpinCtrl, you use ____."

		"Range(a, b)"
		"Values(a, b)"
		"SetRange(a, b)"

QUESTION 8

A column in a database table is called _____.

		a field
		a collection
		a tuple
		a record

QUESTION 9

This statement, c = sqlite3.connect('db3'). Choose 2 answers.

		opens the db3 database and creates a connection
		creates a cursor for db3
		creates a database named db3 is it does not yet exist
		deletes any existing db3 and creates a new empty database

QUESTION 10

To prevent a SQL-Injection attack you need to ____.

		recast all data entered to type string
		concatenate all entered data with quote marks
		use parameterized queries