Database System

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.

note!Answer: A) Database management approach
A database management approach integrates related data records and files for storage and processing.

note!Answer: D) Key field
A key field uniquely identifies each record in a file or table.

note!Answer: C) Relational database
A relational database links multiple tables through common fields (keys).

note!Answer: D) DBMS
DBMS stands for Database Management System, software used to create, retrieve and maintain database records.

note!Answer: D) Sub-schema
A sub-schema is the user's or application's view of the part of the database it needs.

note!Answer: A) Validation
Validation checks are rules that detect unsuitable or invalid data at input.

note!Answer: C) Relational
The relational model is the most widely used database model today.

note!Answer: D) All of the above
SQL statements are used to retrieve, manipulate and control data.