HP 3000 Manuals HP 3000 Manuals
Lesson 4: Quiz 1
1. What is the maximum number of source tables that can be joined to
form a table?
You can join up to 16 source tables on one screen. You can
also have an unlimited series of tables. That is, you can
join 16 source tables into an intermediate table, and then
join that intermediate table with another 15 source tables,
and so on.
2. If you specify the source tables CUSTOMERS and INVOICES, in that
order, on the Define Tables screen, what will be the default
access sequence?
CUSTOMERS and then INVOICES.
3. Can you change the above access sequence?
Yes, you can alter the access sequence using the Access
Sequence field on the Tune Access screen.
4. What happens if you try to use an item for keyed access when that
item is not a key item in the data set?
BRW highlights the field (on the Tune Access screen) and
informs you that the item is not a key in that data set.
5. "You can have no more than one relation condition per relation in
a joined table." True or False?
False. You can have only one relation condition in a
joined table. However, this condition can be as elaborate
as you wish. You can have any number of relations in a
joined table.
6. Apart from Access Sequence and Key, what other fields are
available on the Tune Access screen?
The Lock Mode field, which allows you to specify whether to
lock data sets and how to lock them, and the Open Mode
field, which allows you to specify a database open mode
other than the default (5).