This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “SQL Queries – I”.
1. List all branch names and their assests
2. List all accounts of Brooklyn branch
3. List all loans with amount > 1000.
4. List all accounts of Perryridge branch with balance < 1000.
5. List Numbers of accounts with balances between 700 and 900
6. Change the assests of Perryridge branch to 340000000.
7. Transfer the accounts and loans of Perryridge branch to Downtown branch.
update loan set branch_name=’Downtown’ where branch_name = ‘Perryridge’;
8. Transfer Rs. 100 from account A-101 to A-215.
set balance = case
when account_number=’A-101′ then balance-100
when account_number=’A-215′ then balance+100
9. Delete the branch Perryridge.
delete from branch where branch_name=’Perryridge’;
delete from loan where branch_name=’Perryridge’;
10. Waive off all the loans with amount < 1000.
(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.