Database-Management-System

Question 548

Which command classes text file, which has been created using“SET ALTERNATIVE” <FILE NAME>“Command” ?

A	SET ALTERNATE OFF
B	CLOSE DATABASE
C	CLOSE ALTERNATE
D	CLEAR ALL

Database-Management-SystemSQLUGC NET CS 2011 Dec-Paper-2

Question 548 Explanation:

SET ALTERNATE: Controls the recording of input and output in an alternate text file.
Syntax:
SET ALTERNATE on | OFF
SET ALTERNATE TO [ | ? | [ADDITIVE]]
→ The default for SET ALTERNATE is OFF. To change the default, set the ALTERNATE parameter in the [OnOffSetting Settings] section of PLUS.ini. To set a default file name for use with SET ALTERNATE, specify an ALTERNATE parameter in the [Command Settings] section of PLUS.ini.
→ Issuing SET ALTERNATE OFF does not close the alternate file. Before accessing the contents of an alternate file, formally close it with CLOSE ALTERNATE or SET ALTERNATE TO (with no file name). This ensures that all data recorded by dBASE Plus for storage in the alternate file is transferred to disk, and automatically turns SET ALTERNATE to OFF.

Correct Answer: A

Question 548 Explanation:

SET ALTERNATE: Controls the recording of input and output in an alternate text file.
Syntax:
SET ALTERNATE on | OFF
SET ALTERNATE TO [ | ? | [ADDITIVE]]
→ The default for SET ALTERNATE is OFF. To change the default, set the ALTERNATE parameter in the [OnOffSetting Settings] section of PLUS.ini. To set a default file name for use with SET ALTERNATE, specify an ALTERNATE parameter in the [Command Settings] section of PLUS.ini.
→ Issuing SET ALTERNATE OFF does not close the alternate file. Before accessing the contents of an alternate file, formally close it with CLOSE ALTERNATE or SET ALTERNATE TO (with no file name). This ensures that all data recorded by dBASE Plus for storage in the alternate file is transferred to disk, and automatically turns SET ALTERNATE to OFF.