PACK permanently deletes record from database - Database

Q.  Which command permanently deletes the record from database?
- Published on 27 Aug 15

a. PACK
b. ZAP
c. SEEK
d. SKIP

ANSWER: PACK
 

    Discussion

  • Nirja Shah   -Posted on 30 Oct 15
    PACK
    - This command removes the records marked for deletion from the current database.

    - Syntax
    PACK DATABASE

    - A database contains records marked for deletion after a table or view is removed from the database, or if the structure of a table in the database is modified.

    - The database must be opened exclusively, and no table or view in the database can be open.

    - Example
    In the following example, PACK DATABASE is used to pack the testdata database, removing records marked for deletion.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)