• 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 the output of the following Python code? (x + y) = 5 + 3 print(x + y)
    1. 5
    2. 8
    3. SyntaxError
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    A password containing letters, numbers, and special characters is considered stronger because?
    حروف، اعداد اور خاص علامات پر مشتمل پاس ورڈ زیادہ مضبوط کیوں سمجھا جاتا ہے؟
    1. It reduces password length
    2. It increases possible combinations
    3. It is easier to remember
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    Which of the following represents the correct sequence of data processing? Input → Processing → Output → Storage, Processing → Input → Storage → Output, Storage → Input → Processing → Output, None of these
    مندرجہ ذیل میں سے ڈیٹا پروسیسنگ کی درست ترتیب کون سی ہے؟
    1. Input → Processing → Output → Storage
    2. Processing → Input → Storage → Output
    3. Storage → Input → Processing → Output
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    What is the shortcut key for double underline ?
    ڈبل انڈر لائن کے لیے شارٹ کٹ کی کیا ہے؟
    1. Ctrl + Shift + D
    2. Ctrl + Ctrl + Shift + B
    3. Ctrl + Ctrl + Shift + U
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    The CPU (Central Processing Unit) is responsible for?
    سنٹرل پروسیسنگ یونٹ کس کام کا ذمہ دار ہے؟
    1. Processing instructions and calculations
    2. Displaying images and associated text
    3. Typing input for processing
    4. None of these
    اس سوال کو وضاحت کے ساتھ پڑھیں
    Test Point Whatsapp Channel

    All Rights Reserved © TestPointpk.com