3. Give brief answers:
(a) Including spaces, what is the maximum length permissible for a field name?
(b) Where does the new record reside in a table set with a primary key?
(c) When is the primary key set in a table?
(d) What happens to the sequence of a primary key number in a table, when a record is deleted in-between?
(e) Can you generate the same primary key number as that of the deleted record for any other record?
Answers
Answer:
a) Names of fields, controls, and objects in Microsoft Access desktop databases: Can be up to 64 characters long.
b) any record that we insert in this table will be located physically at the last record.
c) The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields).
d) If you're using a sequence of any kind, the numbers of deleted records will not get reused, as the sequence does not know about them. Generally, no, the numbers are not reused.
e) Generally, no, the numbers are not reused.
Explanation:
hope you will like this answer. pls mark as brilliant.