Monday, 4 May 2015

Q 9,paper 2,june 12. What deletes the entire file except the file structure ?



Options (A) ERASE       (B) DELETE      (C) ZAP            (D)Pack

Answer © ZAP
Explanation. Delete removes the  current record from the table preserving the structure Where as delete all removes all records preserving the structure. When you use PACK, Microsoft Visual FoxPro copies all records not marked for deletion to a temporary table. After PACK is finished executing, Visual FoxPro deletes the original table from disk and renames the temporary table with the original table name. If you press the ESC key to cancel PACK, the temporary table is deleted, and the original table remains unchanged. The original table is also recovered if you run out of disk space while PACK is executing. Issuing ZAP is equivalent to issuing DELETE ALL followed by PACK, but ZAP is much faster.  If SET SAFETY is ON, Microsoft Visual FoxPro asks if you would like to remove the records from the current table. Issuing ZAP does not cause a Delete trigger to occur.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.