ADVERTISEMENT
ADVERTISEMENT

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



ADVERTISEMENT



ADVERTISEMENT



Comments and Discussions


ADVERTISEMENT

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.