Database System

note!Answer: B) Table
An RDBMS stores and uses data in relational tables.

note!Answer: A) Entering and editing data
Forms are mainly used to enter and edit data; reports are used for printing.

note!Answer: B) Unique key
A primary key uniquely identifies each record in a table, so it must hold unique values.

note!Answer: D) Collection of data
A database is an organized collection of related data.

note!Answer: D) Main
SELECT, FROM and WHERE are SQL clauses; MAIN is not an SQL keyword.

note!Answer: B) Database
The hierarchy runs field, record, table, database, so the database is the largest unit.

note!Answer: D) All of the above
A DBMS manages a collection of data and provides programs to access and update it.

note!Answer: A) Record
In a table, each row is a record (tuple).

note!Answer: B) Sorting
Sorting arranges data in a particular order, such as ascending or descending.

note!Answer: B) Edit
Edit is a text editor, while dBase, FoxPro and Access are database applications.

note!Answer: C) Database
A database is an organized collection of logically related data.

note!Answer: A) Granularity
The locking level in a database is also called lock granularity.

note!Answer: B) flash
Flash is a multimedia/animation tool, not a database application.

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.