DBMS 17 Slips
Q.17) Branch_Account
(
b_no number(5) primary key ,
b_name varchar(20) ,
b_city varchar(20) ,
assets number(20) check (assets>0)
) ;
create table account
(
acc_no number(10) primary key ,
balance number(15) ,
assets number(20) check (assets>0)
) ;
insert into branch values(1,'yamuna','nashik',10000) ;
insert into branch values(2,'ganga','nagpur',1100000) ;
insert into branch values(3,'ajinta','aurangabad',900000) ;
insert into branch values(4,'bandra','mumbai',1000000) ;
insert into account values(1234,500000,1) ;
insert into account values(1235,700000,2) ;
insert into account values(1236,800000,3) ;
insert into account values(1237,900000,4) ;
1. select MAX(account.balance) from account,branch GROUP BY b_name ;
MAX(ACCOUNT.BALANCE)
--------------------
900000
900000
900000
900000
........................................................................................................................................................................................
2. select b_name from account,branch where branch.b_no=account.acc_no AND account.balance>30000 ;
.........................................................................................................................................................................................
3. select balance-3 from account where account.balance>100000 ;
BALANCE-3
----------
499997
699997
799997
899997
...........................................................................................................................................................................................
4. select branch.* from branch where b_city LIKE 'm%' ;
B_NO B_NAME B_CITY ASSETS
---------- -------------------- -------------------- ----------
4 bandra mumbai 1000000
.........................................................................................................................................................................................
5. select b_name from account,branch where branch.b_no=account.acc_no AND branch.assets>'pune' ;
Tags:
Dbms