PrepSnap logoPrepSnap
Pass

Question

1.
2.
3.
4.
Answer (Detailed Solution Below)

Option 2 : DROP TABLE / DROP TABLE

Advertisement

Detailed Solution

सही उत्तर DROP TABLE / DROP TABLE है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Which SQL command removes a table's data together with its definition from the database? / कौन-सा SQL आदेश तालिका के डेटा के साथ उसकी परिभाषा भी डेटाबेस से हटा देता है?

1.
DELETE FROM / DELETE FROM
2.
DROP TABLE / DROP TABLE
3.
TRUNCATE TABLE / TRUNCATE TABLE
4.
ALTER TABLE / ALTER TABLE

Correct Answer: DROP TABLE / DROP TABLE

DROP TABLE deletes both the rows and the table structure; TRUNCATE and DELETE keep the definition. / DROP TABLE पंक्तियों के साथ तालिका संरचना भी हटाता है; TRUNCATE और DELETE परिभाषा रखते हैं।

Downloaded from PrepSnap (prepsnap.in)