This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “SQL Queries – I”.
1. List all branch names and their assests
View Answer
2. List all accounts of Brooklyn branch
View Answer
3. List all loans with amount > 1000.
View Answer
4. List all accounts of Perryridge branch with balance < 1000.
View Answer
5. List Numbers of accounts with balances between 700 and 900
View Answer
6. Change the assests of Perryridge branch to 340000000.
View Answer
7. Transfer the accounts and loans of Perryridge branch to Downtown branch.
View Answer
update loan set branch_name=’Downtown’ where branch_name = ‘Perryridge’;
8. Transfer Rs. 100 from account A-101 to A-215.
View Answer
set balance = case
when account_number=’A-101′ then balance-100
when account_number=’A-215′ then balance+100
else balance
end;
9. Delete the branch Perryridge.
View Answer
delete from branch where branch_name=’Perryridge’;
delete from loan where branch_name=’Perryridge’;
10. Waive off all the loans with amount < 1000.
View Answer
(select loan_number from loan where amount<1000);
delete from loan where amount<1000;
Sanfoundry Global Education & Learning Series – RDBMS.
To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.