数据库工程师-(45)

66 1 CPU A B C D 2 A B C D 3 A B C D DBMS 4 OLTP A B C D 5 A B C D 6 Windows Server1 nt user A EXEC sp revokelogin Servet 1 nt user B DELETE sp revokelogin Server1 nt user C DROP sp revokelogin Server1 nt user D EXEC sp droplogin Server1 nt user 7 Internet A B C D 8 SQL Server 2000 ACCT A ACCT dbcreator B ACCT public C ACCT db owner D ACCT db ddladmin 9 A B C D 10 SQL A B REVOKE C D COMMIT 11 A B C D SQL Servet money bigmoney smallmoney 12 A B C D 13 R U U X Y Z U Z U X Y A X Y T Y X T B X Y X Z C X Y Y X D Z X Z 14 DBS A B C D 15 C ZG ZGDA DBF C ZG ZGJJ DBF A SELECT FROM C ZG ZGDA C ZG ZGJJ WHERE DA JJ B SELECT DA DA DA JJ FROM C ZG ZGDA C ZG ZGJJ WHERE DA JJ C SELECT DA DA DA JJ FROM C ZG ZGDA C ZG ZGJJ D SELECT DA DA DA JJ FROM C ZG ZGDA C ZG ZGJJ FOR DA JJ 16 A B C D 17 A B C D 18 A CPU I O B C D 19 A B C D A B R B 20 E R A B C D 21 A B C D 24 22 t1 t2 t1 t 2 t2 A t1 t1 t2 t2 B t1 t1 t2 t2 C t1 t1 t2 t2 D t1 t1 t2 t2 23 SQL Server 2000 A model B master C userdb D msdb 24 A B C D 25 Indexing A B C D 26 DBMS A B C D 27 Information A SELECT FROM Information WHERE s name B SELECT FROM Information WHERE s name LIKE C SELECT FROM Information WHERE s name LIKE D SELECT FROM Information WHERE s name LIKE 28 ER A ER B ER C ER D ER 29 A B C D 30 A B C D 31 32 DDL DDL 33 34 SELECT FROM 35 Course Course Cname DB i SELECT FROM Course WHERE Table Card CardID CardName Score 500 1000 H Y Card AS SELECT FROM Table Card WHERE COURSE CNO CNAME TNO TEACHER TNO TNAME DEPART 5 SELECT TNAME FROM TEACHER WHERE SELECT X TNO FROM COURSE X COURSE Y WHERE SCORE Sno Cno Degree SELECT FROM SCORE WHERE Degree 39 SP Sno Pno Qty Sno Pno Qty 168 SQL FROM SP SPX WHERE SELECT FROM SP SPY WHERE AND NOT EXISTS SELECT FROM SP SPZ WHERE 40 E R E R 3NF 41 2005 12 10 2005 1 2 10 150 00 2005 12 10 2005 12 10 37 00 2005 12 10 2005 12 10 2 50 2005 12 10 2005 12 11 98 00 R R R R 3NF DEPT DeptNO DeptName Teacher TNO TName Course C NO CName Credit Student SNO SName Sex 48 E R 49 E R 3NF 1 D 2 B 3 D DBMS 4 D OLTP 5 C 6 A SQL Server sp droplogin Windows sp revokelogin DELETE DROP 7 C 8 A dbcreator ACCT dbcreator 9 A 10 A REVOKE COMMIT 11 D 4 4 SQL Server money smallmoney 12 B 13 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 14 D DBS 15 D SELECT FROM WHERE where 16 C 17 D 18 D D 19 D A B R A D 20 B E R 21 A 22 D t1 t2 23 C userdb SQL Servet2000 24 A 25 C Indexing C 26 D DBMS 27 D information SQL SELECT FROM Information WHERE s name UKE LIKE NOT LIKE 28 C 29 B 30 C 31 32 DDL DDL 33 34 COUNT DISTINCT 35 CnameLIKE DB ESCAPE LIKE ESCAPE 36 CREATE VIEW HY Card 37 Score BETWEEN 500 AND 1000 38 WITH CHECK OPTION 39 TNOIN 40 X CNO Y CNO 41 GROUP BY X TNO 42 HAVING COUNT X CNO 5 43 Sno as cno as degree as 44 SELECT MAX Degree FROM SCORE AS AS 45 SELECT Sno NOT EXISTS SPY Sno 168 SPZ Sno SPX Sno AND SPZ Pno SPY Pno 46 E R E R 3NF 47 R R 1NF R R1 R2 48 E R 49 3NF DEPT DeptNO DeptName DeptNO Teacher TNO TName DeptNO T