Question:
(a) List and describe the four parameters contained in the second section of the AdRotator Scheduler File.
(b) Distinguish between the following types of "Locks" as used in the fourth parameter of the Open method for a RecordSet Object.
(i) adLockReadOnly and adLockPessimistic
(ii) adLockOptimistic and adLockBatchOptimistic.
(c) (i) Describe fully the various steps required while inserting a new record to a database using the properties and methods of the Recordset Object.
(ii) Referring to the question above, 3(c) (i), illustrate your answer with appropriate extract codes.