Page 247 - Open Soource Technologies 304.indd

Unit 10: Database Fundamentals and Connectivity Option

10.8 Self Assessment Questions

1. After you have executed a SQL Server stored procedure that implements a return value, you
can check the value that the stored procedure returned by
(a) Using the individual variables corresponding to the stored procedure’s Output
parameters in the Parameters array argument to the Command object’s Execute method.

(b) Checking the final element of the Command object’s Parameters collection.
(c) Checking element 0 of the Command object’s Parameters collection.
(d) Checking the element of the Command object’s Parameters collection that corresponds
to the last Output parameter declared in the stored procedure.
2. A SQL Server stored procedure designed to return records to a VB app using ADO (Select
all that apply.)
(a) Must have at least one Output parameter.
(b) Must have at least one Input parameter.
(c) Must implement a return value.

(d) Doesn’t necessarily have any parameters.
3. A SQL statement to delete all records from the employees table would read
(a) DELETE “%” FROM employees
(b) DELETE * FROM employees

(c) DELETE FROM employees
(d) DELETE FROM employees WHERE *
4. Which statements are true of the GetDataMember event?
(a) You initiate a data connection in its event procedure.

(b) You set its first parameter to the control’s data connection.
(c) It fires whenever a bound control needs to refresh its data.
(d) You set its second parameter to the control’s Record set.

5. VARCHAR column was limited to 8000 characters.
(a) True (b) False
6. Setting Up an ODBC Data Source process called.
(a) “setting up a DSM” (b) “setting up a DSN”

(c) “setting up a DSK” (d) “setting up a DSA”
7. To bind a control to a database control, we use properties like DataField to specify the
database control.

(a) True (b) False

LOVELY PROFESSIONAL UNIVERSITY 241