❶ 資料庫 試題
一、1.B 2.B 3.A 4.B 5.B 6.D 7.D 8.A 9.B 10.C 11.D 12.B 13.C
二、21.查詢 22.授權機制 23.DROP 24.聯系 25.定義 26.日誌文件
後面幾道接觸較少，讓高手來補足吧
❷ 資料庫操作題，求大神。只要答案不需要解釋
用 sql 的 DDL 語言創建 S 表，SNo 為主鍵，SN 不能為空。 CREATE TABLE S1 ( SNo CHAR(6) NOT NULL CONSTRAINT PK_S PRIMARY KEY, SN CHAR(6) NOT NULL, Sex CHAR(2), Age INT, Dept CHAR(20) );
創建計算機系學生的視圖，該視圖的屬性列由學號、姓名、課程號和任課教師號組成。 CREATE VIEW FROM WHERE AND AND S,SC,TC S.SNo = SC.SNo SC.CNo=TC.CNo S.Dept = '計算機'; V_COMS(SN0,SN,CNo,TNo) AS SELECT S.SNo, SN, SC.CNo, TNo
3.檢查計算機系年齡在 20 歲以上的學生學號。 SELECT SNo FROM S WHERE Age >20 AND Dept = '計算機';
4.檢索姓王的教師所講課程的課程號及課程名稱。 SELECT TC.CNo, WHERE AND AND CN FROM T, TC, C T.TNo = TC.TNo TC.CNo = C.CNo T.TN LIKE '王%';
5. 檢索張三同學所學課程的成績、列出 SN,CNo 和 Score。 SELECT SN, SC.CNO, FROM WHERE AND S, SC S.SNo = SC.SNo SN = '張三'; Score
6. 檢索總收入超過1000 元的教師所講課程的學生姓名、課程號和成績。 SELECT FROM WHERE AND AND AND SN, SC.CNo, Score S, SC, TC, T S.SNo = SC.SNo SC.CNo = TC.CNo TC.TNo = T.TNo (COMM + SAL ) > 1000;
8.S1 同學選修了 C3，將此信息插入 SC 表中。 INSERT INTO 或 INSERT SC VALUES('S1','C3',null) SC(SNo,CNo) VALUES('S1','C3') INTO
10.刪除 S 表中沒有選修任何課程的學生記錄。 DELETE FROM S WHERE SNo NOT IN( SELECT DISTINCT SNO FROM SC );
❸ 資料庫期末考試題 編寫SQL語句 1.創建一張學生表，包含以下信息，學號，姓名，年齡，性別，家庭住址，聯系
create table 學生表
(
學號 char(10) primary key,
姓名 char(10),
年齡 int,
性別 char(2) check (sex IN ('男','女')),
家庭住址 char(40),
聯系 char(20)
)
❹ 求大神，資料庫操作題
-- Create table
create table student
(
student_id varchar2(20),
student_name varchar2(20),
student_sex varchar2(20),
student_dept varchar2(20)
)
;
-- Create table
create table student_score
(
student_id varchar2(20),
course_num varchar2(20),
course_score number(20)
)
;
insert into student(student_id, student_name, student_sex, student_dept) values('2010', 'test', '女, '管理系);
delete from student where student_id = '05002';
update student_score set course_score = course_score + 5 where student_id = '13005';
select * from student where student_sex = '男 and student_dept = '管理系;
select * from student_score where course_num = 'A001' order by course_score desc;
drop table student;
前兩個是建表語句，後面六條是你要的答案
❺ 資料庫操作題
是foxpro?工作第一年有接觸，沒用多久，下面的主要提供SQL和方式方法，供借鑒。
1.select 姓名,簡歷 from zgda where 婚否=1 and 性別='女'
2.update zgda set 工資=工資+300 where 工資<1600
update zgda set 工資=工資+500 where 工資>=1600
3.delete zgda where id=8(這個其實不太記得foxpro怎樣刪除第八條記錄)
pack
4.select 姓名,工資 from ZGDA order by 工資 desc(分屏不知道foxpro怎樣實現)
5.select * from ZGDA where 姓名='王明'
❻ 資料庫期末考試
如下 （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
❼ 大一ACCESS資料庫的操作題，高手快來幫忙吧。
用匯總查詢，如下：
❽ 資料庫期末考試題 求答案 急！
--1
create database 學生選課系統
on primary
(name = 學生選課系統_data,
filename='d:\aa\學生選課系統.mdf',
size=8,
maxsize=100,
filegrowth=20%)
log on
(name =學生選課系統_log,
filename = 'e:\ee\學生選課系統.ldf')
--2
create table 學生
(學號 char(10) primary key,
姓名 char(20),
性別 char(2) check (性別 in('男','女')),
年齡 int default 20,
所在系 char(20))
--3
select 學號,年齡
from 學生
where 所在系='物理系'
--4
select 學號,成績
where 課程號='2'
order by 成績 asc,學號 desc
--5
select 學生.學號 學號,姓名,選修的課程名,成績
from 學生,課程,選課
where 學生.學號=選課.學號 and 課程.課程號=選課.課程號
--6
insert into 學生(學號,姓名,所在系)
values('96002','張三','英語系')
--7
update 學生 set 年齡=年齡+3
--8
delete from 學生
where 所在系='化學系'
--9
create view 英語系學生
as
select 學號,性別,年齡
from 學生
where 所在系='英語系'
--10
create unique index IX_課程號 on 課程(課程號)
--11
create trigger trig1 on 學生
for delete
as
declare @SID char(10)
select @SID=學號 from deleted
begin
delete from 選課 where 學號=@SID
end