1.
By
default database for DAO data control is ..........
[a]
Access
[b]
Oracle
[c]
MySql
[d]
None
2.
By
default recordset type in DAO is
.........
[a]
Snapshot
[b]
Table
[c]
Dynaset
[d] Dynamic
3.
In
setting up the ADODC, which property do you use to specify the database that
the control will link to ?
[a]
ConnectionString
[b]
RecordSource
[c]
LockType
[d] CursorType
4.
What
is a valid setting for the RecordSource property ?
[a] The name of
a Table in the database.
[b]
The name of a query in the database.
[c]
A valid SQL select statement.
[d] The name of another ADODC
5.
Which
CursorType setting would you use if you wanted to create a read- only cursor.
[a]
Dyamic
[b]
Keyset
[c]
Static
[d] Read only.
6.
In
setting up a text box as a bound control, which property specifies the field of
the recordset to be displayed ?
[a]
Name
[b]
DataSource
[c]
DataField
[d] Text
7.
Which
list controls let you create the selection list from a table in a database. ?
[a] Standard ListBox
[b]
DataList
[c]
Standard Combobox
[d] DataCombo
8.
Which
property of the DataList specifies the display field for the list ?
[a]
RowSource
[b]
ListField
[c]
DataSource
[d] DataField
9.
Which
property of the DataList control specifies where the list information come from
?
[a]
RowSource
[b]
ListField
[c]
DataSrouce
[d] DataField
10. What must you
de with literal dates in search criteria for the Find method.
[a]
Enclose the date in single quotes.
[b]
Enclose the date in double quotes.
[c]
Enclose the date in # symbols
[d] No special treatment is require.
11. Which object
handles the link to the specific database?
[a]
Connection
[b]
Command
[c]
Database
[d] RecordSet
12. Which object
provide the link to specific database?
[a]
Connection
[b]
Command
[c]
Database
[d] RecordSet
13. Which object
is responsible for handling transaction processing?
[a]
Connection
[b]
Command
[c]
Database
[d] RecordSet
14. What is the
proper method to user to add a record to the RecordSet.
[a]
Edit.
[b]
NewRecord
[c]
Add
[d] AddNew
15. What are
valid sources of data for a Command Object
[a] A database table
[b]
A Data control
[c]
A store procedure
[d] An SQL statement.
16. What does a
child command object do ?
[a]
Provide clarification of the parent command
[b]
Handles the master record of a master/ detail recordset.
[c]
Handles the details record of Master/ details recordset
[d] There are no child command objects.
17. Which method
of the DataReport enables the user to preview the report information.
[a]
PrintReport
[b]
PrintForm
[c]
Preview
[d] Show
