exam 1 practical-95.txt

来自「ssd7考试exam1,绝对有用~欢迎下载」· 文本 代码 · 共 55 行

1
1.1
select A 
from R

1.2
select *
from R
where B=13

1.3
select A,B
from R,S
where C=D

2
2.1
ename 		project 		dept 
Kasper 		Spreadsheet 		Admin 
Mohan 		Spreadsheet 		Admin 
Lin 		Forecast 		Admin 
Lin 		Spreadsheet 		Admin 
2.2
The operation cannot be performed for two tables don't have the same degrees

2.3/*the result is empty*/
dept 

4
4.1
alter table ORDERS alter column Received set not null
4.2
alter table ORDERS check(Shipped is null  or Shipped>Received)

5
5.1
select Pon
from PART
where UnitPrice>=10 and UnitPrice<=25;

5.2
select Pno ,sum(Qty) as QtySum
from ORDERS,INVOICE
where ORDERS.Ono=INVOICE.Ono and Received>=to_date('01-Jan-98','dd-mm-yy')
			     and Received<=to_date('31-Dec-98','dd-mm-yy')
group by Pno
order by sum(BilledPrice) asc

5.3
select PART.*
from INVOICE,ORDERS,PART
where PART.Pno = INVOICE.Pno and ORDERS.Ono = INVOICE.Ono and (ORDERS.Received > to_date('31-dec-98','dd-mm-yy') or ORDERS.Received < to_date('01-jan-98','dd-mm-yy'))

6
alter table EMPLOYEE add constraint ref foreign key( dname) references DEPARTMENT(name)