数据库工程师 (80)

13 A B C D 1 A B C D 2 A B C D 3 A B C D 4 T1 T2 data SLOCK data data S UNLOCK data data A B C 1 T1 X D 2 T2 data 5 A B C D 6 SQL Server 2000 A SELECT SELECT INSERT DELETE UPDATE B db datareader db datawriter C SELECT SELECT INSERT DELETE UPDATE D db owner 7 A B C D 8 A B C D 9 A B C 1 n D n 10 R U U X Y Z U Z U X Y A X Y T Y X T B X Y X Z C XY X Y D Z X Z 11 SELECT ORDER BY A OEDER BY B SELECT ORDER BY C ORDER BY D ORDER BY 12 A B C D 13 SQL Server 2000 A B C D 14 A B C D DBMS 15 A B C D 16 A B C D 17 A B C D 18 SQL A AGE IS NULL B AGE IS NOT NULL C AGE NULL D NOT AGE IS NULL 19 UML 10 A B C D UML 4 20 ID ID A B C D 21 Windows NT Server nt user sysadmin A EXEC sp addrole Server nt user sysadrnin B EXEC sp addsrvrolemember Server nt user sysadmin C ADD sp addrole Server nt user sysadmin D ADD sp addsrvrolemember Server nt user sysadmin 22 A B C D 23 S Sno Sname Ssex SC Sno Cno Grade C Cno Cname Teacher S SC C LIU SQL A SELECT Sname FROM S SC C WHERE S Sno SC Snn AND SC Con C Con And Teacher LTU AND Seex F B SELECT Sname FROM S WHERE Ssex F AND Sno IN SELECT Sno FROM SC WHERE Cno IN SELECT Cno FROM C WHERE Teacher LIU C SELECT Sname FROM S WHERE Ssex F AND EXISTS SELECT FROM SC WHEPE SC Sno S Sno AND EXISTS SELECT FROM C WHERE Teacher LIU D SELECT Sname FROM S WHEPE Ssex F AND EXISTS SELECT FROM SC WHERE SC Sno S Sno AND EXISTS SELECT FROM C WHERE C Cno SC Cno AND Teacher LIU 24 OLAP OLTP A OLAP OLTP B OLAP OLTP C OLAP OLTP D OLAP OLTP 25 A B C D 26 A T Q Q X B T Q S Q S C T Q S Q S D 27 A B C D 28 A X S B DBMS C D 29 24 7 2 A B 2 tw tw C 2 tw tw D 30 A Informix Universal Server B DB2 UDB C ObjectStore D Oracle9i W C P S G T R C P S G T R F C G S C G T R C T P R T S R w 1 W 2 W 3 W1 C P W2 S C G W3 S T R C W1 3 W 4 W3 5 2 6 3 BT S SQL 7 4 8 5 U4 STUD XH SQL 9 SC S C Grade SELECT 10 FROM SC 11 COURSE CNO CNAME TNO TEACHER TNO TNAME DEPART 5 SELECT TNAME FROM TEACHER WHERE 12 SELECT X TNO FROM COURSE X COURSE Y WHERE 13 14 15 1 SQL BORROWER 105060911 98 1 106880112 98 1 105080103 98 2 104230891 05 4 LOANS 105060911T001011999 04 01 106880112T001021999 05 01 105080103T002011999 05 3l 104230891T001022010 1 23 BOOKS TP311 13 T00101 19 00 TP311 13 T00102 19 00 TP 065 T00201 6 50 TP 1599 T00101 18 50 5 SSP 2 E R E R 1 C E R C 2 B 3 A 4 C T1 A S T2 A S T1 A T2 18 X 5 B 6 A db datareader db datawriter 7 C 8 D 9 D IDEF1X 1 n n 10 A R U U X Y Z U Z U X Y R U X Y R U r x z Y x z B B 11 C ORDER BY 12 B 13 C 14 D DBMS 15 B 16 B 17 A 18 C AGE NULL SQL 19 B 20 B Clastering Index Nonclustering Index Dense Index Sparse Index Primary Index Secondary Index 21 B sp addsrvrolenle mber sp addsrvrolemember loginame login rolename role loginame login rolename role 22 D 23 C 24 B OLAP OLTP OLAP 25 D i 26 D 27 B 28 D DBMS 29 A 30 C Informix Informix Universal server IBM DB2 UDB Sybase Adaptive server orack Orack 8i SQL Server 1 T S P 2 1NF 3 4NF 4 1NF 5 3NF 6 7 DROP VIEW BT S CASCADE DROP dELETE CASCADE 8 9 REVOKE UPDATE XH ON STUD FROM U4 10 C COUNT S 11 GROUP BY C 12 TNO IN 13 X CNO Y CNO 14 GROUP BY X TNO 15 HAVING COUNT X CNO 5 1 AELECT LOAR COUT AS FROM BORROWER LOARS WHFRE BORROW LOANS GROUP BY LOANS HAVING COUT 5 SELECT FRON IBORROWER LOARS BOOKS WHERE BORROWER LOANS AND LOANS BOOKS