Computer & IT

note!Answer: A) Hierarchical sequential access method
HSAM is the Hierarchical Sequential Access Method, a file organization method.

note!Answer: B) Field
In a datasheet, each column is a field holding one attribute of the records.

note!Answer: A) Record or tuple
Each row in a datasheet is a record, also called a tuple.

note!Answer: A) Foreign key
A primary key field referenced in another table is called a foreign key.

note!Answer: B) Auto number
In Access, the Auto Number field type automatically increments for each new record.

note!Answer: C) Cell
The intersection of a row and a column in a table or spreadsheet is a cell.

note!Answer: B) To speedup data search
Indexing speeds up data retrieval by letting the database locate records without scanning the whole table.

note!Answer: D) All of the above
Excel supports Number, Text, and Currency as valid data types, so 'All of the above' is correct.

note!Answer: D) 1
Two tables can be linked by a single relationship, so one relation exists between them.

note!Answer: C) Structured Query Language
SQL stands for Structured Query Language, used to manage and query relational databases.

note!Answer: A) Text
Phone numbers with dashes are not numeric values for calculation, so the Text type is appropriate.

note!Answer: D) Dynaset
A Dynaset is the dynamic result set of records that match a query's criteria.

note!Answer: C) Select query
A Select query retrieves records that meet specified criteria, such as salary greater than 5000.

note!Answer: C) Zip code, last name, first name
In multi-field sorting, the primary sort field is listed first, followed by the secondary and tertiary fields in order.

note!Answer: B) Address="k*"
The asterisk (*) is a wildcard matching any number of characters, so "k*" matches addresses starting with k.

note!Answer: C) By defining validation rule
A validation rule restricts the values a field can accept, such as allowing only 0 and 1.

note!Answer: A) List of database content
In dBASE-style systems, the LIST command displays the records (content) of the database.

note!Answer: D) Copy structure of an active database to new file
COPY STRUCTURE creates a new file with the same field definitions but no records.

note!Answer: D) Cont the number of records in an active database
The COUNT command returns the number of records in the active database file.

note!Answer: D) Retrieval information
A query is used to retrieve information from a database.