Algonquin College

CST 2335

Quiz 3:

1)Which of the following functions is required for implementing the ListAdapter interface

 a.  getCount

2. onCreate
3. setContentView

2. What is the corresponding SQL query to this function: db.query(true, "PURCHASES", new String []{"Price", "Quantity"}, "Quantity > ?", new String[] {"10" }, null, null, null, null)?

1. Select Price, Quantity from PURCHASES"
2. Select Price,Quantity from PURCHASES where Quantity > 10

c.         Select distinct Price,Quantity from PURCHASES where Quantity > 10

3. If a database is opened and the version is the same as the previously created one on the device, which function will be called first:

a.         onOpen

2. onUpgrade
3. onDowngrade

4. If a database is opened and the version is greater than the previously created one on the device, which function will be called first:
   1. onOpen

b.         onUpgrade

c.         onDowngrade

5. If a database is opened and the version is less than the previously created one on the device, which function will be called first:
   1. onOpen
   2. onUpgrade

c.         onDowngrade

6. When you write a ListView adapter class, which function gets called first when populating the ListView:
   1. getView

b.         getCount

c.         getItem

7. Which of the following functions causes a ListView to start the re-population of the list:
   1. repopulate
   2. getData