① 高起專資料庫技術及應用期末考試綜合題第4題。請各路大神施以援手！！！！
1 pai部門編號,職務(sigma姓名=』王小毛』 (員工))
2 pai項目名稱,員工姓名(員工|><|項目|><| sigma工時>=100(施工))
3 select 姓名 from 員工 order by 職稱 desc
4 select 員工編號, sum(工時) 總工時 from 施工 group by 員工編號
5 select 姓名, 部門名稱
from 施工,員工,部門,項目
where 員工.部門編號=部門.部門編號 and 員工.員工編號=施工.員工編號 and 施工.項目編號=項目.項目編號 and 職稱='高級工程師' and 預算>100000000
group by 姓名, 部門名稱 having count(*)>=1
6 create view 工作量 as
select 員工.員工編號,姓名,項目名稱,工時
from 施工,員工,項目
where 員工.員工編號=施工.員工編號 and 施工.項目編號=項目.項目編號
7 update 施工 set 工時=工時+50 where 項目編號 in (select 項目編號 from 項目 where 項目名稱='高教新區項目')
② 國四資料庫上機考試考試
我前年浙江考的，沒有上機
③ 資料庫期末考試題 編寫sql語句 1.創建一張學生表，包含以下信息，學號，姓名，年齡，性別，家庭住址，聯系
create table 學生表
(
學號 char(10) primary key,
姓名 char(10),
年齡 int,
性別 char(2) check (sex IN ('男','女')),
家庭住址 char(40),
聯系 char(20)
)
④ 資料庫期末考試
如下 （PS：簡單起見全部使用的varchar2 有些按需要可改成int ）
[oracle@rhel3 admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Proction on Fri Apr 10 13:21:11 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Proction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table student(sno varchar2(10) primary key,sname varchar2(20),ssex char(2),sbirthday varchar2(20),sdept varchar2(20));
Table created.
SQL> create table courses(cno varchar2(10) primary key,cname varchar2(20),ccredit varchar2(10));
Table created.
SQL> create table sc(sno varchar2(10),cno varchar2(10),grade varchar2(10));
Table created.
SQL> alter table sc add constraint pk_sc primary key (sno,cno);
Table altered.
1 select sno,sname from student;
2 select sno,sname,sdept from student;
3 select * from student;
4 select sno,sbirthday from student;
5 select sno,sbirthday,lower(sdept) sdept from student;
6 select sno xingm,sbirthday csrqi,sdept xim from student;
7 select distinct(sno) from student where sno in (select sno from sc where cno in (select cno from courses where cpno is not null));
8 select * from student where sdept='jisuanji';
9 .1 select sname,round(months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd')),0)/12 nianji from student where sbirthday<add_months(sysdate,-12*20);
9.2 select sname,round(months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd')),0)/12 nianji from student where months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd'))/12<20;
10 select distinct(sno) from sc where grade<'60';
未完待續......看的真累
11 select sname,sdept,round(months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd')),0)/12 nianlin from student where months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd'))/12 between 20 and 30;
12 select sname,sdept,round(months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd')),0)/12 nianlin from student where months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd'))/12 <20 or months_between(sysdate,to_date(sbirthday,'yyyy-mm-dd'))/12>30;
13 select sname,ssex from student where sdept in ('xinxi','shuxue','jisuanji');
14 select sname,ssex from student where sdept not in ('xinxi','shuxue','jisuanji');
15 select * from student where sno like '95001%';
16 select sname,sno,ssex from student where sname like 'liu%';
17 select sname from student where sname like 'ouyang%' and length(sname)=6;
18 select sname,sno from sutdent where substr(sname,2,1)='yang';
19 select sname from student where sname not like 'liu%';
20 select cno,ccredit from courses where cname like 'C%';
21 select cno,credit from courses where cname like 'H%' and substr(cname,length(cname)-3,1)='T';
歇會....................
22 select sno,cno from sc where cno in (select cno from courses where cpno is not null) and grade is null;
23 select sno,cno from sc where grade is null;
24 select sname from student where sdept='jisuanji' and (months_between(sbirthday,sysdate)/12)<20;
25 select sname,ssex from student where sdept='jisuanji' or sdept='shuxue' or sdept='xinxi';
26 select sno,grade from sc where cno='3' order by grade desc;
27 select * from student order by sdept asc,sbirthday desc;
28 select count(1) from student;
29 select count(sno) from sc where cno in (select cno from courses where cpno is not null);
30 ...........
PS : courses 那個表好像建表的時候多打了個s
⑤ 計算機三級考試資料庫上機考的是什麼題型
題型為選擇題，填空題，設計與應用題。
三級資料庫技術上機考試，120分鍾，滿分100分。選擇題40分，填空題30分，設計與應用題30分；三級資料庫技術證書為深藍暗紫色。
自2018年3月考試起改變三級獲證條件要求，考生只需通過三級考試即可獲得該三級科目的合格證書，不再要求二級證書。考生早期獲得的證書，不嚴格區分語言程序設計和資料庫程序設計，可以直接報考三級。考試時間和形式要求三級考試時間為120分鍾；考試形式為無紙化。
(5)資料庫上機考試期末擴展閱讀：
計算機三級考試要求規定：
1、考生不受年齡、職業、學歷等背景的限制，均可根據自己學習情況和實際能力選考相應的級別和科目。
2、考生在考點現場報名時，需出示身份證以及繳納相關的考試費。考生一定要親自到場，不能由任何單位、個人代勞。考生按要求進行信息採集，並逐一核實報名表上的個人信息。
3、考生採取網上報名方式，需先在所在省份的網上報名系統注冊並填報相關基本信息、上傳正面免冠電子近照，然後網上繳費或至指定地點繳費並確認身份信息，完成報名。
⑥ 資料庫上機考試、跪求大神 跪求答案、、
1.select sno from spj where sno=j1;
2.select sno from spj where sno=j1 and pno = p1;
3.select sno from spj where sno = j1 and pno in ( select pno from p where color = red)
4.select jno from spj where sno not in ( select sno from s where city = tianjin)
And pno not in ( select pno from p where color = red)
5.select sname city from s
6.select PNAME，COLOR，WEIGHT from p;
7.select jno from spj where sno = s1;
8. select pname ,qty from spj as a ,p as b where a.pno = b.pno and jno = j2
9. select pno from s , spj where s.no = spj.sno and city = shanghai;
10. select jno from s , spj where s.no = spj.sno and city = shanghai
11.select jno from s , spj where s.no = spj.sno and city ! = tianjin
⑦ 資料庫期末是筆試還是上機考
大部分學校的考試是筆試，資料庫也不例外，有部分是學校的考試是在線考試，這個要看情況。