1. Which of the following code examples turns off a filter?
    2. A. rsStudents.Filter = ""
    B. rsStudents.Filter = Nothing
    C. rsStudents.Filter = adFilterNone
    D. rsStudents.Filter = adDisableFilter
     

  2. Which of the following is not a component of the ADO object model?
    3. A. TableDef
    B. Recordset
    C. Connection
    D. Command
     

  3. Which cursor location must be used when implementing a disconnected recordset?
    4. A. Server-side
    B. Client-side
    C. Dynamic
    D. Static
     

  4. Which Recordset method is used to save changes to a data source?
    5. A. AddNew
    B. Save
    C. Update
    D. Edit
     

  5. Which method is used to add a new field to a dynamic recordset?
    6. A. Update
    B. Insert
    C. AddNew
    D. Append
     

  6. Which two lines of code bind a text box to a Recordset object?
    7. A. Set txtStudentCity.DataSource = rsStudent
    txtStudentCity.DataField = "City"
    B. Set txtStudentCity.DataSource = rsStudent
    txtStudentCity.Text = "City"
    C. Set txtStudentCity.Text = rsStudent
    txtStudentCity.DataField = "City"
    D. Set txtStudentCity.DataField = rsStudent
    txtStudentCity.DataSource = "City"