• Call Us : 03082533000 (WhatsApp)
  • Email Us : TestPointpk.com@gmail.com
Testpoint Whatsapp group Testpoint Whatsapp group
Sticky Note
In SQL, which command is used to remove all rows from a table without deleting the table structure?
  1. DELETE
  2. DROP
  3. TRUNCATE
  4. REMOVE
Explanation
  • TRUNCATE removes all rows from a table but keeps the table structure intact.
  • It is faster than DELETE because it does not log individual row deletions.
  • DELETE can remove specific rows and can be rolled back.
  • DROP deletes the entire table structure and data.

  • REMOVE is not a valid SQL command.

    • Related MCQs

    What is a Compiler?
    ایک مرتب کیا ہے؟
    1. A compiler is a special program that processes statements written in a particular programming language and turns them into machine language
    2. A compiler is a language providing very efficient execution
    3. A compiler does a conversion line by line as the program is run
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    Which is NOT an official Android version codename: Muffin, Cupcake, Donut, or Lollipop?
    درج ذیل میں سے کون سا اینڈرائیڈ کے آفیشل ورژن کا کوڈ نام نہیں ہے؟
    1. Muffin
    2. Cupcake
    3. Donut
    4. Lollipop
    اس سوال کو وضاحت کے ساتھ پڑھیں
    What helps a website remember a user's identity?
    کسی ویب سائٹ کو صارف کی شناخت یاد رکھنے میں کون سی چیز مدد دیتی ہے؟
    1. Cookies
    2. Firewall
    3. Cache
    4. Compiler
    اس سوال کو وضاحت کے ساتھ پڑھیں
    The process of starting an operating system when the user turns on a computer is known as?
    جب صارف کمپیوٹر آن کرتا ہے تو آپریٹنگ سسٹم شروع کرنے کے عمل کو کیا کہا جاتا ہے؟
    1. Starting
    2. Loading
    3. Booting
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    In computer system word BOOT is used for?
    کمپیوٹر سسٹم میں بوٹ کا لفظ استعمال ہوتا ہے؟
    1. To exit opened software
    2. To start up a software
    3. To shutdown system
    4. To start a computer
    اس سوال کو وضاحت کے ساتھ پڑھیں
    Test Point Whatsapp Channel

    All Rights Reserved © TestPointpk.com