QUESTION 11

A table has 5 fields. Which of the following is a proper parameterized query?

		"INSERT INTO colors VALUES ( ?, ?)"
		"INSERT INTO colors VALUES (?, ?, ?, ?, ?)"
		"INSERT INTO colors VALUES ('param1', 'param2', 'param3')"
		"INSERT INTO colors VALUES (param1, param2, param3)"

QUESTION 12

Box sizers can be ____ in orientation. Choose two answers.

		horizontal
		diagonal
		layered
		vertical

QUESTION 13

To remove all the rows in a wx.ListCtrl you'd execute ____.

		self.list.DeleteAllRows()
		self.list.DeleteAllItems()
		self.list.DeleteAll()
		self.list.RemoveAll()

QUESTION 14

Which of the following removes all records from a table?

		DELETE FROM colors
		REMOVE FROM colors *
		FROM colors REMOVE *
		DELETE FROM colors WHERE color2 = *

QUESTION 15

"If you want to retrive records from a table using the field names in a dictionary-like way, use ____."

		a row-factory
		field-list
		a column-factory

QUESTION 16

"A table has 3 columns. For the ListCtrl, which statement inserts data into the first (top) row in the third column?"

		"self.list.SetStringItem(0, 2, ""yellow"")"
		"self.list.InsertStringItem(1, 3, ""yellow"")"
		"self.list.InsertStringItem(0, 1, ""yellow"")"
		"self.list.SetStringItem(1, 3, ""yellow"")"

QUESTION 17

In the Python version of sqlite3 to execute sql statements against your database you need ____.

		a cursor
		a collector
		a srow maker
		a primary key

QUESTION 18

To bring the layout into existance you need to execute the _____.

		SetSizer() method
		COMMIT() method
		ADD() method

QUESTION 19

"With a modal dialog box, you can still use other parts of the program without having to close the dialog."

True

False

QUESTION 20

A table has 5 fields. Which of the following would successfully insert data into that table?

		"INSERT INTO colors (color2, color3) VALUES ('red', 'orange')"
		"INSERT INTO colors ('red', 'orange') WHERE field1=color2 AND field2=color3"
		"INSERT INTO colors VALUES ('red', 'orange')"
		"INSERT INTO colors (color2 = 'red', color3 = 'orange')"