数据库工程师-(44)

67 1 OLAP A B C D 2 A 1 B 2 C 3 D 3 SQL Server 2000 T T U1 Guest T A B C D 4 A B C D 5 A B C D 6 OLAP OLTP A OLAP OLTP B OLAP OLTP C OLAP OLTP D OLAP OLTP 7 DBA A B C D 8 A B C D 9 A B C D 10 A B C D 11 A B C D 12 A 0 B 1 C 0 1 D 13 Executive E Supervisor S Kernel K User U A SKEU B SEUK C KSEU D KESU 14 A B C D 15 T0 T1 Tn T0 T1 A T1 T2 A2 Tn 1 Tn An Tn T0 A0 A B C D 16 A B C D DBMS 17 SQL Server 2000 public public A B C D 18 A B C D 19 A ALTER TABLE ADD CHECK B UPDATE SET C INSERT INTO VALUES D CREATE TRIGGER TRION FOR INSERTAS UPDATE SET a a FROM a JOIN INSERTED b ON a b AND a b 20 A B C D 21 A B C D 22 Windows NT Servet nt user sysadmin A EXEC sp addrole Server nt user sysadmin B EXEC sp addsrvrolemember Server nt user sysadmin C ADD sp addrole Server nt user sysadmin D ADD sp addsrvrolemember Server nt user sysadmin 23 A B C D 24 Executive E Supervisor S Kernel K User U A SKEU B SEUK C KSEU D KESU 25 A B C D 26 A B C D 27 A B C D 28 SQL Server 2000 MyDB bk bk A RESTORE DATABASE MyDB FROM bk WITH FILE 1 NORECOVERY RESTORE DATABASE MyDB FROM bk WITH FILE 3 NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE 4 B RESTORE DATABASE MyDB FROM bk WITH FILE 1 NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE 2 NORECOVERY RESTORE DATABASE MyDB FROM bk WITH FILE 3 NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE 4 C RESTORE DATABASE MyDB FROM bk WITH FILE 1 NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE 2 RESTORE DATABASE MyDB FROM bk WITH FILE 3 NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE 4 D RESTORE DATABASE MyDB FROM bk WITH FILE 1 RESTORE LOG MyDB FROM bk WITH FILE 2 RESTORE DATABASE MyDB FROM bk WITH FILE 3 RESTORE LOG MyDB FROM bk WITH FILE 4 29 A B C D 30 A B C D 31 Student Sno Sname Ssex Sage Sdep t SC Sno Cno Grade Course Cno Cname Cpno Ccredit 1 5 1 5 SELECT Sname FROM Student WHERE NOT EXISTS SELECT FROM Course WHERE SELECT FROM SC WHERE AND 32 I O Table Goods GoodsName GoodsClassID SaleUnitPr ice Table GoodsClass GoodsClassID GoodsClassName City SELECT GoodsName SaleUintPrice FROM ON a GoodsClassID b GoodsClassID WHERE SaleUnitPrice SELECT FROM Table Goods c JOIN Table GoodClass d ON WHERE GoodsClassName AND 35 37 CREATE VIEW V1 AS SELECT FROM GROUP BY 38 REDO UNDO A B A B 39 SQL Servet 2000 CREATE PROC p Sum year INT AS SELECT WITH TIES SUM AS AS FROM JOIN ON WHERE year year GROUP BY ORDER BY 40 UML 41 Table priceHistory ID VARCHAR 8 GoodsNam e VARCHAR 20 StartDate DATETIME EndDate DATETIME StartDate SaleUnitPri ce MONEY Teachers SQL TOP 42 Employees Eid Name DeptNO Departments DeptNO DeptName TotalNumber Employees Departments SQL Server Tansact SQL Employees 1 43 S Sno Sname Status City P Pno Pname Weight Color J Jno Jname City SPJ Sno Pno Jno QTY SQL QTY 300 500 S1 1 A A 2 A 3 B Grant 4 A 5 C 6 B OLAP OLTP OLAP 7 B DBA Oracle Microsoft SQL server DBA DBA 8 B 9 A 10 C DBS DB DBMS DBAS DBMS DB 11 C 12 B 1 13 D 14 B 15 D 16 D 17 C Public public public public public 18 A A 19 D D 20 B 21 C 22 B sp addsrvroleme mber sp addsrvrolemember loginame login rolename role loginame login rolename role 23 C NULL 24 D 25 A 26 C E R C 27 C 28 A 29 C 30 B 31 NOT EXISTS Sno Student Sno Cno Course Cno 32 CLUSTER 33 Table GoodsClass a JOIN GoodsClass b 34 AVG SaleUnitPrice 35 c GoodsClassID d GoodsClassID 36 GoodsClassName 37 38 39 40 41 42 AVG SQL AVG 43 UNDO REDO 44 TOP 3 SUM DESC n TOPn SUM DESC 45 46 CREATE TABLE Table PriceHistorv ID varchar 8 NOT NULL GoodsName varchar 20 NOT NULL StartDate datetime NOT NULL EndDate datetime NOT NULL SaleUnitPrice Money NOT NULL CHECK EndDate StartDate PRIMARY KEY ID StartDate EndDate SELECT TOP 3 WITH TIES ID GoodsName SaleUnitPrice FROM Table PriceHistory a JOIN Table PriceHistory b ON a ID b ID ORDER BY SaleUnitPrice DESE 47 create trigger sq1 tri on employees for insert as declare eid varchar 11 declare name varchar 20 declare deptno varchar 11 declare yjy cursor for select from inserted open yjy fetch next from yjy into eid name deptno while fetch status 0 begin update departments set totalnumber totalnumber 1 where deptno deptno fetch next from YJY into eid name deptno end close yjy deallocate yjy 48 SELECT FROM SPJ WHERE QTY BETWEEN 300 AND 500 SELECT Jname FROM J WHERE Jno IN SELECT Jno FROM SPJ WHER