Chapter 16 - Revision history

Laura: /* Quick Quiz 16.8 */

2013-08-16T17:21:56Z

Quick Quiz 16.8

2013-07-16T01:19:10Z

2013-07-15T21:05:47Z

Quick Quiz 16.8

2013-07-03T22:52:53Z

Quick Quiz 16.8

← Older revision		Revision as of 22:52, 3 July 2013
Line 773:		Line 773:
	6. A variable can be used for a file number in statements like OPEN, READ, REWRITE, and CLOSE; however, this technique is limited to keyed files.		6. A variable can be used for a file number in statements like OPEN, READ, REWRITE, and CLOSE; however, this technique is limited to keyed files.

	~~Answer~~: <br>		[[Answers 16.8]]: <br>
	~~1.) T <br>~~
	~~2.) F <br>~~
	~~3.) F <br>~~
	~~4.) F <br>~~
	~~5.) F <br>~~
	~~6.) F <br>~~

	NEXT:[[Chapter 17]]		NEXT:[[Chapter 17]]

	[[BR Tutorial\|Back to Index]]		[[BR Tutorial\|Back to Index]]

2013-07-03T22:52:28Z

Quick Quiz 16.7

← Older revision		Revision as of 22:52, 3 July 2013
Line 695:		Line 695:
	5. When you are trying to DELETE the last record read, the DELETE statement works faster without the KEY=N$ clause than with it.		5. When you are trying to DELETE the last record read, the DELETE statement works faster without the KEY=N$ clause than with it.

	~~Answer: <br>~~		[[Answers 16.7]] <br>
	1.~~) F <br>~~
	~~2.) T <br>~~
	~~3.) F <br>~~
	~~4.) T <br>~~
	~~5.) F~~ <br>

	===16.8 Sample report program to read sequentially by key===		===16.8 Sample report program to read sequentially by key===

2013-07-03T22:52:02Z

Quick Quiz 16.6

← Older revision		Revision as of 22:52, 3 July 2013
Line 594:		Line 594:
	8. The DELETE statement can have a KEY=N$ clause <br>		8. The DELETE statement can have a KEY=N$ clause <br>
	9. Any valid string expression can be substituted for N$ in the KEY=N$ clause. <br>		9. Any valid string expression can be substituted for N$ in the KEY=N$ clause. <br>

	10. When KEY=N$ or KEY>=N$ is specified, the length of N$ must be equal to the length of the key field in the master file; otherwise, error code 0718 occurs.		10. When KEY=N$ or KEY>=N$ is specified, the length of N$ must be equal to the length of the key field in the master file; otherwise, error code 0718 occurs.

Line 604:		Line 605:
	14. The NOKEY error condition means there is no match for the specified key under the matching rules specified by the choice of KEY or SEACH and the choice of = or >=.		14. The NOKEY error condition means there is no match for the specified key under the matching rules specified by the choice of KEY or SEACH and the choice of = or >=.

	~~Answer: <br>~~		[[Answers 16.6]] <br>
	1.~~) F <br>~~
	~~2.) T <br>~~
	~~3.) F <br>~~
	~~4.) F <br>~~
	~~5.) F <br>~~
	6~~.) F <br>~~
	~~7.) F <br>~~
	~~8.) T <br>~~
	~~9.) T <br>~~
	~~10.) T <br>~~
	~~11.) T <br>~~
	~~12.) T <br>~~
	~~13.) F <br>~~
	~~14.) T~~ <br>

	===16.7 Sample program with keyed access for updating===		===16.7 Sample program with keyed access for updating===

2013-07-03T22:51:26Z

Quick Quiz 16.5

← Older revision		Revision as of 22:51, 3 July 2013
Line 467:		Line 467:
	6. 10 OPEN #1:”NAME=ACCOUNT.INT,RECL=31,KFNAME=ACCT.KEY”,KPS =1,KLN=4”, INTERNAL,OUTIN,KEYED		6. 10 OPEN #1:”NAME=ACCOUNT.INT,RECL=31,KFNAME=ACCT.KEY”,KPS =1,KLN=4”, INTERNAL,OUTIN,KEYED

	~~Answer:~~ <br>		[[Answers 16.5]] <br>
	~~1, 2, 3, 4, 5, 6 error will occur in all the above~~

	===16.5b The easy way to do all this===		===16.5b The easy way to do all this===

2013-07-03T22:50:47Z

Quick Quiz 16.4

← Older revision		Revision as of 22:50, 3 July 2013
Line 416:		Line 416:
	6. What two numbers are printed in line 50? Explain how they match up with the INDEX command that you typed.		6. What two numbers are printed in line 50? Explain how they match up with the INDEX command that you typed.

	~~Answer: <br>~~		[[Answers 16.4]] <br>
	~~1.) Error 0702 <br>~~
	~~2.) Change sequential to keyed<br>~~
	3.~~) 6 <br>~~
	4~~.) INDEX class.int class.key 1 6 REPLACE~~ <br>

	~~Now run your program and get the answers.~~

	===16.5 Special Functions, Just for Keyed Processing===		===16.5 Special Functions, Just for Keyed Processing===

2013-07-03T22:50:07Z

Quick Quiz 16.3

← Older revision		Revision as of 22:50, 3 July 2013
Line 382:		Line 382:
	6. A key field is the same as a keyword.		6. A key field is the same as a keyword.

	~~Answer: <br>~~		[[Answers 16.3]] <br>
	1.~~) T<br>~~
	~~2.) F<br>~~
	3~~.) T<br>~~
	~~4.) T<br>~~
	~~5.) F<br>~~
	~~6.) F~~<br>

	===16.4 Opening an existing file for keyed access===		===16.4 Opening an existing file for keyed access===

2013-07-03T22:49:40Z

Quick Quiz 16.2

← Older revision		Revision as of 22:49, 3 July 2013
Line 251:		Line 251:
	4. All positions in a key field must be next to each other.		4. All positions in a key field must be next to each other.

	~~Answer: <br>~~		[[Answers 16.2]] <br>
	~~1) T <br>~~
	2~~) T <br>~~
	~~3) F~~ <br>
	~~4) T~~

	===16.3 Using the INDEX command===		===16.3 Using the INDEX command===