SQL Basic Aptitude Questions and Answers | Set 2

List of SQL Basic Aptitude Questions

6) Which keyword is used with UPDATE command to change the value?
  1. CHANGE
  2. MODIFY
  3. ADD
  4. SET

7) Which keyword is used with ALTER command to delete a column?
  1. DROP
  2. DELETE
  3. REMOVE
  4. CHNAGE

8) Which command is used delete a record from database table?
  1. DROP
  2. DELETE
  3. MODIFY
  4. REMOVE

9) What will happen, if you execute DELETE command without WHERE clause?
  1. Table will be deleted
  2. Top 10 records will be deleted
  3. All records of table will be deleted
  4. Only one record will be deleted

10) Which command is used to delete a table?
  1. DROP TABLE
  2. CLEAR TABLE
  3. REMOVE TABLE
  4. DELETE TABLE





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.