Home »
Aptitude Questions & Answers »
DBMS Aptitude Questions
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?
- CHANGE
- MODIFY
- ADD
- SET
7)
Which keyword is used with ALTER command to delete a column?
- DROP
- DELETE
- REMOVE
- CHNAGE
8)
Which command is used delete a record from database table?
- DROP
- DELETE
- MODIFY
- REMOVE
Correct Answer - 2
DELETE
9)
What will happen, if you execute DELETE command without WHERE clause?
- Table will be deleted
- Top 10 records will be deleted
- All records of table will be deleted
- Only one record will be deleted
Correct Answer - 3
All records of table will be deleted
10)
Which command is used to delete a table?
- DROP TABLE
- CLEAR TABLE
- REMOVE TABLE
- DELETE TABLE
Correct Answer - 1
DROP TABLE