Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
PACK permanently deletes record from database - Database
Home
>>
Category
>>
Programming Language (MCQ) questions
>>
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
Related Content
Networking (
207
)
Database (
97
)
C programming (
58
)
Software Engineering (
28
)
SQL (
5
)
HTML (
74
)
Web Technologies (
11
)
Data Structure (
140
)
Operating System (
96
)
Java (
25
)
Oracle (
5
)
C++ (
50
)
Algorithms (
7
)
PL/SQL (
13
)
JavaScript (
7
)
XML (
0
)
CSS (
1
)
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
Required!
Required!
Invalid Email Id!
Required!
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
MCQs
English
Tutorials
Download
▲